| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA/Macro help
All
I have a worksheet which has various col, what I would like to do is to be able to create a new worksheet dependant on data in COL D so for example i would like to be able to split Apples into one worksheet and then Pears ( along with the 40 other cols which relate to apples or pears) 184 apple 207 apple 208 apple 209 apple 184 Pears 207 Pears 208 Pears 209 Pears At first i thought pivot table but as i have to do this twice a month i thought VBA/marco - the previous person used to copy and paste and i think that just a waste of time.!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
| Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Threaded Mode
