Not allowing users to enter data into certain cells if another cell is empty

Hi,

I would like to NOT allow the user to enter any data into cells
J9:J1000 if cell J7 is empty and
K9:K1000 if K7 is empty and
L9:L1000 if L7 is empty and
M9:M1000 if M7 is empty and
N9:N1000 if N7 is empty and
O9:O1000 if O7 is empty and
All the way to
AG9:AG1000 if AG7 is empty

I was thinking I could do this with data valadation..but I could not get
that to work.

Maybe this can be done with VBA??

Any help is greatly appreciated.

Thanks,
Kimberly


.

Relevant Pages

  • Re: No solution - Macros
    ... I then want excel to turn the above table into a text string from which I ... As you say the cells that do not display a number are not empty so the macro ... So the macro is not dealing with non zero cells correctly. ...
    (microsoft.public.excel.programming)
  • Re: How to control how much gets printed (prevent printing blank rows)
    ... It sounds likely that that nothing is the same as an empty string. ... Instead of pre-filling a large range of cells with the formula, ... As you may have already considered, a VBA macro can also help us avoid the ... Microsoft Online Community Support ...
    (microsoft.public.excel.programming)
  • Re: VBA Code problem error 9
    ... I think you have to test for empty cells. ... > SO it is not necessary to test if the FirstRow and FirstCol is available as ... >> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: No solution - Macros
    ... Or the codes in the text string? ... So the job of the macro is to turn the above ... As you say the cells that do not display a number are not empty so the macro ...
    (microsoft.public.excel.programming)
  • Re: No solution - Macros
    ... I then want excel to turn the above table into a text string from which I ... As you say the cells that do not display a number are not empty so the macro ... So the macro is not dealing with non zero cells correctly. ...
    (microsoft.public.excel.programming)