copying data between worksheets

  • Thread starter Thread starter SURGEON1971
  • Start date Start date
S

SURGEON1971

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
 
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
 
Thankyou Per!! Worked a treat!!

Per Jessen said:
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
Click to expand...
 
Back
Top