Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I update a spreadsheet for a new season of records?
I use a spreadsheet to track fees paid by members of two different bowling
leagues. Is there an easy way to delete the information that was entered for last year and then change the dates for this season?? |
#2
|
|||
|
|||
why not create a spradsheet only with column or row headings and save it as
a template "Linda" wrote in message ... I use a spreadsheet to track fees paid by members of two different bowling leagues. Is there an easy way to delete the information that was entered for last year and then change the dates for this season?? |
#3
|
|||
|
|||
Linda
If you have formulas on the worksheet(s) you want to preserve....... Select all cells the EditGo ToSpecialConstants. Checkmark the constants you want to select and OK. With these selected, EditClear Contents. The dates you can replace using EditReplace. I would then save the file as a Template so's you don't have to do this again next year. Gord Dibben Excel MVP On Mon, 12 Sep 2005 19:56:01 -0700, "Linda" wrote: I use a spreadsheet to track fees paid by members of two different bowling leagues. Is there an easy way to delete the information that was entered for last year and then change the dates for this season?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update all formulas on spreadsheet - Apr05! to May05! | Excel Discussion (Misc queries) | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Automatic update of information in a spreadsheet | Excel Discussion (Misc queries) | |||
update link to other spreadsheet | Excel Discussion (Misc queries) | |||
How do I set up an excel spreadsheet to update every time a user . | New Users to Excel |