Monthly Budget?

T

The Wolf

I downloaded a template for a monthly budget.

If I save it as April 2004 I would like to copy sheet to May 2004.

I am having a problem figuring out how to delete the actual April expenses
when I create the May sheet.

I have selected the actual expense column and tried clear, this doesn't work
because it wipes out everything. I just want the numbers turned into 0 or
made blank.

Is there a way to find and replace? (anything that has a number, replace
with 0)

Or is there an easier way?
 
H

Harvey Waxman

The Wolf said:
Under paste special the only options I have are html, valu, text

It doesn't mention formulas?
Click to expand...

It sounds as if the cells you are copying have only values or text.

If there are no formulas to copy then I don't understand what you are trying to
do. What happened to the formulas in the original template that you are trying
to reproduce?

When you select a range of cells that contains formulas as well as text or
numbers you should have the option to paste formulas, formatting, values, all
etc.

I must have missed something from your post.


--
Harvey Products makers of Dinghy Dogs(TM)
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me
 
T

The Wolf

It sounds as if the cells you are copying have only values or text.

If there are no formulas to copy then I don't understand what you are trying
to
do. What happened to the formulas in the original template that you are
trying
to reproduce?

When you select a range of cells that contains formulas as well as text or
numbers you should have the option to paste formulas, formatting, values, all
etc.

I must have missed something from your post.
Click to expand...

There are formulas in the original, I don't have the option to paste
special/formulas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed duration task and associated time budgets....help 0
Setting up budget that tracks expendituresrelative to budgeted amount 1
How to automatically update a 12 month budget 5
Using current date track budget. 1
calculating % of a monthly budget on a daily basis 1
automatically update budget list from source 6
Finding specific value 0
How to find and replace text in a document with changing variables 2

Top