Hello,
Is there a template to achieve what I want to do in the title line?
I want to input my the folder from my desktop which holds the files I'd be looking to copy from and paste the 1st sheet of each workbook in that folder to a workbook I've saved else where.
I've searched the forum but there are a dozen of confusin solutions.
Any help would be appreciated.
Can you clarify your intention?
1) Import the first sheet from all the file in a single folder
2a) Imported sheets are placed into a workbook as sheets of their own?
2b) Imported sheets are placed into the same sheet with data stacked below each other.
3) Are there headers in each file to skip?
_________________
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