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.
Bookmarks