I have a spreadsheet that contains the following information.
F=Date visit is scheduled
I= Date I received the photo's
J= Date I received the paperwork

Column F contains a vlookup formula which brings over the date of the
last visit scheduled, from another spreadsheet.


My desired result is the following:
When a date is entered into I AND J, copy the data from F to a cell off

to the right (say column Z) then clears the contents from I and J.
If Z has a date in it (from a previous visit) I would want this data
next be copied into AA and so on.


What this will allow me to do is continue to fill in the date fields in

the same columns for the entire year, but still keep a running tally on

visits that we have already accounted for.


I hope this makes sense. If not let me know.
I do appreciate any time that you spend on looking at this...I would be

grateful for any help.


Thank you.