How can I track old dates of occurrences?Closed

Question

Hello,

I need to track each occurence of an event that is recorded on one worksheet in Excel, and am hoping to find a macro that will take info from Sheet 1 and insert it into Sheet 2.

What I have is a column on Sheet 1 that records the latest occurence only.  On each of these rows are other details such as names etc.

I would like to run a formula or macro that upon my use of 'CTRL;' to insert a date on Sheet 1, will copy certain details from that particular row and insert it onto Sheet 2 as an addition, so that I can then filter the data on Sheet 2 and find all occurences by name etc.

Is this achievable?

Thanks heaps in advance,

JC

TrowaD · Answer

Hi JC,

Please upload your file using a filesharing site and post back the link. Explain in detail what you would like to achieve (copy certain data?) (my use of 'CTRL;' - you mean shortcut key?).

Best regards,
Trowa

How can I track old dates of occurrences?

1 response

Similar discussions

Subscribe To Our Newsletter!