|
Adding Cells in Excel across pages".
|
View this Thread in Original format
| Energy_3 |
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:tongue2 |
|
|
| tubularbills |
| oh wait sorry i meant A1 + A2 = A3 |
|
|
| Energy_3 |
| 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 |
|
|
| 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:toocool: |
|
|
| Energy_3 |
| 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:toocool: |
Ok, thats an easy way to do it. Whats macro-ize, sorry not familiar.
But, its surely easy to do tho linking spreadsheet data? |
|
|
| Ygrene |
| 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. |
|
|
| Acton |
| quote: | Originally posted by Ygrene
Yes. |
Providing it's Excel 2007, of course. |
|
|
| tubularbills |
| 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. |
|
|
| denys envy |
| have sex with your boss/manager |
|
|
| 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. |
|
|
| Ygrene |
| 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!". :mad: |
|
|
|
|
