opazzo
Board Regular
- Joined
- Dec 21, 2005
- Messages
- 69
- Office Version
- 365
- Platform
- Windows
Hi there,
I have two sheets with a common key "CardName".
One sheet has properties (first table below) that I want to copy to the second sheet after the last column of the second table. The first row would be headers and the second row repeated for each item with the same card name.
The number of properties columns in the first sheet can vary for each CardName, but the number of rows is always 2.
The number of lines in the second table varies from 1 to nnn for each cardname.
The intended result would look something like this :
I'm looking for VBA suggestions as I would prefer to avoid writing many lookups. I'm also looking into namedranges and tables but cannot identify a good way forward.
Appreciate the inputs.
I have two sheets with a common key "CardName".
One sheet has properties (first table below) that I want to copy to the second sheet after the last column of the second table. The first row would be headers and the second row repeated for each item with the same card name.
The number of properties columns in the first sheet can vary for each CardName, but the number of rows is always 2.
The number of lines in the second table varies from 1 to nnn for each cardname.
The intended result would look something like this :
I'm looking for VBA suggestions as I would prefer to avoid writing many lookups. I'm also looking into namedranges and tables but cannot identify a good way forward.
Appreciate the inputs.