I'm trying to create a master sheet from 3 sub sheets, and all I want is the
exact entry in a sub sheet to display in the master sheet. The problem with
using the IF function is that it does not copy any formatting such as font or
background color. Is there anyway to tell excel to put the exact contents
from row 4 to row 54 in a sub sheet to, say, row 34 to 84 in the master sheet
- including formatting?

Thanks for you help!

Cam