Well, you could use Advanced Filters - Debra Dalgleish has an intro
he

http://www.contextures.com/xladvfilter01.html

Hope this helps.

Pete

On Feb 2, 10:11*am, "Leah Davis" wrote:
Hi Pete,

That's what I have been doing. I was wondering if there was a formula I
could insert in sheet 2 that would do the work for me.

Thanks."Pete_UK" wrote in message

...
You could apply autofilter on the date column in Sheet1 (choose Custom
to set your range), and then copy the visible data across to Sheet2.

Hope this helps.

Pete

On Feb 2, 9:01 am, "Leah Davis" wrote:



Hi,

I would like to put a function into my spreadsheet that looks up data
meeting a certain criteria in sheet 1 then transfers the results into
sheet
2. For example Sheet 1 has 5 columns of data - one of these columns
contains
dates. In sheet 2 I would like to have all the data from Sheet 1 that
falls
within a date range that I specify.

Any help appreciated.

Thanks.- Hide quoted text -

- Show quoted text -