Forum

Hi Monish, Using ActiveWorkbook can get messy when renaming, saving, and deleting files. I'd also recommend using a yyyymmdd date format if you ...

Hi Dan, You could try the CONCATENATE formula, or use the "&" function. =CONCATENATE(A11,A12,A13,B11,B12,B13) =A11&A12&A13&B1...

Hi David, Your source data is a bit of a mess, but this might be a good start. Ben.

Nice bit of code, SunnyKow! Amy - the fundamental flaw with your macro is that you have your "if" statement on one line, and you don't have an...