Hi
Can anybody help with the below please.
I want to copy cells from 1 sheet to another based on the below:
The name of the worksheet to copy the cells from is in cell "O1" and I would like to copy them to the active worksheet. The cells I would like to copy are "R10" & "K12" and I would like to copy them to "J12" & "H10" on the active worksheet.
Thank you
Please make a copy of your workbook and test on the copy.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Hi Alvaro Siza
This works really well.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks