Using VBA to record a history of dates

[Berth0]

Good Afternoon,

1st time VBA user - please be gentle...

I have built a schedule tracker for maintenance in Excel. Dates when maintenance has been completed is entered into Sheet 2 for the corresponding piece of equipment/task. From this date a 'next due' date is populated on Sheet 1. Sheet 1 (the schedule) is un-editable.

Currently the date entered into sheet 2 is overwritten when a new date is entered. I would like to save each entered date in another sheet, so that a history of maintenance is built.

I have 300 lines with up to 7 tasks per line. Most of the tasks are completed monthly, quarterly and annually.

I would appreciate any help - thanks in advance.

Bert

 

[Berth0]

I might add - this doesn't have to be a VBA solution, if there are other ideas, these will also be appreciated...

 

[My Aswer Is This]

I see your question has been here on the forum for nearly 24 Hrs. with no reply.
I would suggest you give more specific details.
Like give us the names of both sheets.
Give us sheet names in quotes:
Like "Master" and "Schedule"


I know you said sheet 1 and sheet 2 but it's better for me at least if you give specific names like shown above.

And we need column Numbers like column (3) or Column (C)

You said:
I have 300 lines with up to 7 tasks per line.

But never mentioned what columns we are dealing with are the dates in column 2 column 10 or what?

We only know what you tell us.
Thanks. If you provide more exact details maybe I can help you.​