Find matching date in another worksheet, copy and paste data
 

I'm trying to find a formula or macro that would allow for me to enter date
into one worksheet and automatically look for that same date in another
worksheet. Then, copy certain data and paste it to the first worksheet. Is
this possible?

For example, I have one sheet that has a large amount of data, say orders
for instance (sheet 1), but I only want to know specific things about the
orders in the other sheet (sheet 2). In sheet 2, I want to be able to enter
the date into a certain cell and have data from sheet 1 that corresponds with
that date autopopulate into sheet 2.

Thank you.

Find matching date in another worksheet, copy and paste data
 

Why have you started a second thread, identical to your first posted
an hour ago? You have an answer to that one.

Pete

On Nov 8, 11:10 pm, Shoney wrote:
I'm trying to find a formula or macro that would allow for me to enter date
into one worksheet and automatically look for that same date in another
worksheet. Then, copy certain data and paste it to the first worksheet. Is
this possible?

For example, I have one sheet that has a large amount of data, say orders
for instance (sheet 1), but I only want to know specific things about the
orders in the other sheet (sheet 2). In sheet 2, I want to be able to enter
the date into a certain cell and have data from sheet 1 that corresponds with
that date autopopulate into sheet 2.

Thank you.