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" wrote:
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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Kim" wrote in message
...
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?