Forum Discussion
Solved
Creating a Form
I have a workbook of 30 different tabs and I need a summary chart on a separate tab that will have a drop down list with the names of each tab so that when one is selected, only the data from that sp...
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.
Hi
I agree with the team mate who recommended that you post a sample file. Specially your request has lots of details and community members would recommend different options (Functions, Power Query, VBA...) for you to chose what works best according to your preferences and experience.
Good Luck
Nabil Mourad