Hi there

Can someone please help me to automate this routine with VBA,
What I would like to do is -

• Go to sheet1, in range E1 to AD1, find a cell where there is matching date which is same as sheet2 range G2.
• If match is found, then move one cell down below the matching cell, then select range E2 to activecell,
• then Selection.End(xlDown).Select
• and copy and paste special values in thie selected range
• then go to sheet3 and select range(a1)

Also if possible, just before I run this macro, I want to be able to close any open excel workbooks. If any other excel files are open, then macro stops before running and allows the user to close any open excel files.

Could someone please structure this in vba code for me.

Thank you in advance.
gsrai31