Ankit Chowdhary
New Member
- Joined
- Apr 5, 2022
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
Hi Experts,
Need help to print all combinations from a drop down list onto a pdf or a new excel sheet which will have all combinations in different sheets.
Just to explain. I have three sheets (1. NSV, 2. Volumes 3. NSV per ton) and have 2 data validation drop downs with the below combinations:
1. Arivia, Retail, Total
2. Core, FS, Total
Hence there are 9 combinations, and 3 sheets, so total of 27 pdfs should come up but all should be in one pdf file or we can also have 27 new sheets in a new excel file with all the combinations. Quick help is needed pls.
I was asked to refer to a solution but that is very different from my ask.. Request your help here as its very time consuming for me right now.
Need help to print all combinations from a drop down list onto a pdf or a new excel sheet which will have all combinations in different sheets.
Just to explain. I have three sheets (1. NSV, 2. Volumes 3. NSV per ton) and have 2 data validation drop downs with the below combinations:
1. Arivia, Retail, Total
2. Core, FS, Total
Hence there are 9 combinations, and 3 sheets, so total of 27 pdfs should come up but all should be in one pdf file or we can also have 27 new sheets in a new excel file with all the combinations. Quick help is needed pls.
I was asked to refer to a solution but that is very different from my ask.. Request your help here as its very time consuming for me right now.