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?
24 freelance font une offre moyenne de $136 pour ce travail
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
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
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
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
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
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.
I have been into various Excel work even for several years, and I work mostly on Excel for various data computing.
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
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.
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.
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.
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 Plus
Dear sir, I am very interested to do this work. If I get chance to do this I do my best. Thank You....