VBA Splitting DataSet across two DataSets

Hi,

I have a spreadsheet with three sheets.
Sheet #1 is the Input sheet.
Sheet #2 and Sheet #3 are summaries (called 'Output-1' and 'Output-2').

Sheet #1 has six columns (with headers), under each column there are letters.

Task:

I need the information in Sheet #1 to be split across the two summary sheets using VBA.

For example:
In column 1.1.1 on the Input sheet we have the values 'a','b','c','d',and 'e'.

In the summary sheet 'Output-1' the value "1.1.1" needs to be put against 'a', 'c', and 'e'; and in summary sheet 'Output-2' the value "1.1.1" needs to be put against 'b' and 'd'.

This needs to be done for all six columns shown on the Inputs sheet.

Perceived Complications:
- The data from the Input sheet needs to be split across two summary sheets depending on the values in the columns.

- On the summary sheets, the values will need to be put into the next empty cell against the respective letter.

Thank your for any help you may provide, and if I have been unclear in any way please ask for more information.

Have a wonderful day,

Kindest regards,

Yaddles.

Hi Yaddles,

Try the below code ...

Please Login or Register  to view this content.