Hi all,
I am preparing a template of performance dashboard to be shared on my company's network.
I want have a table of 13 months column for stock position, The first column is for daily's stock position and the remaining 12 columns is for each month position. My problem is on how to transfered each month end position (in column 1) to a monthly column (column 2 onwards, sequential), every month. Meaning, every time each month is completed, the 12th month will go off from the table.
I have attached the file to demonstrate what I intend to do.
Appreciate assistance from other members.
Bookmarks