i want to copy a row of numbers that are generated by a formula and paste them to a location on a second sheet. I then want to go back erase the data that generated the numbers without eraseing the numbers posted to the second sheet and then insert new data and copy the result that to the second sheet one row below the pervious entry is there a way to do this? please help me!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
i need to write a certain macro
- Thread starter tommurray
- Start date
HalfAce
MrExcel MVP
- Joined
- Apr 6, 2003
- Messages
- 9,456
Hello tommurray, welcome to the board.
Sure, there are a number of ways to do that. A few questions for you first.
What row from the source sheet do you want to copy?
Which column(s) from that row get copied?
What is the destination sheet's name?
What column in the destination sheet do you want to paste to?
What range in the source sheet gets erased after pasting the formula results?
I assume when you say 'and then insert new data and copy the result' that you
mean you'll be entering that data manually. (yes?)
Sure, there are a number of ways to do that. A few questions for you first.
What row from the source sheet do you want to copy?
Which column(s) from that row get copied?
What is the destination sheet's name?
What column in the destination sheet do you want to paste to?
What range in the source sheet gets erased after pasting the formula results?
I assume when you say 'and then insert new data and copy the result' that you
mean you'll be entering that data manually. (yes?)
Upvote
0
