Does anyone know how to add cells across different excel spreadsheets?
I have collated weeks into monthly stats etc but want to collate monthly stats into an overall yearly stat template. I understand that I need to create the formula from the file is located for it to tally the data, i think?
example. =filelocation:\i.e.foler\1January2009\[Overall Monthly Stats Template Jan.xls]Monthly Stats'!$D$9+filelocation and so on
can i simply click on where i want it to total, and go back and forth between excel files adding in the location i want to add to the next etc
any help greatly appreciated
___________________
Dec-23-2009 01:44
tubularbills
Max Power!
Registered: Apr 2003
Location: Middle of fucking nowhere
1+2=3
Dec-23-2009 01:46
tubularbills
Max Power!
Registered: Apr 2003
Location: Middle of fucking nowhere
oh wait sorry i meant A1 + A2 = A3
Dec-23-2009 01:56
Energy_3
Supreme tranceaddict
Registered: May 2008
Location: Adelaide - Earth
quote:
Originally posted by tubularbills
oh wait sorry i meant A1 + A2 = A3
yeah sure, i know that, im not talking about the same page, im talking about adding data cells from one excel file and another, entirely diff locations
so i need to take into account, location of file etc and location of cell
yada yada
___________________
Dec-23-2009 02:01
tubularbills
Max Power!
Registered: Apr 2003
Location: Middle of fucking nowhere
copy the stuff from one excel file into a new spredsheet tab on the other file. that way you're linking spredsheet data, not files.
cause otherwise you have to macro-ize
Dec-23-2009 02:02
Energy_3
Supreme tranceaddict
Registered: May 2008
Location: Adelaide - Earth
quote:
Originally posted by tubularbills
copy the stuff from one excel file into a new spredsheet tab on the other file. that way you're linking spredsheet data, not files.
cause otherwise you have to macro-ize
Ok, thats an easy way to do it. Whats macro-ize, sorry not familiar.
But, its surely easy to do tho linking spreadsheet data?
___________________
Dec-23-2009 02:20
Ygrene
Dr. Stinkburger Deluxe
Registered: Nov 2003
Location: Totergefuttert
Re: Adding Cells in Excel across pages".
quote:
Originally posted by Energy_3
can i simply click on where i want it to total, and go back and forth between excel files adding in the location i want to add to the next etc
Yes. I use a process similar to this when I'm managing several files that other people are using as well.
Registered: Apr 2003
Location: Middle of fucking nowhere
quote:
Originally posted by Energy_3
Ok, thats an easy way to do it. Whats macro-ize, sorry not familiar.
But, its surely easy to do tho linking spreadsheet data?
macros are pieces of html code that link one file to another. i don't know much about it; but i know it's hard to do if you don't know what you're doing.
Dec-23-2009 03:00
denys envy
no scratch, no snatch...
Registered: Mar 2004
Location: falLAcy, CA
have sex with your boss/manager
Dec-23-2009 05:25
EarnYourKeep
LIT
Registered: Dec 2001
Location: twentyonetwo
in your external facing file (files you distribute, total, subtotal, presentation file) have all reference links back to a master file. Vlookup to a network path where the masterfile is store. update the values in the master file and the vlookup should automatically update the external facing file.
___________________
I PUT TRADEMARKS AROUND YO MOTHAFUCKIN EYE
JUST ME N YOU
Dec-23-2009 15:06
Ygrene
Dr. Stinkburger Deluxe
Registered: Nov 2003
Location: Totergefuttert
quote:
Originally posted by get nyce
in your external facing file (files you distribute, total, subtotal, presentation file) have all reference links back to a master file. Vlookup to a network path where the masterfile is store. update the values in the master file and the vlookup should automatically update the external facing file.
You know what sucks? Trying to explain this to people that don't understand Excel that well and the subsequent importance of saving the file on the network only to have them disregard it and then just email the file to you "Here's the file you need!".
