Dear All,
I am struggling with a macro that will:
Final result would be like that:
Company Name Entity Name
XXXXX AAAAA
XXXXX BBBBB
XXXXX CCCCC
YYYYY AAAAA
YYYYY BBBBBB
Could you please support me with some loop that can perform such aggregation?
Thank you in advance!
I am struggling with a macro that will:
- Find "Company name" in column B
- Copy value below "Company name" to row in a new sheet
- Then look for "Entity name" (can be multiple items) also in column B and assign entity name to Company Name
Final result would be like that:
Company Name Entity Name
XXXXX AAAAA
XXXXX BBBBB
XXXXX CCCCC
YYYYY AAAAA
YYYYY BBBBBB
Could you please support me with some loop that can perform such aggregation?
Thank you in advance!