Thank you so much for looking into this, the code was much more extensive and complex than I'd thought, so thanks.
I would like to clarify exactly what piece of code I need to add from the rondebruin link and where to place it in your code. Right now I'm getting the Sub or Function not defined error while running your code. I'm also attaching a sample of my spreadsheet as it currently exists. Column "D" returns the previous month "=EOMONTH(TODAY(),-1)" whose value is concatenated into columns "E" and "G".
Originally Posted by gmayor
Reply With Quote