TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Adding Cells in Excel across pages".

Adding Cells in Excel across pages".

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

1+2=3

oh wait sorry i meant A1 + A2 = A3

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

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

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?

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.

Re: Re: Adding Cells in Excel across pages".

quote:

Originally posted by Ygrene Yes.

Providing it's Excel 2007, of course.

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.

have sex with your boss/manager

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.

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!".

Just open all the files you reference (as recommended make sure the referenced files are on a networked drive or SharePoint site), and build your formula by clicking on the cell in the file you need. Excel automatically references the file location.

Re: Re: Re: Adding Cells in Excel across pages".

quote:

Originally posted by Acton Providing it's Excel 2007, of course.

or 2003.

Powered by: vBulletin
Copyright © 2000-2021, Jelsoft Enterprises Ltd.