Recording Macro to auto-fill
 

On "Sheet 1" I have created a drop down menu which looks up the values on
Sheet 2. I presently have 4 columns which relate to the column before them
and I need to create a macro I am assuming to change the last 3 columns to
N/A if the 1st column is N/A.

Please Help!!!

Recording Macro to auto-fill
 

In what way are the 4 columns related to the column before them? If it
is by formula, then you could change it to something like this:

=IF($A2="N/A","N/A",your_formula)

This assumes that your N/A is a text value, and not the error #N/A.

Hope this helps.

Pete

On Jul 2, 9:29*pm, Zee wrote:
On "Sheet 1" I have created a drop down menu which looks up the values on
Sheet 2. *I presently have 4 columns which relate to the column before them
and I need to create a macro I am assuming to change the last 3 columns to
N/A if the 1st column is N/A.

Please Help!!!