VLOOKUP or INDEX/MATCH are the common ways of achieving this, but it
sounds as if you might have multiple rows of data with the same date,
and both of these approaches only return the first occurence which
matches. There other ways of doing this, however, but it would help if
you could describe how your data is laid out and what you want to
achieve in more detail.

Pete

On Nov 8, 10:08 pm, Shoney wrote:
I'm trying to set up a fomula or macro that will allow me to enter a date on
one sheet, then find the date on another sheet within the same workbook.
Then, copy certain cells within that column and paste them to certain cells
within the sheet which I entered the date to begin with.

What I have is a sheet with a large amount of data (the sheet I want to pull
data from) and another sheet that would showcase only a portion of the data.

The goal is to be able to enter a date in the one sheet and automatically
pull data from the other sheet and paste it where appropriate.