Hello,
I have 2 Sheets:
In the first sheet in col B I have a unique account number
In the second sheet I have 10 columns. In column 3 I have the same number of in many rows (details on. F-R). It can be up to 5 thousand records in second sheet.
For each account from the first sheet I have to look up a matching number of account in second sheet and copy rows under a searched row from first sheet. It can be ca. 100 unique accounts in first sheet.
Then, for each account in first sheet I have to insert subtotals and grouping.
I have done that with "for... next" implemented many times. For sure to many and takes ages.
Probably better to use an array. Can somebody suggested me a solution with the use of arrays in this example.
Thank you,
s
I have 2 Sheets:
In the first sheet in col B I have a unique account number
In the second sheet I have 10 columns. In column 3 I have the same number of in many rows (details on. F-R). It can be up to 5 thousand records in second sheet.
For each account from the first sheet I have to look up a matching number of account in second sheet and copy rows under a searched row from first sheet. It can be ca. 100 unique accounts in first sheet.
Then, for each account in first sheet I have to insert subtotals and grouping.
I have done that with "for... next" implemented many times. For sure to many and takes ages.
Probably better to use an array. Can somebody suggested me a solution with the use of arrays in this example.
Thank you,
s