Stock Sheet. Use Closing Balance as Opening Balance on Next monthly stock sheet

Copper Contributor

I need assistance with taking my current month stock sheet.

I have various columns which include opening stock and then I subtract or add stock and end with a column for closing balance.

 

I would then like to import the columns to a new workbook in the same document. Then that Closing balance column needs to populate the new month's opening balance stock column.

0 Replies