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

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

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

what cant you built a pivot table for the data entered manually in the first
sheet, as and when you enter the data refresh the pivot and select the data
you get what you were looking for

"RoiSun" wrote:

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