(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


Leave a Reply

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