If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Removing a date by inputting a newer one in another cell
I have office excel 2007. I am a fairly new user,
I have a worksheet which maintains and monitors the movement of various units, and is controlled by quantity and dates. What I would like to do is write a formula that will remove the ordered date when I input the new start date, which would be the newer date. So far I have not been able to make this work. I would appreciate any help or advice you can give me. Many Thanks Mike |
#2
|
|||
|
|||
Removing a date by inputting a newer one in another cell
You could use a worksheet_change event that clearscontents of the original
cell. -- Don Guillett Microsoft MVP Excel SalesAid Software "Mike" wrote in message ... I have office excel 2007. I am a fairly new user, I have a worksheet which maintains and monitors the movement of various units, and is controlled by quantity and dates. What I would like to do is write a formula that will remove the ordered date when I input the new start date, which would be the newer date. So far I have not been able to make this work. I would appreciate any help or advice you can give me. Many Thanks Mike |
#3
|
|||
|
|||
Removing a date by inputting a newer one in another cell
Hi,
could you please provide with and example of the layout of your spreadsheet, thanks "Mike" wrote: I have office excel 2007. I am a fairly new user, I have a worksheet which maintains and monitors the movement of various units, and is controlled by quantity and dates. What I would like to do is write a formula that will remove the ordered date when I input the new start date, which would be the newer date. So far I have not been able to make this work. I would appreciate any help or advice you can give me. Many Thanks Mike |
#4
|
|||
|
|||
Removing a date by inputting a newer one in another cell
"Eduardo" wrote in message ... Hi, could you please provide with and example of the layout of your spreadsheet, thanks Hi. Item ! Start Date ! Qty ! Reorder Date ! Warning 7 Days ! Status ! Date Ordered ! ! 13/07/09 ! 24 ! ! ! reorder! 06/07/09 ! When a new start date is input the other dates recalculate and the status column changes to okay. The date ordered does not change, this the date I would like to remove, just to save a few less clicks on the sheet, and so I don't forget to delete it. Hope this makes sense. Mike "Mike" wrote: I have office excel 2007. I am a fairly new user, I have a worksheet which maintains and monitors the movement of various units, and is controlled by quantity and dates. What I would like to do is write a formula that will remove the ordered date when I input the new start date, which would be the newer date. So far I have not been able to make this work. I would appreciate any help or advice you can give me. Many Thanks Mike Item ! Start Date ! Qty ! Reorder Date ! Warning 7 Days ! Status ! Date Ordered ! ! 13/07/09 ! 24 ! ! ! reorder! 06/07/09 ! When a new start date is input the other dates recalculate and the status column changes to okay. The date ordered does not change, this the date I would like to remove, just to save a few less clicks on the sheet, and so I don't forget to delete it. Hope this makes sense. Mike |
#5
|
|||
|
|||
Removing a date by inputting a newer one in another cell
"Eduardo" wrote in message ... Hi, could you please provide with and example of the layout of your spreadsheet, thanks Hi, Will try. Item ! Start Date ! Qty ! Reorder Date ! Status ! Date Ordered ! ! 13/07/09 ! 24 ! ! reorder! 06/05/09 ! not all columns are shown that are in the work sheet, just some indication of the layout When the date in B2 is greater than the date in F2 then delete/remove the date in F2 When a new start date is input the other dates recalculate and the status column changes to okay. The date ordered does not change, the date. I would like to remove, just to save a few clicks on the sheet, and so I don't forget to delete it. Hope this makes sense. Mike "Mike" wrote: I have office excel 2007. I am a fairly new user, I have a worksheet which maintains and monitors the movement of various units, and is controlled by quantity and dates. What I would like to do is write a formula that will remove the ordered date when I input the new start date, which would be the newer date. So far I have not been able to make this work. I would appreciate any help or advice you can give me. Many Thanks Mike |
Thread Tools | |
Display Modes | |
|
|