Mar 19 2023 08:19 PM
Hi,
I have an workbook excel file which the number of sheets are random, but the headers of the sheets will be consistent. i have also a sheet, which will have a dropdown list of all the sheets e.g. in cell A2.
Based on the value of the A2 (sheet selected), G9 should create a pivot table.
Is there any possible way to do this? if so, how?
I'm stuck after creating the dropdown list..
Mar 19 2023 11:38 PM
Here are the steps to create a pivot table based on a dropdown list that selects a sheet name:
I hope this helps!
Mar 20 2023 12:21 AM
Attached is to illustrate what @NikolinoDE says.
Apr 22 2023 12:49 AM