How can I consolidate data from n no. of workbooks (with similar format) into one worksheet? There can be any no of workbook present at any given point of time and the macro should be able to count the number of files available in the folder and run loop accordingly.
I was trying the following logic but it didnt work.
Please Login or Register to view this content.
Last edited by Leith Ross; 11-18-2008 at 01:33 AM.
Hello abhijit.pendharkar,
Welcome to the Forum!
To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.
How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.
As a new member please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...
Forum Rules
Sincerely,
Leith Ross
Hi
do you want J2 of each file to be listed or all filled cells of day1feedback sheet to be copied?
Ravi
all filled cells have to be copied. the above code was a trail code.
Hi
Save this file in the folder where from you want the data copied. run the macro
Ravi
working fine, thanks a ton!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks