Hi, i needed suggestion on our current practise.
Currently, we have a daily forcast of receipt. Each tab has 01/05/2019-31/05/2019. (31 Column). Example, on 01/05, the person will input the forcast for 02/05-31/05 and put the Actual receipt for 01/05 in a seperate row.
The next day. 02/5, the person will duplicate sheet01/05 and forcast 03/05-31/05 and put the actual receipt for 02/05
So at the end of the month, we would have 31sheets which i think is very messy. However, we need to keep record of our daily forcast.
How should i arrange my data more efficiently (preferably one sheet)? So that i can easily refer back to my previous forcast? Refer attached for simplified example
Bookmarks