Thread: Auto Populate Help

I am trying to find a non-vba way to auto-populate cells. For example.... if I have the text "NO" in cell G14, I want "N/A" to automatically populate in cell H14.......and have it be that way for the entire worksheet. So, it'd be the same for G15 and H15, G16, H16, etc....

Also...the same kind of concept, but just taken a little bit further. If I have the text "SS" in cell E11.... I would want "N/A" to appear in cells X11, Y11, Z11 and AA11.

It's really bugging me....I have so much more going on with this spreadsheet, and yet I can not figure out a way to make this happen. It seems like it should be rather simple.

Does anyone have any idea how to do this???

You're saying you don't want to do this with VBA...You know that VBA exists, so I'm finding it hard to believe you don't know that you could use an IF statement, but I'm going to suggest it anyway. In Cell H14

=IF($G14="NO","N/A","")

Copy the formula down.

For X11, Y11, Z11 and AA11

=IF($E11="SS","N/A","")

IF you have other values in the cells you want switched to N/A, you could also create a custom format of "N/A" and then use conditional formatting to force the N/A to appear. The requirement to get the N/A to appear in the cell would be that each cell would have to have a numeric value within it. Attached is an example of that.

Glad to help Which solution did you end up using? Also, if you this works for you, would you mind editing your original post and adding the prefix SOLVED to the title? And if you haven't already done so, it would really help me out if you'd click the scales on the right side of my post. Thanks!