Fermé

Create an Excel Power Query Solution for Appending 100 Excel Files or Tables into one Consolidated Excel Workbook

We have an Excel task to Combine 5 Excel WorkSheets across 100 WorkBooks that we are trying to solve with automation and the use of the Power Query Append Command. Do not respond to this project unless you can show us some actual examples of your Excel Power Query Workbooks which are working correctly.

Every 2 weeks we get between 75 and 100 individual WorkBooks named after a different person each of which contains 15 WorkSheets each with unique column headers for each WorkSheet only 5 of which are required for our consolidation process.

What we need to do is to combine the Worksheet data for everyone for every new time period into a Grand Total Universal Workbook with the 5 WorkSheets represented where each WorkSheet has ALL the data for ALL the person's in the current directory for the current period. And of course this list of person's will change for every time period, sometimes with new names and other times with 75% repeated names.

And of course, not ALL the worksheets always have exactly the same count of Column Headers across all persons for all the relevant time periods. But Power Query should handle this, correctly as I understand this.

But the Column Headers counts are usually very close each timeframe. Some of the Tabs have a dozen columns and some have perhaps 20, 30, 50 or even 175 columns in the worst case scenario. And all of these have to be handled correctly.

If we give you the sample Workbooks with only sample data for the 15 Worksheets, can you create a solution that we only have to point to a sub-directory containing the latest Workbooks every time period which will do the correct Appends into the Master Workbook for the 5 relevant Worksheet Tabs? Do not respond unless you have done this before this.

Is it possible to use the same sub-directory for the Input Workbooks hard-coded into the solution so it works with a fresh batch of Workbooks loaded into that directory for every time period going forward without any issues?

Compétences : Traitement de Données, Excel, Microsoft Office

en voir plus : excel consolidate text from multiple sheets, power query excel.workbook( content ), how to import data from multiple excel files into one, combine tables from multiple sheets in the same workbook with power query, excel query multiple sheets, power query combine multiple excel files, powerpivot multiple sheets, power query multiple sheets, create update query mysql, create power ranger, convert xml files tables, create power rangers, create symbian mobile sip setting configuration files, create multiple choice quiz using php mysql tables, create power ranger logo, convert word files tables, create 100 files, perl create 100 files, can create power look adobe ovation, create visual basic solution used insurance agents calculate

Concernant l'employeur :
( 10 commentaires ) North Providence, United States

Nº du projet : #17867919

25 freelance font une offre moyenne de $138 pour ce travail

schoudhary1553

Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Create an Excel Power Query Solution for Appending 100 Excel Files or Tables into one Consolidated Excel Workbook. I've Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(283 Commentaires)
7.6
avinav606lx

Hi there Why are you stressing on Power Query This can be done easily by using VBA scripting. Ping me to discuss more Thanks A

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(162 Commentaires)
6.4
Orientwork

I am a Data Entry/Data Processing Expert. I also have experience in word and excel. PDF to Word and Excel I know the value of time. I am very hard working and always deliver work on time

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(59 Commentaires)
5.0
sevillajk01

hello! I would love to help you with your project. Just share with me your sample workbook and will see what I can do. thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)
3.7
dataexplorer

"Hello, I am happy to inform you that I have read your project Create an Excel Power Query Solution for Appending 100 Excel Files or Tables into one Consolidated Excel Workbook description and understood all of your r Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(15 Commentaires)
3.5
ramizq922

Hi I have read your whole description and I'm able to do that in 3 days we have excel Excel & macro VBA expert team with 7 years experience Photoshop if you can see my work please check my portfolio Thanks & Regard Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
2.2
jamaljaved06

hey i will give you this project in just three days. i am beginer but hard worker. you feel pleasure to work with me.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
bilalniazi1712

Dear Sir/Madam, Hope you doing great.. I am data entry expert having 3+years of experience in data entry working with Microsoft Excel, Microsoft Word Being an expert, I can surely assist you with my service in ente Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
gracewanjiru360

excellent in Ms Excel, perfect presentation. Time conscious

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
kamillkh

Hello Sir We can worked ... I will understand your project and i will [login to view URL] on time... We can discuss about the budget and project. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
Owais1094

If you give me a chance thats my first experience on free loncing IA you i will give my best

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)
0.0
Arodaniel

I have been into various Excel work even for several years, and I work mostly on Excel for various data computing.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
saykovdi

BI, Data Science, R Script, Pythone, VBA, SQL BI - Microsoft Power BI, Tableau. Data collection, processing and structuring Formation of reporting of all kinds, automation of the compilation process. Analysis of Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
fizzahjawed

Expert Virtual Assistant (Word, Excel, PowerPoint) Hi, Hirer ! I'm Syeda.I am very excited to assist you in making your project successful. I am also flexible to all timezone . Another areas of my expertise: a) Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
Chathurakalinga1

Chathura kalinga Relevant Skills and Experience I have worked as IT officer

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
NgunoZ

I can complete the project in less than 3 days. Relevant Skills and Experience I have the required excel typing and pasting skills required for the project.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
dayangamage

Hi, I can do this job for you perfectly. Please consider my offer and give me a chance.. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
khansajol082

Hi.. I saw your ad for an excel expert.. I want to work with you on this if you will accept my proposal. Of course I cannot convince you to but I can give an assurance of a good job from me.. Thanks.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.0