S
snax500
In Excel2000, I have budget templates that different areas fill in. In
one cell, we have them input sales $ and in the cell below thye input
profit %. I want to make sure that everytime they enter a sales $ they
are forced to enter a profit %. I don't want to put in a formula in the
Profit % cell because they then will input over the formula. Here is an
example:
Jan
Sales $ 100
Profit % 8%
Sometimes they forget the Profit % and it causes problems, like this:
Jan
Sales $ 100
Profit %
Anyone have any ideas on how I can insure an input?
Thanks
one cell, we have them input sales $ and in the cell below thye input
profit %. I want to make sure that everytime they enter a sales $ they
are forced to enter a profit %. I don't want to put in a formula in the
Profit % cell because they then will input over the formula. Here is an
example:
Jan
Sales $ 100
Profit % 8%
Sometimes they forget the Profit % and it causes problems, like this:
Jan
Sales $ 100
Profit %
Anyone have any ideas on how I can insure an input?
Thanks