ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Check cell (https://www.excelbanter.com/excel-discussion-misc-queries/80247-check-cell.html)

snax500

Check cell
 
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



All times are GMT +1. The time now is 01:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com