| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating new worksheets
I have a spreadsheet with a huge amount of data on one worksheet. I am
looking to put all data on a new worksheet whenever the data changes. Any idea how I could do this automatically? I would like to rename the worksheet as well to the date. Name Position Transaction Date Jimmy Test anything 20/04/2009 Jimmy1 Test1 anything 20/04/2009 Jimmy2 Test2 anything 20/04/2009 Jimmy3 Test3 anything 20/04/2009 Jimmy4 Test4 anything 20/04/2009 May any Test 20/04/2009 Shirley new anything 21/04/2009 Shirley1 new1 anything 22/04/2009 Shirley2 new2 anything 23/04/2009 Shirley3 new3 anything 24/04/2009 Shirley4 new4 anything 25/04/2009 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating sub worksheets | Excel Worksheet Functions | |||
| Creating worksheets | New Users to Excel | |||
| Creating old xls worksheets. | Excel Discussion (Misc queries) | |||
| Creating a log with info from worksheets...... | Excel Discussion (Misc queries) | |||
| creating a link between worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
