Forum Discussion

Copper Contributor

Nov 22, 2019

Drop down formula to update multiple sets of columns based on what is selected

Hi all, Happy to join the community as I dont consider myself as an expert in excel, I have been able to get by for a while and am very interested in learning more after I ran into a problem that...

Example-Excel File.xlsx17 KB

Silver Contributor

Nov 22, 2019

Please attach your sample Excel file, specifying therein the location of the drop-down cell and the data to be manipulated.

MichaelBFromBC
Copper Contributor
Nov 28, 2019
Twifoo Sorry for the delay as my internet was out at my building for almost a week. I have attached an example excel file to show what I am trying to accomplish by having a drop down (list) on one tab that updates a column on the viewing page. My want is to be able to adjust all the numbers based on 2 columns and select what the adjustment is based on a drop down option being selected.
- Twifoo
  Silver Contributor
  Nov 29, 2019
  MichaelBFromBC
  Please clarify in which cells you need a formula for and explain the logic of each.
  - MichaelBFromBC
    Copper Contributor
    Nov 29, 2019
    Twifoo
    
    Yes, I am sure that will make it easier to digest.
    
    [Tab](Adding Gains) - Cell A15 is a drop down - The drop down is a list [Tab](Gains B1:P1)
    
    [Tab](Adding Gains) - If Drop down Cell A15 has Gain 2 selected I would like [Tab](Gains) C2:C11 numbers to copy to [Tab](Adding Gains) B2:B11
    
    Whenever the drop down is changed to a different "Gain 1, Gain 2, Gain 3, ect." I would like for that data to be present in that column.

Resources