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.
 

RasGhul

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

Forum statistics

Threads
1,078,464
Messages
5,340,462
Members
399,376
Latest member
Tresfjording

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top