K Kim Jun 30, 2009 #1 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?
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?
D Don Guillett Jun 30, 2009 #2 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
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
K Kim Jun 30, 2009 #3 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!
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!
D Don Guillett Jul 1, 2009 #4 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.
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.
