Attached is a workbook that needs the SUN to SAT data from the ActiveDays
Worksheet copied to the appropriate cells within the ID
In the ActiveDays worksheet, there is one row of SUN to SAT
data, for each major category, ID_Parent, within the ID worksheet. In the ID worksheet, there is the ID_Parent
column (Col A), with several other minor categories, or children (Col B), of the ID_Parent.
What is needed is a way, probably VBA, to copy the SUN to SAT data into each column, from the ActiveDays worksheet into the same fields of the ID worksheet, based on the Col A (ID_Parent) criteria. Rows 2 and 3 of the ID worksheet provide an example.
Therefore, if a cell in column A, within the ID
worksheet is ABCD, then the code would look for ABCD in the Activedays
worksheet, and copy the values from columns B to H into columns D to J of the ID worksheet.