Forum Discussion
Excel File Split Macro
Attached a copy of a Macro-enabled file I use to split out a master document into multiple individual workbooks. My question is for anyone familiar with Macros/VBA as I am not - I've only had this t...
If you wish, you may directly format the date in the code instead of reading the formatted date from the cell if it is always today's date like this...
dt = Format(Date, "yyyy-mm-dd ")
Thank you! the date will always be "today", works perfectly.
only other question - is it possible to have the sheet only make split copies for which there is data in column A? IE - the control sheet lists the 8 identifiers that may show up in column A, but not every run of this will have all 8 in column A. If on any given run only 2 or 3 of the identifiers are present, is it possible to have excel only split out to those two or three sheets, and not make all the other blank sheets?
Thanks