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 |