VBA to append list

[B52]

I would like to get a VBA code to help me create timely a nested list on sheet 2 based on information on sheet 1. I cannot copy/paste so many names for each account.
On sheet1, I have in column A list of Accounts and in column B list of companies.
The code will take each account and repeat the name of the companies in the new sheet2. As a result, I can easily filter by Account or by Company name on the sheet 2 and be able to do all pivots. and lookup of the balance value from a system.

Column A Column B
Account #1 Company Name1
Accopunt#2 Company Name2
... ...

Etc etc

 

[Cubist]

I would like to get a VBA code to help me create timely a nested list on sheet 2 based on information on sheet 1. I cannot copy/paste so many names for each account.
On sheet1, I have in column A list of Accounts and in column B list of companies.
The code will take each account and repeat the name of the companies in the new sheet2. As a result, I can easily filter by Account or by Company name on the sheet 2 and be able to do all pivots. and lookup of the balance value from a system.

Column A Column B
Account #1 Company Name1
Accopunt#2 Company Name2
... ...

Etc etc

Can you post a sample data of what you're trying to achieve?

 

[B52]

Can you post a sample data of what you're trying to achieve?

Please see attached the sample on Sheet1 and expected result on sheet2..
I have add a total row for each account.

 

[Cubist]

Please see attached the sample on Sheet1 and expected result on sheet2..
I have add a total row for each account.

You're looking for "cross-join"

See this thread.