| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data to new sheets
I have a long datasheet in Sheet 1. I would like to automatic put in a new
sheet in the workbook every time there is a new content in column D. If it is possible to name the sheet after the new contents it would be great. example: Anonym 25.11.2008 08:25 Jente Gausdal vg3 Anonym 03.11.2008 13:49 Jente Gjøvik vg3 Anonym 03.11.2008 13:49 Jente Gjøvik vg3 When the content Gausdal change to Gjøvik i want a new sheet in the woorkbook with the name Gjøvik conteining all data from column A to AC for all rows with Gjøvik in column D. I will be greatful for help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data to different sheets | Excel Worksheet Functions | |||
| copy data of different range to other sheets | Excel Programming | |||
| Copy data to sheets by name | Excel Programming | |||
| Copy data in new sheets from criteria using VBA | Excel Programming | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Threaded Mode
