Hi,
Kindly assist with a formula to auto fix the Close Balance (Column F) as the Open Balance (Column C) once the Date (Column A) changes for the each Colour (Column B).
The close balance of each colour should auto update as the open balance of a new date.
Thank you.
Bookmarks