Code works, but takes far too long

Hi all

This might be a long shot, but I am stuck for a quicker solution.....

Can someone help me with my code please? it currently takes two hours to run, or it crashes excel

Here are the summary points of what it does:
- Adds and re-names a new sheet for each row in the range
- Filters and copies results of each row (being employee number) to the newly created sheet
- Finds the most recent row for each employee position title by deleting the others (row by row, using the: 'if x = x.offest = x'
- Apply formulas to cells

I REALLY HOPE SOMEONE CAN GIVE ANY BIT OF HELP, EVEN IF IT'S TO CHANGE ONLY ONE PART!

Thanks in advance!

Please Login or Register  to view this content.

You could start by cleaning up your code.
Get rid of all the selecting.
This is an example from your code that is not required.

Please Login or Register  to view this content.

Structure your code.
You dimension all through the +/- 200 lines of code instead of at the beginning.
etc etc
I doubt anybody will dig through this mess (forgive me for being non political) and clean it up.
Google is your best friend.
A few examples for you.
https://stackoverflow.com/questions/...t-in-excel-vba
https://www.spreadsheetsmadeeasy.com...akes-to-avoid/
https://powerspreadsheets.com/excel-...sential-terms/
https://source.opennews.org/articles...-spreadsheets/
Most excel gurus have a tutorial on how to structure code also.

Thanks!, i really appreciate the tips!