LinkBack URL
About LinkBacks
ScreenHunter_019.jpg
I need a macro
1. open Book1.xlsm which name is kept at A2,
2. copy range G3:J5 of [Book1]Sheet!1 to B2:E4.
3. close this workbook and open next one at A5
4. copy G3:J5 to B5:E7 this time.
5. close and open next until end.
ScreenHunter_019.jpg
I need a macro
1. open Book1.xlsm which name is kept at A2,
2. copy range G3:J5 of [Book1]Sheet!1 to B2:E4.
3. close this workbook and open next one at A5
4. copy G3:J5 to B5:E7 this time.
5. close and open next until end.
Something like this:
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!)
Originally Posted by JBeaucaire
Something like this:
Please Login or Register to view this content.
Yes! except it is not copied from Sheet1!G3:J5 but from B2:E4. Simple fine tune is required. Thank you very much
I only want to copy the value from Book1.xlsm, but the macro copy both the value and formula. How to modify the macro?
Maybe:
Those ranges aren't the same shape?Please Login or Register to view this content.
Please do not REPLY WITH QUOTE. That's just clutter, use the quick reply box below. Thanks.
Exactly what I want, thanks.
Hi JBeaucaire,
Other than the cell values, I also want to copy the cell format, including conditional formatting. How to modify the Macro please?
Last edited by kent97; 10-22-2016 at 01:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks