I attached a sample file illustrated in the requirements.
In Sheet1 there are two range1: A1:K52 and range2 A55:K106
The macros should copy rows from range1 up to the LastRow from range 1 and from range2 up to the LastRow from range 2.
The Sheet2 has some text so the copied cell must be start from row 10.
The result must be seem as you can see in the sample file Sheet2.
Last edited by ccsmith; 10-14-2010 at 05:35 AM.
Like so, put this in a code module and connect it to your button:
Please Login or Register to view this content.
_________________
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!)
Please, avoid merged cells.
Please Login or Register to view this content.
Thank you. It is working.
JBeaucaire: Can you modify the VBA to copy only the values (if some cell contains functions I don't need the functions just the values)?
Please Login or Register to view this content.
Thank you for all answers.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks