Community archive

Ask something
Discussion Locked

Excel copy

0 helpful
1 reply

by domm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In Excel NT I would like to carry the ending balance from one wksheet to the beginning balance of the next. I presently copy the first to the clipboard and paste into the second; but I would like a procedure (either function or code) that willmake this automatic.
Please help!

Bob

1 reply

by timwalsh

If both worksheets are in the same Excel workbook, place the cell reference for the ending balance in the cell for the beginning balance (i.e. Your ending balance is located in cell D9 in worksheet 1. In worksheet 2, in the cell for your beginning balance, enter
"=Sheet1!D9".

If the worksheets are in different workbooks, you need to add a reference for the workbook using the syntax "=[filename}Sheet1!D9".

This discussion is closed to new replies.