Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling data from dates
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling data from dates
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling data from dates
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling dates meeting certain criteria into different TABs | Excel Discussion (Misc queries) | |||
Sumif on pulling out data from dates | Excel Worksheet Functions | |||
Pulling data by start/finish dates | Excel Discussion (Misc queries) | |||
Sumproduct - Pulling info based on lenght of time between dates | Excel Worksheet Functions | |||
pulling back dates that meet certain criteria | Excel Worksheet Functions |