![]() |
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