Hi, im working with to many rows (> 500,000) and several sheets or workbooks, using VBA which is the better and faster way to:
a) Loop rows in sheet 1 and add a value that i have to find in sheet 2 or other workbook. ( im using while ... loop with a match function to find the row of the value then with a specific column retrieve the value to add it )
b) Delete about 50,000 rows that match a criteria like empty cells in a columna A. (im using a filter and delete entire rows)
About 5 minutes to complete the process.. how can i reduce it?
Thanks!

a) Loop rows in sheet 1 and add a value that i have to find in sheet 2 or other workbook. ( im using while ... loop with a match function to find the row of the value then with a specific column retrieve the value to add it )
b) Delete about 50,000 rows that match a criteria like empty cells in a columna A. (im using a filter and delete entire rows)
About 5 minutes to complete the process.. how can i reduce it?
Thanks!
