What is the quickest way to retrieve data from a "Saved Data" sheet and put it into a "Data Entry" sheet for editing?
The Saved Data sheet has 3 columns; 1) Date, 2) Product Key, and 3) Amt Sold. Columns 1 & 2 form a unique key for each row. There are currently over 40,000 rows of Saved Data. There are rows only for Products that have been sold (IOW no "0"s in the Amt Sold column).
The Data Entry sheet has over 200 rows of Products.
I have done this several times, but never with so much Saved Data and I'm concerned that my usual method of retrieving data will be too slow. I usually have a column ("Saved Data") on the Data Entry sheet with formulas to look for the values on the Saved Data sheet so when the user enters a date, Worksheet_Change() copies the data from the Saved Data column into the editing column.
I would prefer to just use formulas to locate the data to retrieve. I would also like to avoid having "N/A" anywhere in the worksheet.
Bookmarks