Over my head on this one...
 

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.

Over my head on this one...
 

Chuck,

Assuming that all dates are in Row 2 and you want the running of the Macro
under your control then try:

Sub MoveIt()
If Cells(2, 9).Value2 < "" Then
If Cells(2, 10).Value2 < "" Then
Cells(2, 26).Insert shift:=xlToRight
Cells(2, 6).Copy Destination:=Cells(2, 26)
Range(Cells(2, 9), Cells(2, 10)).ClearContents
End If
End If
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"ChuckF" wrote in message
oups.com...
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.