I have two excel spreadsheets, the first is data imported and formatted from a text file, the second for reporting. The data file contains around 2000 lines of data (such as customer name, code, current balance, birth date, etc). The second file, contains a subset of this file, of around 500 'special' customers. They're the ones I'm interested in.
In the first spreadsheet, all the data is named as a range. I have a macro (in the second spreadsheet), which uses the range and a lookup formula to pick up data for these 'special' customers. "Special' customers are continually added / removed, in the report file.
The pain is that I have to enter data against all 2000 customers in the first spreadsheet, in case they're part of the 'special' group, a lookup is done, data imported, and then the report is emailed to a branch.
How do I pick only customers in the special group, for subsequent data entry? Maybe something like, I need code to read the customers in the second file, then create a new file to parse, or collect only those 500 or so special customers. I can then use this newly-created file to enter supplementary data in, for importing to the report file.
Any help most gratefully appreciated, I need this completed by Monday!
In the first spreadsheet, all the data is named as a range. I have a macro (in the second spreadsheet), which uses the range and a lookup formula to pick up data for these 'special' customers. "Special' customers are continually added / removed, in the report file.
The pain is that I have to enter data against all 2000 customers in the first spreadsheet, in case they're part of the 'special' group, a lookup is done, data imported, and then the report is emailed to a branch.
How do I pick only customers in the special group, for subsequent data entry? Maybe something like, I need code to read the customers in the second file, then create a new file to parse, or collect only those 500 or so special customers. I can then use this newly-created file to enter supplementary data in, for importing to the report file.
Any help most gratefully appreciated, I need this completed by Monday!