Thank you so much however, I have another question.

Assume the dates running down column A in sheet A (Master sheet) are random.
I have 12 other worksheets each named by Months. I need the information which
for example has the date from sheet A in January in the "January" worksheet,
and records in February in the "February" worksheet and so on.

Please help becuase I've been trying to figure this out for a couple of
weeks now and have no idea what i'm doing.

Ceci

"Max" wrote:

Assume dates (real dates) are running in A2 down in sheet: A,
and thatt the info to be extracted over lies in col B and C

In sheet: B
In A2:
=IF(A!A2="","",IF(A!A2=TODAY(),ROW(),""))
Leave A1 blank

In B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX(A!B:B,SMALL($ A:$A,ROWS($1:1))))
Copy B2 to C2. Select A2:C2, copy down to cover the max expected extent of
data in "A", eg down to C200? Cols B and C will return the required result
lines from "A" all neatly bunched at the top (viz those lines where the date
in col A is equal to TODAY ie the current date).

At each day-end, the process should be to make a frozen copy of "B", and to
label the copy unambiguously with the current date, eg label it as: 11Mar2008.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ceci" wrote:
I have a workbook with 2 worksheets. Sheet A is a data entry sheet (a large
excel list). Sheet B is a daily summary sheet that needs to be populated from
the info stored on Sheet A.

One of the columns in Sheet A contains various dates in no specific order.
What I need is for Sheet B to be updated dependent upon the date. If the
dates in the 'date column' of Sheet A match today's date it should drag the
other info from the row into Sheet B.

I have tried various combinations of IF statements in macros but I'm not too
hot at writing macros so can't make it do what I need it to.

Hope you can help! Let me know if this explanation is too short on detail to
be of use.