Linking Merged Cells from worksheet to worksheet

Topic

New Reply

Using Windows XP/Excel 2003.

I have attached the spreadsheet in question (which will actually have ten tabs similer to these)..
What I want to do, is be able to type in the Date (manually) for each day, and have it fill in across all spreadsheets.

I have tried it with the first 2 tabs. The first Monday works fine. (2/1) But then, using the same formula, I cannot
get any other day to work.

I thought it may have to do with the cells being merged and not having the same # of cells merged, but
the Monday works and it has different cell counts.

Is there a way to do this?

Thank you for your help.

Michael Abrams

Reply | Quote

Replies

Since you have merged the cells – you only need to note the beginning cell and not through the ending merged.

Such as =(‘ABC(WEEKLY)’!M1) not =(‘ABC(WEEKLY)’!M1:U1)

Once you merge…n1, o1, p1 etc…do not exist.

Reply | Quote

Thank you so much Deborah – it works perfectly now !! Much appreciated.

Michael

Reply | Quote