dvenn
07-11-2006, 08:37 AM
no idea where to begin really but here's a shot...
I have a sheet with some data in it...
in A8:A38 I have some unique IDs, then in D29-D51 I have some grouping IDs
For each Group ID in D29-D51 I need to create a row containing the unique ID, group ID and some additonal information from cells B2:B4 & E29:F51
the data should be as follows (comma sep'ed for example). Example assumes there are two unique ID's existing in A8:A9 and two group IDs existing in D29-D30..
A8,E29,B2,B3,B4,D29 & " (" & F29 & ")"
A9,E29,B2,B3,B4,D29 & " (" & F29 & ")"
A8,E30,B2,B3,B4,D30 & " (" & F30 & ")"
A9,E30,B2,B3,B4,D30 & " (" & F30 & ")"
and so on .. (if more existed)
I would prefer macro versus formula (this could potentially get very large with a whole bunch of fomulas).
Thanks in advance for any assistance.
FYI, I have no problems realigning the data on the sheet to facilitate this objective so if it would work better with a different arrangement, please advise
dvenn
I have a sheet with some data in it...
in A8:A38 I have some unique IDs, then in D29-D51 I have some grouping IDs
For each Group ID in D29-D51 I need to create a row containing the unique ID, group ID and some additonal information from cells B2:B4 & E29:F51
the data should be as follows (comma sep'ed for example). Example assumes there are two unique ID's existing in A8:A9 and two group IDs existing in D29-D30..
A8,E29,B2,B3,B4,D29 & " (" & F29 & ")"
A9,E29,B2,B3,B4,D29 & " (" & F29 & ")"
A8,E30,B2,B3,B4,D30 & " (" & F30 & ")"
A9,E30,B2,B3,B4,D30 & " (" & F30 & ")"
and so on .. (if more existed)
I would prefer macro versus formula (this could potentially get very large with a whole bunch of fomulas).
Thanks in advance for any assistance.
FYI, I have no problems realigning the data on the sheet to facilitate this objective so if it would work better with a different arrangement, please advise
dvenn