Ms Excel

[lexus boy]

Just wondering for those people who use it, can you take text from one sheet and trasfer to another, would make my life so much easier

[Claire G]

Yeah, think so, just click the text you want (highlight the text in the formula bar rather than the cell though - plays havoc with your formatting otherwise) and past it into a new worksheet or where ever.

If you want to highlight the whole spreadsheet, click the grey box above line 1 and next to column A, it'll highlight the whole thing for you.

Hope this is what you're after?

[lexus boy]

not really :S

ill explain what im wanting to do is as i enter data on 1 sheet it will automatically go onto my other sheet.

Not great with excel, havent used it since being at school....lol

not sure if explained it right

[fergy]

You can set refernecs so that as you enter on one sheet it copies straight to the other sheet...

-Click on the destination cell.

- type is "="

- then click on cell where data exists that you want to copy.

Note these are then linked and any cahnges to first sheet will fill through. You can also copy the formula to other cells and all the references will automaticall update...

Sounds complicated but if someone showed you for 2 minutes you'd see how easy it is..just hard to put down in here.

[Niraj]

fergy is right... the '=' character essentially makes the residing cell a formula.

you can add many different types of formulae, and all are basic referencing to other cells.

if you've ever played chess you'll understand the notation.

eg. A1:A4 will select all cells that meet in column A and in rows between 1 and 4 (inclusive)

you can also perform calculations similarly upon 2 different cells

eg. '=SUM(A1+A2)' will give the calculation performed values stored in those cells.

as for collecting and referencing data between cells it is the same procedure, aside from the notation must now include a reference to the sheet the raw data is stored.

eg. '=(Sheet1!A1) will copy the data stored in cell A1 on Sheet1 directly onto a different sheet.

NB: circular references can get very confusing. These are cells in which you reference another cell that is already performing a function of the original cell. Try avoid these situations.

and finally as fergy also said, any changes made to one sheet will follow through the entire excel book.

hope that helps :)