Forum Discussion
Creating a Form
ineedhelp , okay, when in Summary tab
stay on C2, on ribbon Data->Data validation, select list and add names of your tabs as here
To count number of weekdays for the selected sheet in C3 formula
=COUNTIF(INDIRECT("'" & $C$2 & "'!B:B"), $B3)and drag it down.
To return value of the cell S77 in selected sheet in D3
=INDEX(INDIRECT("'" & $C$2 & "'!S:S"),76+ROW()-ROW($B$2))and drag it down.
Sample is attached.
ineedhelp , you are welcome
SergeiBaklan Me again. So the formatting of the chart needs to change a little bit. All of the data is going to be on one master sheet, but it will have multiple rows to choose from (see below)
Here is what the summary chart will look like. I put in references (DO2, CL2, and CO2) so you know where the information is coming from. The desired Revenue increase needs to be pulled from cell DP2, but it can change in that it's set at 20,000 right now but if I put 30,000 in cell C4 below, DP2 (above) should automatically update to 30,000, which would then update the amounts for Additional Softline (ES2), Additional Hardline (FA2), etc.
I didn't put cell references for the remainder of the sheet since I figured if I at least know how to do the references for a few of the cells, I can adapt them for the remainder.
I already have the drop down list set up, it just needs to know to go to a different row, rather than a different tab.
Hope this makes sense.