Hi
I would like get the code for copying particular range( say("A3:P22")) from various excel workbooks and paste it in Master workbook one below the other.
Please help me out on this.
process will be like,
Open 1st workbook, copy data from a specific range then paste in master workbook, close 1st workbook, then open 2nd workbook copy range and the paste in master workbook.. and so on.
Regards
Prabhakar
Last edited by mettuprabhakar; 10-31-2012 at 01:18 AM. Reason: Unsolved Query
Does the master sheet already have a header? Is it in row 2?
Is the master sheet already having data? Before copying the fresh data, do you want the existing data to be cleared?
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