Hello all.
I have a closed workbook containing my data, C:\Data.xlsx on sheet 'Master Data'
This sheet is updated at regular intervals automatically every 5 mins or so. Therefore is must remain Closed as it will prevent the automated update from saving done by another computer.
On that sheet i will have several columns. Name, Time, Location, Count, Description
This list will go on for 400000 rows.
With the name there will be repeats, maybe 200 repeated names
Location will repeat with 7 names
In another workbook i want to use cell K1 as a filter based on names
Adding to this i want to use K2 as a filter for location
I would like to fill in the information in K1&k2 and then have a list of all the unique matching rows starting in A1
I have tried using a reference list to achieve this but found it made the file size very large and slow on calculating. i have also tried index match which was quite slow when listing a few thousands rows of matching results
I hope that someone could help. I do not mind copying the information to the open workbook to be calculated on but the data file must remain closed at all times.
Thankyou for your help in advanced.
I have a closed workbook containing my data, C:\Data.xlsx on sheet 'Master Data'
This sheet is updated at regular intervals automatically every 5 mins or so. Therefore is must remain Closed as it will prevent the automated update from saving done by another computer.
On that sheet i will have several columns. Name, Time, Location, Count, Description
This list will go on for 400000 rows.
With the name there will be repeats, maybe 200 repeated names
Location will repeat with 7 names
In another workbook i want to use cell K1 as a filter based on names
Adding to this i want to use K2 as a filter for location
I would like to fill in the information in K1&k2 and then have a list of all the unique matching rows starting in A1
I have tried using a reference list to achieve this but found it made the file size very large and slow on calculating. i have also tried index match which was quite slow when listing a few thousands rows of matching results
I hope that someone could help. I do not mind copying the information to the open workbook to be calculated on but the data file must remain closed at all times.
Thankyou for your help in advanced.