words and numbers automatically updated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Match and delete rows on two different sheets from reference numbers 4
Auto Change Formulas - Please Help. 2
Automatic Sumning of Same Cell from Different Sheets 3
Automatically update a cell 2
AVG and my virus 3
Windows XP macro, automatically update data 0

Back
Top