| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
words and numbers automatically updated
I am trying to have a column where there are a few letters and then
essentially the date. The problem I am having is that it needs to automatically update with the prior sheet, so if that sheet was updated on 8/22/07 I need my cell in a different sheet to say something like PEL082207. Does anyone have any ideas? Thank you, Katie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
words and numbers automatically updated
Katie
A single sheet cannot be updated. Do you mean a cell with a date has the date changed? In sheet2 enter ="PEL" & TEXT(Sheet1!A1,"mmddyy") Gord Dibben MS Excel MVP On Wed, 22 Aug 2007 15:00:01 -0700, Katie wrote: I am trying to have a column where there are a few letters and then essentially the date. The problem I am having is that it needs to automatically update with the prior sheet, so if that sheet was updated on 8/22/07 I need my cell in a different sheet to say something like PEL082207. Does anyone have any ideas? Thank you, Katie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The content of my cells (formulas) isn't updated automatically any | New Users to Excel | |||
| Autofit does not work when cell is updated automatically. | Excel Discussion (Misc queries) | |||
| Automatically insert last updated date | Excel Discussion (Misc queries) | |||
| date and time updated automatically | Excel Worksheet Functions | |||
| How can a timestamp in an Excel row be automatically updated if a. | Excel Worksheet Functions | |||
Hybrid Mode
