Hi,
Can anyone help me with a macro which will help me collate data from multiple workbook saved in a particular location into a single worksheet. I have a data range which is not fixed in terms of number of rows and columns, then, how do i copy it. Currently i am doing it manually by selecting range using Ctrl + Shift + End. Can you suggest an VB code which will select the whole range in the sheet and paste it in the worksheet. Thank you very much.
VG
Hi-
Would it be possible if you can attach sample files for us to look?
Likewise, please be specific, do you want all the available cells to be copied including headers?
Regards,
event
'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.
The parts of the code that need to be edited are colored to draw your attention.
Last edited by JBeaucaire; 12-27-2019 at 10:43 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks