| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a prompt to automatically fill a cell
You know how in Word, in a mail merge, you can create a prompt that asks you
inofrmation and it updates the merged document? I would like to do the same kind of thing in Excel. I have a document (multiple sheets) that is forwarded to an external client every month. We need, at the bottom of each sheet, a line saying: "The information in this report was gathered on DD/MM/YYYY. All YTD information is based on the X company fiscal year July 1 to June 30." The date can show as a full text or dd/mm/yyyy format. Is there any way to get Excel to ask me the date the information was gathered so I don't forget to update my footer? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I automatically fill the remainder of a cell with dots (.. | Excel Discussion (Misc queries) | |||
| Automatically fill cell value | Excel Worksheet Functions | |||
| How prompt Excel user to fill cell with text, i.e., proposal name | Excel Discussion (Misc queries) | |||
| How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
| Automatically fill one cell in any newly inserted row | Excel Discussion (Misc queries) | |||
Linear Mode
