Korean Job Discussion Forums

[Big_Bird]

For an assignment, I have to create a spreadsheet in which I use 3 sheets:

Input
Processing
Output

All the calculations must be performed in the Processing sheet.
All data must must come from the Input sheet.

Does anyone know how to do this? I'm used to making calculations from data entered into the same sheet, but have never taken data from another sheet to use in a calculation.

I'm hoping someone out there is familiar with this!

[bassexpander]

Do you mean different files? Or different pages in one file? I know there are tabs at the bottom for different pages if you want to add them.

[nobbyken]

I would do it by copying the input cell on the input sheet,
pasting (paste special, paste link) it into the sheet with the equations,
finally paste (paste special, paste link) the equation solution cell into the appropriate area on the out put sheet.

If you paste link, then if you change the cell on the input sheet, it'll change the cells in the next 2 sheets automatically.

It should be pretty straightforward, though the last time I used MS excel was in 2006, so maybe command names have changed a little in current versions.

Any problems, send us a pm.

[IlIlNine]

tabname!celladdress

ie: data!A1

or

data!A1:B7 for a range

[kiwiinkorea]

[Big_Bird]

Thank you all very much!