In general - avoid merged cells except perhaps for labels over data columns
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Richard Boone" <Richard wrote in message
...
I have created a worksheet detailing all of next years Vacations, by week.
I
am trying to auto populate data from this master worksheet to seperate
less
detailed worksheets. How should the formula read? The data source is in
a
merged cell - is that an issue?