Forum Discussion
Excel Dynamic ranges?
I have a workbook with a worksheet for each month of the year plus a summary sheet for the whole year. Each monthly worksheet has 400 to 600 rows each representing a transaction/sale. I sort the rows...
I will suggest you deploy PivotTable on the sheet you record your transaction.
Also ensure you create helper column such as Month and Year from the Order_Date in the main source data.
In addition, format the data using Excel Table (CTRL + T).
Also ensure you create helper column such as Month and Year from the Order_Date in the main source data.
In addition, format the data using Excel Table (CTRL + T).