Must fill cells to start.

**leep18** · 03-23-2015, 11:50 AM

Hi,

i am wondering if anybody could advise me on the best method to ensure certain data is input prior to more information being inserted. my problem being is i can forsee reports coming in with missing information which will cause the job to be re-done at our expense. what i have been playing around with without success is as follows,

cells K5,K6,O6,N7 and J7 all need to be filled prior to any data being input in B9 or better would be B9:B78.

any help or guidance is greatly appreciated.

Regards

Lee

**6StringJazzer** · 03-23-2015, 12:30 PM

One simple way is to use Data Validation with a custom rule that says

Formula:

Please Login or Register  to view this content.

It will not allow you to enter data in the cell until the above condition is TRUE. You can apply the Data Validation to B9:B78.

A more sophisticated way is to use VBA and user forms to lead the user through the process, so that there is not even a place to enter certain data until other data has been provided. This needs to be very specific to your data, though, and you haven't provided enough information to give a complete solution.

**walruseggman** · 03-23-2015, 12:33 PM

Try this if looking for a pure VBA solution:

Please Login or Register  to view this content.

**leep18** · 03-23-2015, 04:00 PM

i have attached the sheet i have been working on for more information. i am a novice at excel formuals above the basics
so this is around a weeks worth of learning and trial and error.

would VBA be the best solution? The data in the cells K5,K6,O6,N7 and J7 are vital. Without
the platform number, station name and direction the data in the table is meaningless.

regards