Oct 11 2022 07:06 AM
Hi guys,
I'm sort of new to VBA and was wondering if I can do the following - see attached picture for reference.
I have a sheet (Admin_Sheet) that I use to do calculations from other multiple sheets (VLOOKUP, SUMIFS, INDEX, MATCH, etc.). It calculates Sales Data, Transactions, MTD, YTD, etc. based on one selection in a cell (STORE NAME) using a data validation of the STORE NAME in a couple of sheets. What I would like to do is write a VBA (if possible) to:
Please assist if possible.
Thanks