Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Which function do I use
I have an Inventory worksheet and an Order Form worksheet. I need Excel to
change Item"s date in the Inventory worksheet when that Item and the quantity are sold and I fill out the Order Form. I want the Item in the Inventory worksheet to reflect the date when it was sold and I want Excel to change that date for me automatically. What function do I use? |
#2
|
|||
|
|||
You would use a worksheet change event
their are several examples of automatically inserting a date on this page: http://www.mvps.org/dmcritchie/excel/event.htm#autodate --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm " wrote in message ... I have an Inventory worksheet and an Order Form worksheet. I need Excel to change Item"s date in the Inventory worksheet when that Item and the quantity are sold and I fill out the Order Form. I want the Item in the Inventory worksheet to reflect the date when it was sold and I want Excel to change that date for me automatically. What function do I use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |