Can anyone help please?
I've got a workbook with several worksheets, there are 2 that I need to link.
In one I have a list of dates(in column),and in other columns I have items:-
Date Drawsheets Pillows C/Panes
12/8/08 10 20 5
14/8/08 20 20 6
19/8/08 15 30 5
21/8/08 20 20 5
In the other worksheet I have the TODAY() field, and the list of items.What I would like to do in this worksheet is to say,if TODAY() matches any of the dates in the other worksheet, then list the items in this sheet - there are other fields in this sheet but they're not causing any problems.
Thanks,
I've got a workbook with several worksheets, there are 2 that I need to link.
In one I have a list of dates(in column),and in other columns I have items:-
Date Drawsheets Pillows C/Panes
12/8/08 10 20 5
14/8/08 20 20 6
19/8/08 15 30 5
21/8/08 20 20 5
In the other worksheet I have the TODAY() field, and the list of items.What I would like to do in this worksheet is to say,if TODAY() matches any of the dates in the other worksheet, then list the items in this sheet - there are other fields in this sheet but they're not causing any problems.
Thanks,
