I will develop a fully functional macro in Excel VBA to automate a piece of work in your workbook. I can also combine this with pivot tables, formulas, charts etc as required. I can either provide you the code only for you to apply yourself to your workbook or I can apply the code directly to your workbook for you. By default I will build this with Excel 2016 for Windows. Please let me know should you wish this to work on other versions of Excel such as Excel for Mac.