I am trying to copy a range A11:Z21 into A4:Z4 one row at a time. I have a set of calculations in AA4:AZ4 then I want to paste value the results back into the corresponding row.
So first copy A11:Z11 into A4:Z4, then copy AA4:AZ4 and paste values into AA11:AZ11. Next copy A12:Z12 into A4:Z4, then copy AA4:AZ4 and paste values into AA12:AZ12 and so on for rows 11 through 21.
Thanks
Adrian
Give this macro a whirl:
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!)
Small typo in JB's code he may be offline as he's stateside so I've corrected below (red)
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks Don, I misread the OP, thought it as going back to the original data. My bad.
Thanks this worked great. Its so hard when you don't know the functions.
Adrian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks