linking several data sheet into one master workbook

D

Dennis Schuessler

I have a workbook that contains 5 worksheets that are the
same except that each one is for a different business
unit. There are also a couple of other sheets that do
some comparisons of the data by business unit.
What I want to do is make it so that each business unit
can do data entry without the others locking them out. So
I have created separate workbooks for each unit.
The problem is when I open the worksheet with the overall
reporting, I want to have an exact copy of the raw data
(i.e. formatting and all) in the worksheet. I have tried
to link worksheets cell by cell but where there are
blanks in the data sheet in the report workbook they show
up as "0".
 
D

Doug Kanter

About the only thing I see in his question that IS possible is making zero
values appear as blank (if I interpret his question correctly). It's done
using a formula like this actual example (as seen on TV!)

=IF($A14=0,"",$A14*G14)

Turned into a traditional IF loop from a programming language:

IF A14=0
THEN cell where formula resides should be blank
OTHERWISE the cell = A14 x G14
ENDIF
 
Top