| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save specific sheets to new workbooks adding tomorrow's date to na
My company refuses to use a database to collect data so I'm stuck
distributing Excel workbooks everyday with specific sheets to different offices, consolidating the inputs in one workbook, then updating the separate workbooks with the information from consolidated workbook. The piece of VBA code that I haven't figured out is copying Sheet 1, 4, 6 to workbook 1, sheet 1, 3, 5 to workbook 2, and sheet 1, 2, 7 to workbook 3 from the master and adding tomorrow's date to the end of each file name. -- I know just enough to be dangerous and lock up the computer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return tomorrow's date. | New Users to Excel | |||
| tomorrow's date on an invoice made today | New Users to Excel | |||
| How to limit 'calculate' (F9) to specific cell, range, sheets, workbooks? | Excel Programming | |||
| tomorrow's date | Excel Programming | |||
| tomorrow's date | Excel Programming | |||
Threaded Mode
