Just a trailer thought .. If it's neatly grooved in your master sheet, you
could try recording a macro to copy n paste special as formats from each of
the range within the 3 child sheets onto the corresponding range in the
master sheet.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cam1234" wrote in message
...
This solves most of my problems, but if I wanted to be really lazy and
copy
the formatting over (such as font size, and text or background color) the
=IF
won't do it. Is there any formula that willl solve this problem?

Thanks!

"Max" wrote:

Instead of: =Sheet2!A1
use: =IF(Sheet2!A1="","",Sheet2!A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cam1234" wrote:
Hi All,

I have 3 sheets with similar data on each one, divided by location. I
want
to make a master sheet (the 4th sheet) that combines all the
information on
the first three. I've designed the template already, but I'm having a
problem copying the cells from each individual sheet. I want the
master
sheet to automatically display any changes made to any of the original
three.
When I use the "=", the master sheet displays a '0' if the cell on the
original sheet is blank. I want an exact copy of what is on the
original
sheet; if the cell is blank on the original, I want it blank on the
master.
Any ideas?

Thanks!

Cam