![]() |
#1
|
|||
|
|||
![]()
I have a large spreadsheet where all the data comes out in the one go. I want to do the following:-
Find CY and copy all the data (columns A-L) up to DL but not including DL and put it on a new sheet named CY Find DL and copy all the data up to EU but not including EU and put it on a new sheet named CY Find EU and copy remaing data into a new sheet named EU. How would I do this? I am fairly new to macros so any help would be appreciated. I have attached a test copy of my data. |
Tags |
macro |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom icon, undo/redo for macro, permanent macro | Rapier | Excel | 0 | 08-05-2013 06:30 AM |
How do I assign a macro to a button when the macro is in my personal workbook? | foolios | Excel Programming | 2 | 07-27-2011 02:41 PM |