Filling cells based on a pull-down

AliceSpark

New Member
Joined
Nov 6, 2019
Messages
1
Hi everyone! I have a spreadsheet we want to use as a sort of fillable form for non-tech savvy people to send us data in. The problem is, there are columns they don’t need to fill in depending on which one of several dozen selections is made in a different column. The original solution to this was to use conditional formatting to black out the un-needed cells based on the users selection. But now they want something that just prints “NA” in the un-needed cells. I figure that leaves me to coding the spreadsheet. Except the problem with using if statements throughout it is that the users will be typing right over top of the code and it will be lost the moment they do, so if they make any changes, the code is already gone. I can’t think of any other work around that would allow me to fill “NA” in a cell, based on another cells contents without putting code directly into the first cell. Any ideas? I have virtually no VBA code experience but I’m skilled at making complex functions.
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
609
You could use a IF statement in a helper column that is password protected?
 

Watch MrExcel Video

Forum statistics

Threads
1,102,557
Messages
5,487,541
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top