combine and clean two macros

[deekar]

Hi, I have two macros that do a lot of the same things but both are slowing down excel, I have looked for quick and easy ways to combine and clean them but as a true beginner in VBA, I can't find the solution. If I post both here, can someone take a look at them and, hopefully, combine and clean it up. I am a true beginner and recorded the old fashioned way, then went into the vba and tried to clean both up individually so, they may not look pretty. Any help is always appreciated, thanks. OrgData.txtIRMS.txt
I pasted them into notepad and attached them as txt files.Sample.xlsm

[TMS]

Suggest you post a sample workbook with some typical data and the code in situ.

Regards, TMS

[deekar]

I revised my original message to include a sample excel file.

[TMS]

Well, this is a start:

Please Login or Register  to view this content.

Avoid selecting cells, rows, columns ... you don't need to. Combine things where they are being treated in the same way.

In the other macro, lose all the scrolling. Avoid ".Select ... Selection." Combine as above.

Not entirely sure how you want to combine the macros. Both doing lots of sorting?

Regards, TMS