Find matching date in another worksheet, copy and paste data

G

Guest

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.
 
P

Pete_UK

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

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot copy worksheet to another file 2
Enter date on one worksheet, pull data from another 2
Auto Copy Data from one worksheet to another 1
Possible? Copy/paste to&from moving sources/destinations 2
Paste Values in linked Cells Only 4
Excel Macro to copy a row to another sheet based on date 0
How to insert new worksheet based on # of rows in a data sourch 2
hyperlink a cell to another worksheet of same book 1

Top