| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date stamping a cell change
Hi there,
I have a spreadsheet in which I track Inventory. Column A details the status (there is a data validation list to say if Stock On Hand or Invoiced etc). Column D details the date (MMM-YY) invoiced. Is there any way that when I select "Invoiced" in column A that I can somehow get Column D to pick up the current month? NOTE: This database contains historical data, hence why all formulas I have tried fail unless I manually change them each month. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date stamping a cell change
Look he
http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Mustang" wrote in message ... Hi there, I have a spreadsheet in which I track Inventory. Column A details the status (there is a data validation list to say if Stock On Hand or Invoiced etc). Column D details the date (MMM-YY) invoiced. Is there any way that when I select "Invoiced" in column A that I can somehow get Column D to pick up the current month? NOTE: This database contains historical data, hence why all formulas I have tried fail unless I manually change them each month. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date stamping a cell change
Thank you will have a read.
"Niek Otten" wrote: Look he http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Mustang" wrote in message ... Hi there, I have a spreadsheet in which I track Inventory. Column A details the status (there is a data validation list to say if Stock On Hand or Invoiced etc). Column D details the date (MMM-YY) invoiced. Is there any way that when I select "Invoiced" in column A that I can somehow get Column D to pick up the current month? NOTE: This database contains historical data, hence why all formulas I have tried fail unless I manually change them each month. Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date stamping a cell change
Thank you very much, does the job perfectly.
"Niek Otten" wrote: Look he http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Mustang" wrote in message ... Hi there, I have a spreadsheet in which I track Inventory. Column A details the status (there is a data validation list to say if Stock On Hand or Invoiced etc). Column D details the date (MMM-YY) invoiced. Is there any way that when I select "Invoiced" in column A that I can somehow get Column D to pick up the current month? NOTE: This database contains historical data, hence why all formulas I have tried fail unless I manually change them each month. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic date stamping | Excel Discussion (Misc queries) | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Date and time stamping with a (macro) button | Excel Worksheet Functions | |||
| Time Stamping A Cell | Excel Discussion (Misc queries) | |||
| Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
Linear Mode
