I am trying to create a new sheet combining various address fields from another sheet to make a master package list. If anyone could please perhaps help me get started, I would be beyond appreciative
My workbook has 2 sheets PM_Client Sample and PM_Client Sample_2. So far anything I have been able to write is based on a fixed input format, but unfortunately the inputs can vary so I am struggling to write a more dynamic code now.
Sheet PM_Client Sample setup described below - This is what I receive as my starting input
Headers in Row 1, records start in row 2.
Columns A-E contain contact details (could 1 be, or could be 1000)
Columns K & L list out the # of associated groups (could be 1 or could be 1000) and how they are shipped.
Col A = NAME
Col B = ADDRESS
Col C = CITY
Col D = STATE
Col E = ZIP
Col K = GROUP
Col L = SHIP
For each Group listed (starting in K2) I need to create create an address record on Sheet PM_Client Sample_2. So for example if there were 2 names listed in A-E with 8 GROUP/SHIP codes listed in K-L then I would want 16 new records created on the Sheet PM_Client Sample_2 (Each name and address would then be listed on this sheet 8 times with 1 row per Group)
On Sheet PM_Client Sample_2 paste values from Sheet PM_Client Sample into columns below
GROUP (from Col K on sheet Sheet PM_Client Sample) into Col E (starting in row 2 on Sheet PM_Client Sample_2)
SHIP (from Col L on sheet Sheet PM_Client Sample) into Col S (starting in row 2 on Sheet PM_Client Sample_2)
NAME (from Col A on sheet Sheet PM_Client Sample) into Col F (starting in row 2 on Sheet PM_Client Sample_2)
ADDRESS (from Col B on sheet Sheet PM_Client Sample) into Col G (starting in row 2 on Sheet PM_Client Sample_2)
CITY (from Col C on sheet Sheet PM_Client Sample) into Col H (starting in row 2 on Sheet PM_Client Sample_2)
STATE (from Col D on sheet Sheet PM_Client Sample) into Col I (starting in row 2 on Sheet PM_Client Sample_2)
ZIP (from Col E on sheet Sheet PM_Client Sample) into Col J (starting in row 2 on Sheet PM_Client Sample_2)
My workbook has 2 sheets PM_Client Sample and PM_Client Sample_2. So far anything I have been able to write is based on a fixed input format, but unfortunately the inputs can vary so I am struggling to write a more dynamic code now.
Sheet PM_Client Sample setup described below - This is what I receive as my starting input
Headers in Row 1, records start in row 2.
Columns A-E contain contact details (could 1 be, or could be 1000)
Columns K & L list out the # of associated groups (could be 1 or could be 1000) and how they are shipped.
Col A = NAME
Col B = ADDRESS
Col C = CITY
Col D = STATE
Col E = ZIP
Col K = GROUP
Col L = SHIP
For each Group listed (starting in K2) I need to create create an address record on Sheet PM_Client Sample_2. So for example if there were 2 names listed in A-E with 8 GROUP/SHIP codes listed in K-L then I would want 16 new records created on the Sheet PM_Client Sample_2 (Each name and address would then be listed on this sheet 8 times with 1 row per Group)
On Sheet PM_Client Sample_2 paste values from Sheet PM_Client Sample into columns below
GROUP (from Col K on sheet Sheet PM_Client Sample) into Col E (starting in row 2 on Sheet PM_Client Sample_2)
SHIP (from Col L on sheet Sheet PM_Client Sample) into Col S (starting in row 2 on Sheet PM_Client Sample_2)
NAME (from Col A on sheet Sheet PM_Client Sample) into Col F (starting in row 2 on Sheet PM_Client Sample_2)
ADDRESS (from Col B on sheet Sheet PM_Client Sample) into Col G (starting in row 2 on Sheet PM_Client Sample_2)
CITY (from Col C on sheet Sheet PM_Client Sample) into Col H (starting in row 2 on Sheet PM_Client Sample_2)
STATE (from Col D on sheet Sheet PM_Client Sample) into Col I (starting in row 2 on Sheet PM_Client Sample_2)
ZIP (from Col E on sheet Sheet PM_Client Sample) into Col J (starting in row 2 on Sheet PM_Client Sample_2)