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