Copy Paste macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
(e-mail address removed)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy & Paste Macro 0
macros for copying external data to Excel 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Macro won't paste results 1
Macro - copy and paste value 3
Copying data to the next blank row 0
Macro to copy & paste-special-values data to selected worksheets 1
Multiple worksheet Copy Paste Macro 2

Back
Top