formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not sure where to start, so I thought here would be the best place! I have a general working knoweledge of excel, but by no means am a expert, the problem being my MD seems to think I am and now wants me to perform miracles!

Anyway, I have 14 spreadsheets of commission that are worked out with excel formulas and I need to link them all to one master spreadsheet for tracing/reporting purposes. The problem is I dont have a clue where to start/look for info on how to do this any info/help would be greatly appreciated
 
Hi slc!

Let's start with basics. I'm assuming that by "spreadsheets" you mean
workbooks.

You can reference a cell in another workbook. The easiest way to
create the reference is to have your new master workbook open and then
open one of the commission workbooks. In the Master press = and then
navigate to a cell in the commission workbook, select it and press
Enter.

Once you have referenced the cell, the commission workbook need not be
open. However, you do need to be careful with formulas using such
techniques because you can very easily exceed the maximum length of
formula.

Depending upon size and structure, you might find it better to copy
and paste all of the data from the separate books into one book.

In general terms it would be better if you posted direct "how do I..."
questions.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
slc said:
I am not sure where to start, so I thought here would be the best
Click to expand...
place! I have a general working knoweledge of excel, but by no means
am a expert, the problem being my MD seems to think I am and now
wants me to perform miracles!
Anyway, I have 14 spreadsheets of commission that are worked out
Click to expand...
with excel formulas and I need to link them all to one master
spreadsheet for tracing/reporting purposes. The problem is I dont have
a clue where to start/look for info on how to do this any info/help
would be greatly appreciated
 
Back
Top