Print all combinations from a drop down list onto a new excel sheet

[Ankit Chowdhary]

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 sheets should come up in a new excel worksheet with all the combinations.

I have data in 3 sheets namely - NSV, Volume and NSV per tonne and the combinations for each sheets are mentioned above Arivia, Retail, Total and Core, FS, Total

Hence for each sheet there is 9 combinations. If I could get the data from the sheets as well it would be great. There should be 9 sheets for NSV, 9 sheets for Volume and 9 sheets NSV per tonne with the above combinations.

I have received a solution from a member as pasted below but the issue is the data on the sheets is not coming up. The new sheets are coming blank. Also as I am very weak with macros, request help from someone on this.

Request your help here as its very time consuming for me right now.

 

[Fluff]

Duplicate to: Print all combinations from a drop down list onto a pdf or a new excel sheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.