Hi all
I am very new to arrays and wanting to use a better way to search a sheet for a value and copy the rows to a new sheet.
I currently have this code which works well but considering the sheet it is looking in as a lot of data, it takes far too long
What i am wanting it to look for a specific value (EMP_REF), and copy all rows to another sheet.Please Login or Register to view this content.
Any suggestions on how to make the data it is searching into an array?
Any help is much appreciated!
Bookmarks