Copy Paste macro
 

Would like to create a macro that would allow me to highlight certain rown of
data and paste it to another worksheet. The rows would be different each time
I run the macro so I need to be able to highlight the rows. Or is there an IF
statement that I could add to certain data in a sheet that the macro would
read and paste. Hope this question is not too confusing.
--
Gary Baker

Gary

Where do you want to paste it to?

The code to copy the highlighted cells would simply be

Selection.Copy

Excel then needs to know a destination for the data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"GWB Direct" wrote in message
...
Would like to create a macro that would allow me to highlight certain rown
of
data and paste it to another worksheet. The rows would be different each
time
I run the macro so I need to be able to highlight the rows. Or is there an
IF
statement that I could add to certain data in a sheet that the macro would
read and paste. Hope this question is not too confusing.
--
Gary Baker

want to paste the information into another spreadsheet. I only want to take
certain rows of data and paste it to another workshet.
Thanks anyway.
--
Gary Baker


"Nick Hodge" wrote:

Gary

Where do you want to paste it to?

The code to copy the highlighted cells would simply be

Selection.Copy

Excel then needs to know a destination for the data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"GWB Direct" wrote in message
...
Would like to create a macro that would allow me to highlight certain rown
of
data and paste it to another worksheet. The rows would be different each
time
I run the macro so I need to be able to highlight the rows. Or is there an
IF
statement that I could add to certain data in a sheet that the macro would
read and paste. Hope this question is not too confusing.
--
Gary Baker