Removing a date by inputting a newer one in another cell

M

Mike

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
 
D

Don Guillett

You could use a worksheet_change event that clearscontents of the original
cell.
 
E

Eduardo

Hi,
could you please provide with and example of the layout of your spreadsheet,
thanks
 
M

Mike

Eduardo said:
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

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
 
M

Mike

Eduardo said:
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
 

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

Top