(Solved) – VBA Action when closing exel workbook

(solved)-–-vba-action-when-closing-exel-workbook

What I want to do is, whenever I close Exel workbook, VBA code should take value (which will change daily) from cell D3 (Sheet1), and then search date from cell G1 (Sheet1) in multiple date ranges (A2:A32, C2:C30…..) in Sheet2 and store value in cell next to matching date.
Thanks in advance

Sheet1
Sheet2

Leave a Reply

Your email address will not be published. Required fields are marked *