J
jlclyde
I have 6 columns of data and I am trying to transfer them to another
sheet. I need to have them grouped by their catalog number.
For instance
A = Item Number
B = Catalog #
C = Quantity
D = Unit Price
E = Amount to credit
F = Reason Code
Each row contains one item, with one cata log and so on.
If there are 9 items with 3 different catalog numbers, I woudl like to
be able to concatenate the item #s together if the catalog numbers are
the same and move them to another sheet. So it woudl add 3 rows to
the worksheet that they are being moved to. If you can show me some
code to do the item numbers, I can work our how to do the rest.
Thank you in advance,
Jay
sheet. I need to have them grouped by their catalog number.
For instance
A = Item Number
B = Catalog #
C = Quantity
D = Unit Price
E = Amount to credit
F = Reason Code
Each row contains one item, with one cata log and so on.
If there are 9 items with 3 different catalog numbers, I woudl like to
be able to concatenate the item #s together if the catalog numbers are
the same and move them to another sheet. So it woudl add 3 rows to
the worksheet that they are being moved to. If you can show me some
code to do the item numbers, I can work our how to do the rest.
Thank you in advance,
Jay