Avian Gamers Network

I'm trying to make a little accounting excel spreadsheet and I want to put in some formulas that will involve taking numbers from other sheets on the same file. Does anyone know what to put in the formula for that?

_________________
Romsuiag (Brad)
Former and Third President of Avian

xyz = cell(a,a).value
cell(b,b).value = xyz


or something like that

_________________
X2-PB

Pathfinder Kingmaker Campaign:
Gednan Malithanar - Wizard (1)
Dukin Thunderstrike - Ranger (1)

Star Citizen: - https://www.robertsspaceindustries.com/
AntanKarmola on their forums

Star Wars: The Old Republic: - Not really playing
Antare Karmola - Jedi Guardian (32)
Antan Karmola - Jedi Shadow (21)
Arianae Karmola - Gunslinger (20)

look Value up in the online help

_________________
X2-PB

Pathfinder Kingmaker Campaign:
Gednan Malithanar - Wizard (1)
Dukin Thunderstrike - Ranger (1)

Star Citizen: - https://www.robertsspaceindustries.com/
AntanKarmola on their forums

Star Wars: The Old Republic: - Not really playing
Antare Karmola - Jedi Guardian (32)
Antan Karmola - Jedi Shadow (21)
Arianae Karmola - Gunslinger (20)

other sheets or other books? sheet being in the same Excel file..books being a seperate excel file..

Seperate file linkage
If they are located in the same folder

=[ExcelFilename.xls]Sheetname!$E$15
E15 being the cell of course...

Linking a sheet to another sheet in same File
='Sheetname'!E23
E23 being the cell...

_________________
Ryric Krael
Former Vice President AGN
Former Director, Section 6
Former Head of Department of the Treasury
-------
Ask not what your PA can do for you, but what you can do for your PA
"Gone Section Five"

Got what I needed, thanks!

I was looking for linking to a sheet, but linking to another file is nice to know as well.

_________________
Romsuiag (Brad)
Former and Third President of Avian

if u just put a = in the entry bar u can click on the next sheet find the cell u want click and hit enter and that works too

_________________
Ryric Krael
Former Vice President AGN
Former Director, Section 6
Former Head of Department of the Treasury
-------
Ask not what your PA can do for you, but what you can do for your PA
"Gone Section Five"

Yeah DF, that is how I do it.

same..im to lazy to code it all in by hand lol...im more a visual person anyways

_________________
Ryric Krael
Former Vice President AGN
Former Director, Section 6
Former Head of Department of the Treasury
-------
Ask not what your PA can do for you, but what you can do for your PA
"Gone Section Five"

See, I tried that, but it wouldnt work. It would record the cell number I clicked on, but for the same sheet. Go figure. Oh well, I got what I needed so no sweat off my gullet.

_________________
Romsuiag (Brad)
Former and Third President of Avian

thats because u clicked back to ur old sheet and did not hit enter on the sheet u wanted...

Entry bar type =
go to page u want select cell hit enter or enter a new command / * + - w/e..if u just hit enter u will be returned to the cell u typed = in except it will be ='Sheetname'!E23

_________________
Ryric Krael
Former Vice President AGN
Former Director, Section 6
Former Head of Department of the Treasury
-------
Ask not what your PA can do for you, but what you can do for your PA
"Gone Section Five"