Hello:
I have lots of excel files in Folder C:\Test\
Each of the file has the same data strcuture/format, data starts from Row3 down.
All files have data in Sheet1 with Data range A3:F down.
I need VB Code to go thru each of these files and consolidate data in single master sheet.
Please let me know if you have any questions.
Thanks.
R
Riz,
Have you looked at using Power Query. This is just the type of issues that Power Query can handle effectively. Here is a link to how to do this. Power Query is a free add in for Excel 2010
https://www.youtube.com/watch?v=a7E29H5ZUmE
https://trumpexcel.com/combine-data-...ple-workbooks/
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello alansidman:
Yes, Power Query can be very good tool.
In my situation, i need to pass this data and hence need VB for the purpose.
Please let me know if you have any questions.
Thanks.
Riz
Hello Riz,
Posting a workbook with a sample sheet would help us get started. Thanks.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Leith:
Attached are sample 3 files which are located at say C:\Temp\ folder
I need vb code to bring data from all 3 files (Sheet1).
Please let me know if you have any questions.
Thanks.
Riz
Hello Riz,
Much appreciated!
I know you said that you didn't want to use PQ, but I thought I would show you what it looks like based upon your sample files. If you add additional files to the folder, PQ will automatically append them to the worksheet once you click on the refresh button on the Data tab.
Hello alan:
After watching your link, i got tempted to use power query but some data did not import.
Same thing is happening with your attached file.
Look at data importd for file # "700033205.xlsx"..Column B and C data are missing.
Please check and let me know why is it doing this.
Thanks a lot, for great help.
Riz
I've never seen anything like that. I will look into this. Columns C and D are blank in the appended file. Yet if I import each file individually, then the data is there. Very strange.
Last edited by alansidman; 08-02-2019 at 05:41 PM.
Hi !
As the files attached have not the same structure : two with 6 columns and one has 7 columns …
Marc
BINGO!! This one was really driving me nuts and I never noticed the difference.
Thank you. I can now sleep peacefully tonight.
Alan
LoL ! Have a good night ! Oh, and thanks for the unexpected rep' !
The reason why I do not propose any code as the expected result workbook is missing again since the initial post …
Last edited by Marc L; 08-02-2019 at 07:25 PM.
Hello:
Oh, thanks a lot for finding out the issue.
I will work on it now to do Power Query.
Will let you know if any questions.
Thanks a ot
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks