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.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
741
Office Version
  1. 365
Platform
  1. Windows
You could use a IF statement in a helper column that is password protected?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,195
Messages
5,768,779
Members
425,494
Latest member
Ragamacam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top