I'm trying to create a summary report that gets information from 5 other reports. The sumamry will contain information, on sales, forecasts, returns, pricing and item information.
The summary report contains the item information within itself in columns A-D and in rows 3 to around 20,000. I then have 3 columns relating to the sales report, 2 to the forecasting report, 2 to returns report and 3 to pricing report. All in making around 200,000 Vlookups, and it takes an age to open/update/save do anything!
Would there be a better way to approach the problem?
Cheers
Dan
The summary report contains the item information within itself in columns A-D and in rows 3 to around 20,000. I then have 3 columns relating to the sales report, 2 to the forecasting report, 2 to returns report and 3 to pricing report. All in making around 200,000 Vlookups, and it takes an age to open/update/save do anything!
Would there be a better way to approach the problem?
Cheers
Dan
