| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro or Formula to have a cell match the date on the tab.
I have a macro that assigns the Day and Date of the month to each tab (Thanks
to the folks on this board) but I would like it fill the corresponding day and date in a cell on each worksheet. Any suggestions? Also, on another workbook they would like to use the date of the tab as the starting point in a series to assign a pickup number. ex. Tab is Thursday, 10-01. The number series would be 100101, 100102, 100103, etc. Then of course, the next day would be Friday, 10-02 and the number series needs to be 100201, 100202, 100203, etc. Any suggestions on this?? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE #N/A | Excel Discussion (Misc queries) | |||
| Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| Edit macro to match entire cell contents | Excel Discussion (Misc queries) | |||
Threaded Mode
