###Purpose of code

Purpose of code

I'm on my second revision of this workbook and I've brought the runtime down from 37 seconds to 9 seconds on my computer and from 30-40 minutes to 8 minutes on my boss's old laptop. I'd like to know if there is anything I can do to further increase the speed of this code that I may have missed. I took 3-4 subs and moved them all into one so the formatting is a bit off in the main but I've brought all the variables to the top. All sub/functions called by the main are included, I believe I have them reasonable optimized but I included them just to be complete.

The purpose of this code is to create sheets based on codes entered by the user, narrow down a data report using those codes, break out the data to individual sheets identified by the code, extract data from the previous report that has a match to a line in the latest report, move the data on each sheet into date blocks including holdays that are defined on starting sheet (Past Due, Due Today, Due in next X days, Due after next x days, Quotes), delete the worksheets containing the old data, and apply row highlight conditional formatting.

I'm on my second revision of this workbook and I've brought the run-time down from 37 seconds to 9 seconds on my computer and from 30-40 minutes to 8 minutes on my boss's old laptop.

I'd like to know if there is anything I can do to further increase the speed of this code that I may have missed. I took 3-4 subs and moved them all into one so the formatting is a bit off in the main but I've brought all the variables to the top. All sub/functions called by the main are included, I believe I have them reasonably optimized but I included them just to be complete.

###Purpose of code

• create sheets based on codes entered by the user,
• narrow down a data report using those codes,
• break out the data to individual sheets identified by the code,
• extract data from the previous report that has a match to a line in the latest report,
• move the data on each sheet into date blocks including holdays that are defined on starting sheet (Past Due, Due Today, Due in next X days, Due after next x days, Quotes),
• delete the worksheets containing the old data,
• and apply row highlight conditional formatting.

The purpose of this code is to create sheets based on codes entered by the user, narrow down a data report using those codes, break out the data to individual sheets identified by the code, extract data from the previous report that has a match to a line in the latest report, move the data on each sheet into date blocks including holdays that are defined on starting sheet (Past Due, Due Today, Due in next X days, Due after next x days, Quotes), delete the worksheets containing the old data, and apply row highlight conditional formatting.