I am trying to figure out how to populate a column from 1 sheet to another. Sheet 1 has about 39 columns that can contain a bunch of different quantities. I have 2 drop down menus right now that will select which column to activate. One box is location and the other is month. For example I will have a cell that will say LOCATION JAN voc report 2020. The “location” and “jan” will change depending on selection.
What I want to do is have a button that I click that will find which column I want based on the above, then take those numbers and multiply by a multiplier then add to another sheet.
I also have a pivot table the runs on some of the data that I need to move over as well.
Right now I have 39 different sheet 2 and I want to bring that down to 1.
I am thinking some sort of VLOOKUP but I don’t know the right way to write it so I don’t have use a formula on every cell.
If I have to use a formula on each cell, I am thinking something along the lines of an IF statement, but I don’t think office 365 will allow 39+ nested if statements.
What I want to do is have a button that I click that will find which column I want based on the above, then take those numbers and multiply by a multiplier then add to another sheet.
I also have a pivot table the runs on some of the data that I need to move over as well.
Right now I have 39 different sheet 2 and I want to bring that down to 1.
I am thinking some sort of VLOOKUP but I don’t know the right way to write it so I don’t have use a formula on every cell.
If I have to use a formula on each cell, I am thinking something along the lines of an IF statement, but I don’t think office 365 will allow 39+ nested if statements.