Macro slows down as it runs

[Dean Staples]

Ok I have built this Macro with little knowleadge so any tips would be appriecated.

the Macro gets the User to select the files to be used -it then saves the files with current date & time added to the name.

It then searchs thru 3 sheets in 1 workbook to see if a record is found in the other workbook,

If found it compares price to see if they are different

changes price if different and then writes entries on both sheets accordingly

these 3 sheets have 527 records, 1178 records & 25 records-IF i only search thru first sheet i can complete the updates in 5 mins on my laptop - 16 mins on my work PC

but when i get the macro to switch to the other sheets to update it slows dramtically taking close to an hour to complete on my laptop at home -at work it takes 3 hrs!!!

This is my code to update the first sheet -- to Do the others I simply set the correct price column and change the selected sheet then repeat the process.

Any suggestion / corrections welcome

Please Login or Register  to view this content.

[Dean Staples]

The Code shown looks at the first sheet only
- i simply change my price variable and the active sheet then repeat the code above to do the next 2 sheets
--in my attachment i have included the combined macro to step between sheets