Hi, Im pretty new into programming with VBA in excel I got my code working but its just too slow.
Could you guys help me speeding up my task.
Sheet2 (database) has around 42.000 items and sheet1 (part of database) varies from 100 to 1000
Basicly I look for a value in 2 sheets when there is a match I copy the info into sheet1 from sheet2.
See my code below.
Would be nice to improve the code to replace sheet2 with an workbook.
Please Login or Register to view this content.
Bookmarks