AAP
Member
Hi Everyone,
I need help to optimise my macro written. Actually this macro uses index and match functions. I have a database workbook of around 1,000,000 rows from which the macro searches to found records and paste in a new file. The new file is usually contain data of 100,000 + records.. It takes very long time. Someone suggest me to use memory instead of transact between sheets but I don't know how can I make it efficient.
Records to find is under Pink heading and records to placed after search is under yellow heading. Sample macro file uploaded. The database file is around 50 megabyte and therefore cannot upload.
I need help to optimise my macro written. Actually this macro uses index and match functions. I have a database workbook of around 1,000,000 rows from which the macro searches to found records and paste in a new file. The new file is usually contain data of 100,000 + records.. It takes very long time. Someone suggest me to use memory instead of transact between sheets but I don't know how can I make it efficient.
Records to find is under Pink heading and records to placed after search is under yellow heading. Sample macro file uploaded. The database file is around 50 megabyte and therefore cannot upload.