Starting a new year

[Theslaz]

Presently using Excel 2002 ( I know it's old ) I have a workbook set up
with 5 sheets; which I use to invoice my work and keep all the necessary
stats. My year end was May 31/2008. I kept a copy of the blank workbook
when I started my year last year on June 1/2007. However; I have made
numerous changes/improvements to the workbook over the past year. What I
would like to know; is there a easy way to delete the figures for last
year's invoices so that I basically have a blank workbook with all my
formulas and other improvements still in tact?

These are the sheets I have in my workbook:
Reference tables
Invoice data entry
Job pending and completion list
Print Invoice
Summary statistics

The "Invoice Data Entry" would be the sheet that I would want to amend.

 

[Bob Phillips]

Assuming that the data is all manually input, no formulae, and assuming it
is all nicely structured, you could just select all of the input range and
hit the delete key.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Theslaz]

Assuming that the data is all manually input, no formulae, and assuming it
is all nicely structured, you could just select all of the input range and
hit the delete key.

Been there done that! Too time time consuming. To easy to forget to
delete some entries and to easy to delete something that shouldn't.
Thought that there may be an easier way.

 

[MartinW]

Hi Slaz,

Possibly try this,

Tap F5
Click Special
Check Constants
Uncheck Text, Logicals and Errors (leave Numbers checked)
Click OK
Tap Delete

HTH
Martin

 

[Theslaz]

Hi Slaz,

Possibly try this,

Tap F5
Click Special
Check Constants
Uncheck Text, Logicals and Errors (leave Numbers checked)
Click OK
Tap Delete

HTH
Martin

I will try as you suggested. Will let you know.

 

[Theslaz]

Did as you suggested and it worked like a charm. There are some columns
that I use for comments/description of work; they did not delete;
however I can do that manually by selecting and using "Clear Contents".
I also have one column that I have a drop down list for my clients
names; it also did not delete. I can also do that manually. That is
unless you have a further suggestion. I did try leaving "Text" checked;
problem was; it deleted all my column names etc.

Thanks for your trouble.

 

[MartinW]

Hi,

Glad it worked. You can use the same process to select all comments
then right click on one of them and select clear comments.
That gets rid of them in one sweep.

If your dropdowns are done with Data Validation you can use the same
process to select them and then go to Data>Validation and select clear all.
Of course this will delete all validations that you have, so may not be
usable.
Also it won't delete the source data.

Apart from that, I think you are back to a manual tidy-up.

HTH
Martin

 

[MartinW]

Also it won't delete the source data.
Slight correction. If the source data has been typed in
directly into the Data Validation source box it will be
deleted but if it is inputted as a reference to certain cells
that contain the data then those cells will remain untouched.

HTH
Martin