Hello
Forgive me if this is a silly question -I feel the answer should be straightforward, but can't work it out.
I'm linking cells from one sheet to another - basically to see what's happening every day of the year. In the source document, there are loads of columns - the only two I'm concerned with are the date column and the second column, which shows what's scheduled to happen on that day.
In the new document, I want to create a calendar with columns being Sunday - Monday.
b2 = '[source.xls]b278. d2 = '[source.xls] b279.......... o2 ='[source.xls]b284
b3 = '[source.xls]b285
Effectively, when I copy the formula downwards, I want excel to look at the cell seven below the source for the one above it, but I can't work out how to do it.
I hope this makes sense!!!
Any help will be gratefully appreciated
Phillip
Forgive me if this is a silly question -I feel the answer should be straightforward, but can't work it out.
I'm linking cells from one sheet to another - basically to see what's happening every day of the year. In the source document, there are loads of columns - the only two I'm concerned with are the date column and the second column, which shows what's scheduled to happen on that day.
In the new document, I want to create a calendar with columns being Sunday - Monday.
b2 = '[source.xls]b278. d2 = '[source.xls] b279.......... o2 ='[source.xls]b284
b3 = '[source.xls]b285
Effectively, when I copy the formula downwards, I want excel to look at the cell seven below the source for the one above it, but I can't work out how to do it.
I hope this makes sense!!!
Any help will be gratefully appreciated
Phillip