Create an Excel Power Query Solution for Appending 100 Excel Files or Tables into one Consolidated Excel Workbook
$30-250 USD
Pagado a la entrega
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?
Nº del proyecto: #17867919
Sobre el proyecto
22 freelancers están ofertando un promedio de $136 por este trabajo
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 Más
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
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
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
hi, well i have done 100 + Power query projects so many of them with combine requirements but having different set of column headers "columns count" in each file !!! well this is i can call a very tough job w Más
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.
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) Más
Dear sir, I am very interested to do this work. If I get chance to do this I do my best. Thank You....
I am able to do this thing within 3-5 days i have already performed this type of thing earlier where i used to create a master data from almost 100 workbooks every time it runs but only thing is that currently i am hav Más
Hi, I work as a pricing analyst with ten years experience in using MS Office, especially excel and word. I automate reports at work all the time using SQL, power query and DAX. I was born in Aus.
Hi, I can do this job for you perfectly. Please consider my offer and give me a chance.. Thanks
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.
I have been into various Excel work even for several years, and I work mostly on Excel for various data computing.
If you give me a chance thats my first experience on free loncing IA you i will give my best