Copy Paste macro

G

GWB Direct

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.
 
N

Nick Hodge

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
[email protected]
 
G

GWB Direct

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.
 
Top