How to create Macro For 100 sheet data into one master sheet
Every sheet having different column and different row (10 to 12 column & 130 to 160 Row)
I use simple method for create macro
first i do manually & record macro
No problem with different column but every sheet having different row that it was not works
Help me
how to give range last line
Range("A1").Select
Range("A21").Select
Range("A37").Select
See the code of this macro
Please Login or Register to view this content.
Last edited by arlu1201; 10-24-2012 at 04:57 AM. Reason: Use code tags in future.
You are saying that the sheets can have anywhere between 10 to 12 columns. Do you mean the headers (headings) are not the same for all sheets?
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks