Copy Data between worksheets

[Richard Boone]

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?

 

[Bernard Liengme]

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