Thanks for the reply, it is not quite what I needed. I have basically 13
worksheets. Worksheet#1 is the Master sheet and the others are grouped by
Months. Here is how my Master worksheet resembles like:

A B D
1 Date Company Name Quantity
2 1/15/08 ABC Limited 2
3 1/29/08 Simcoe Inc 10
4 2/04/08 McDonalds 5

As I enter in the dates in column A, I would like the same information for
the entire row copied over to the corresponding worksheet.

example: while enter the 2nd row's information, I would like all the
information for that row to be transfered to the "January's" worksheet since
the date i'm entering is in January.

Roi

"pdberger" wrote:

RS --

Are you looking for a total for a particular date? If so, here's one
approach. Let's say on Worksheet 1 Column A is the date, and column B is an
amount. Then, worksheet 2 might look like this:

A B
1 3/10/2008 =sumif('worksheet1'!A:A,A1,'worksheet1'!B:B)

HTH

"RoiSun" 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.

Please I have no one else to turn to.

Thank you SO SO much