copying data between worksheets
 

I have set up a self calculating workbook for business accounts. The workbook
has two sheets, one for income and the other for expenditure. How do I set
it up so the cell with total income figure can be automatically transfered to
the expenditure worksheet, where that figure is then present in a specified
cell, that ties in with a formulated cell that gives me an income less
expenditure figure. Can anyone help please?

Thanks
S1971

copying data between worksheets
 

Hi

In the desired cell in the expenditure sheet enter an equal sign, then
select the income sheet and click on the "total income" cell and hit enter.

The formula should look like this:

=Sheet1!A1

Hopes this helps

--
Per

"SURGEON1971" skrev i meddelelsen
...
I have set up a self calculating workbook for business accounts. The
workbook
has two sheets, one for income and the other for expenditure. How do I
set
it up so the cell with total income figure can be automatically transfered
to
the expenditure worksheet, where that figure is then present in a
specified
cell, that ties in with a formulated cell that gives me an income less
expenditure figure. Can anyone help please?

Thanks
S1971

copying data between worksheets
 

Thankyou Per!! Worked a treat!!

"Per Jessen" wrote:

Hi

In the desired cell in the expenditure sheet enter an equal sign, then
select the income sheet and click on the "total income" cell and hit enter.

The formula should look like this:

=Sheet1!A1

Hopes this helps

--
Per

"SURGEON1971" skrev i meddelelsen
...
I have set up a self calculating workbook for business accounts. The
workbook
has two sheets, one for income and the other for expenditure. How do I
set
it up so the cell with total income figure can be automatically transfered
to
the expenditure worksheet, where that figure is then present in a
specified
cell, that ties in with a formulated cell that gives me an income less
expenditure figure. Can anyone help please?

Thanks
S1971