Want to copy data and formula from one Excel Sheet to another.

I have a budget workbook set up in Excel, and in that workbook there are many different sheets all part of the one book.

I have created a formula in one sheet from the data that is collected there, and that data is important for information collected on another sheet. I want to copy the formula and the data from that from that sheet and have it appear in the other excel sheet. I also want the data to change on the second excel sheet as the results from the formula change in the first sheet.

When i have tried to just copy and paste the formula from one sheet to the next I just get a ref error.

Many thanks for your help in advance.

Regards

Anthony

This may help
How to Copy Formulas in Excel | eHow.com

richc46 said:

This may help
How to Copy Formulas in Excel | eHow.com

That didnt really help much.

It stopped giving me the ref error, but it didn't bring the fomula over from worksheet to another.

Open both spreadsheets.

In the location of the second spreadsheet (SS) press the = sign, then switch windows to the first SS from which you want the second to be updated. Touch the cell in SS number one and press enter. That process will link the two spreadsheets and the 2nd will be updated when the first one is...

Whew, hope that doesn't sound too complex! It is actually relatively straight-forward. Just don't press anything else between the two stokes. :)

Irene said:

Open both spreadsheets.

In the location of the second spreadsheet (SS) press the = sign, then switch windows to the first SS from which you want the second to be updated. Touch the cell in SS number one and press enter. That process will link the two spreadsheets and the 2nd will be updated when the first one is...

Whew, hope that doesn't sound too complex! It is actually relatively straight-forward. Just don't press anything else between the two stokes. :)

I have done an ECDL advance but the only way to learn and remember is to actually find practical things to actually use Office products

Exactly what I have done for the past 30 years.

I started out in the 'DOS' world, when vdu's were black background screens with white, green or orange coloured words on-screen. Mice were something found in a field! In those days we used Lotus or SuperCalc for spreadsheets and WordPerfect or WordStar for word processing.

When they introduced Windows and mice into the office, I used to spend break-times playing solitaire to try learning to control my mouse.