lettuceplay
New Member
- Joined
- Aug 24, 2011
- Messages
- 5
Hello!
I have a couple workbooks: Promo1 and Promo2, with lists of customers that I've been trying to copy to a third workbook "AllClients". In the AllClients workbook I have sheets 1 and 2 to copy from Promo1 and Promo 2, by pasting "='[Promo1.xls]Sheet1!$A$1" across a few columns and down thousands of rows.
The problem is that the promo workbooks are updated weekly and the new clients have to be manually added into AllClients by pasting the formula down another row.
I read about Dynamic Named Ranges and the Index function, but I'm not too sure if I'm going in the right direction with that.
The Promo 1 and Promo2 workbook have headers in Row 1 - Client Name, Client Account Number etc
Is there a way to copy the Promo workbooks dynamically into the AllClients workbook?
Many Thanks!
I have a couple workbooks: Promo1 and Promo2, with lists of customers that I've been trying to copy to a third workbook "AllClients". In the AllClients workbook I have sheets 1 and 2 to copy from Promo1 and Promo 2, by pasting "='[Promo1.xls]Sheet1!$A$1" across a few columns and down thousands of rows.
The problem is that the promo workbooks are updated weekly and the new clients have to be manually added into AllClients by pasting the formula down another row.
I read about Dynamic Named Ranges and the Index function, but I'm not too sure if I'm going in the right direction with that.
The Promo 1 and Promo2 workbook have headers in Row 1 - Client Name, Client Account Number etc
Is there a way to copy the Promo workbooks dynamically into the AllClients workbook?
Many Thanks!
