i need to write a certain macro

tommurray

New Member
Joined
Sep 23, 2006
Messages
1
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!
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

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?)
 

Forum statistics

Threads
1,171,827
Messages
5,877,775
Members
433,287
Latest member
amna_shahbaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top