Is it possible?

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

Hi everyone.

I'm trying to discover if it is possible to do several things in Excel 2000.
I have set up an accounting system. There are 13 .xls files. One for each
month, and a Year end Summary. The file for each month is made up of 8
separate worksheets for accounting purposes.

1. Is it possible to have the Year end Summary file pull data from the other
12 files? (something similar to paste special, paste link but across files
as well as worksheets) How can this be achieved?

2. Is there a way to perform calculations from the data in the other 12
files? e.g. Lets say each month, there are several purchases of fuel.
These will be recorded in the 12 files (perhaps in separate worksheets
within the files). I want my summary sheet (file 13) to be able to tell me
how much I spent on fuel each month, then give me the total. Can it be
done?

3. Is it possible to create a drop-down box with options? I would need the
box to be populated with data from another spreadsheet file or an Access
database.

Many thanks for reading and sharing your wisdom........
Robin
 
Yes, it is all possible! You create a formula that performs the calculation
by doing the following:

1) Open all the spreadsheets that contain your data.

2) In the s/s that you want to contain the calculations, choose a cell and
begin, as you normally would, your formula (i.e. =)

3) Then using either the taskbar or the Window command, skip to the
spreadsheet containing the first of the items you want to add up (e.g.
January) and click the cell containing the data. If you look in your
formula bar you will see that is automatically is entering the proper
syntax.

4) Enter the operateor (e.g. + or - etc.) and repeat step 3 until you have
all your data calculated. Press Enter when you are done and you will be
returned to your original spreadsheet.

You can do this kind of calculation for different files and any kind of
formula...
 
Thanks for that, I'll give it a shot later.

What about getting Excel to find all references to the word Fuel, then
automatically taking the figure in the next cell. Can it do that by some
kind of find & add to fomulae command?

And the cell menu.........

Thanks again,
Robin
 
Back
Top