Hi,
I have a spreadsheet that needs to pull certain information from another spreadsheet based on specific criteria (ex: store #). I would like to create a macro to perform the process to look into the file and retrieve the data. The amount of data would vary (some instances a few rows of data may need to be reviewed and other instances, the amount of rows with data may exceed 3K). In the attached file, Sheet 1 represents the file that would need to be accessed and Sheet 2 represents the file that where the macro would reside.
Sheet 1 (External File)
Cloumn A = Represents the store # that may reside in the destination file
Column C = Data to be populated in destination file if there is a match in store #
Sheet 2
Column B = Represents the store # that would reside in the external file
Column E = Would return the information in Column C of the external file based on a match of the store #'s (Column B of Sheet 2 compared against Column A of Sheet 1 or External File)
All other columns within each sheet are not relavant to the process I am looking for help on.
I currently have a INDEX/MATCH function written to pull the information and when I attempt to record this using the macro recorder and then copy down to account for an unknown number of rows, the time to process is in the range of 30 seconds to a minute.
Is there a simplier way to obtain the results I am looking form without the long process time?
Any help on this is much appreciated.
Bookmarks