G
Guest
Experts kindly help me....
We receive data sheets daily from 20+ locations and I paste the data in the
same workbook on daily basis (having row1 as title row, always the same
format), same data files come everyday with yesterday's additional info.
(no.of.rows will differ to each sheet run from 70 to 500. I have a macro to
extract data from each file to my workfile.
Now I want a macro to run and extract data* in the 1st sheet (query) from
all the 20+ sheets.
Criteria will be :
3rd column 7th column 8th column
(3) Location (7) Biziness (8) date
When we input Location, Biziness & date from/to in Sheet1 cells b3, c3, d3, e3
We need data to be extracted from all sheets and put in sheet1
cells to pick from each row will be : col3, col7, col8, col4, col5, col9,
col10
procedure should be :
select sheet1
For row2 to LastRow
check col3,col7,col8
if col3 = b3 and col7=c3 and col8 is between d3 & e3 is true
extract from that row col3, col7, col8, col4, col5, col9, col10
else
ignore that row
endif
set pointer to next row
next for
next sheet til last sheet
Thanks in advance..
We receive data sheets daily from 20+ locations and I paste the data in the
same workbook on daily basis (having row1 as title row, always the same
format), same data files come everyday with yesterday's additional info.
(no.of.rows will differ to each sheet run from 70 to 500. I have a macro to
extract data from each file to my workfile.
Now I want a macro to run and extract data* in the 1st sheet (query) from
all the 20+ sheets.
Criteria will be :
3rd column 7th column 8th column
(3) Location (7) Biziness (8) date
When we input Location, Biziness & date from/to in Sheet1 cells b3, c3, d3, e3
We need data to be extracted from all sheets and put in sheet1
cells to pick from each row will be : col3, col7, col8, col4, col5, col9,
col10
procedure should be :
select sheet1
For row2 to LastRow
check col3,col7,col8
if col3 = b3 and col7=c3 and col8 is between d3 & e3 is true
extract from that row col3, col7, col8, col4, col5, col9, col10
else
ignore that row
endif
set pointer to next row
next for
next sheet til last sheet
Thanks in advance..