I have a workbook with several sheets.
Some sheets have data, some don't. There is a Master sheet which contains the sheet names and their status.. Final, Error, NA.
User would select a status for a sheet. For all sheets with status=Final, I would like to generate a single MDB file (with all the sheet data stored in separate MS Access tables). I would prefer if the MDB file is generated with a specific naming convention and allows the user to save on his computer.
Attached is a sample excel sheet which would probably give a clear idea of my request.
Any help is appreciated.