I have a folder with 30 files all named in numerical order. Sometimes it can be 40 or 50 files depends. I need to be able to search for the folder and click on the first file named 1 and have it know to keep copying from the other files by just clicking on the first file. The range that needs to be copied is the same in each file A1:A27. The I then need to paste all the ranges into a new excel sheet and have them offsetted. If anyone could help I would appreciate it.
Hello visualnewbie09,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
This is the Introduction Forum where no questions should be posted. If you start a thread in any of the other sub-forums, I´m sure it will not take long before your request will be solved there.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks