Pulling data from dates

[Kim]

I want to pull data from several worksheets based on a date range, put them
in a new worksheet to then utilize that data. Help?

 

[Don Guillett]

You would probably want a looping macro to get the data from each sheet and
place at the next available row in the destination sheet.

for each ws in worksheets
dlr=sheets("master").cells(rows.count,1).end(xlup).row+1
ws.range("ddd").copy sheets("master").cells(dlr,1)
next ws

 

[Kim]

Okay, I'm much more basic than this, can you dumb it down?

My dates are in AI. I need to look for a range say from 5/29/09-6/3/09 and
return the rows that have those dates.

Thank you so much!

 

[Don Guillett]

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.