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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
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,136,266
Messages
5,674,727
Members
419,523
Latest member
Urnovio

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