Split Data into Multiple work sheet

[shelim481]

Hi Can someone help, I have a set of data in the attached workbook, Book1, what I am trying to do is create multiple sheets with all the possible combination of data, so, for example, T1 with Q1 then T1 with Q2 and so forth until all the combinations are done, as shown in the example workbook attached, I need a macro to do this for me autonomically.

[mehmetcik]

Please Login or Register  to view this content.

[shelim481]

Wow that's awesome, thank you, just one last bit is the data on side columns W/X and A/AA , any ideas?

[mehmetcik]

What are you asking?

[shelim481]

So, for example, it finds the same Q and T values on columns W,X and A,AA and moves those along to the correct tab.

[shelim481]

how do you delete the rows like the Columns, as you can see for the below VBA ive modified, it very easy to delete the exact same column in another sheet but to delete the same row in another sheet (Output), it is not as easy.

Please Login or Register  to view this content.

[mehmetcik]

Deleting rows is a lot easier.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or

or

Please Login or Register  to view this content.

[shelim481]

How would it work here? i keey getting errors

Please Login or Register  to view this content.

[mehmetcik]

Qs is an Array that lists all the Quarters listed in Column A of your sheet.

So if you change sheets

and use:

Please Login or Register  to view this content.

You are looking for A Quarter Label that may not exist so you could get errors.

[shelim481]

all i wanted was to delete the same rows in another sheet without looking for the same values. for example in info sheets it deletes rows 12 downwards for the first selection, i just wanted to delete the same rows without looking for it, in another sheet.

[mehmetcik]

Please Login or Register  to view this content.

[shelim481]

Awesome thank you