In a new sheet,
In A2: =IF('[MAIN TIMESHEET.xls]October'!$F5="BWC",ROWS($1:1),"")
In B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX('[MAIN
TIMESHEET.xls]October'!B$5:B$100,SMALL($A:$A,ROWS($1:1))))
Copy B2 across to I2. Select A2:I2, fill down to cover the expected source
data extent. Cols B to I will return the required results all neatly
compacted at the top. Minimize/hide col A. Modify the source range
...B$5:B$100 to suit your actual data extents. Any good? Hit the YES below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Sarcalogus" wrote:
I understand where you are coming from but what i have so far is correct, it
must take everything in the rows where BWC stand in a particular column and
then put all the info in that row into the other workbook. However, if the
info on the main workbook is on rows 5, 20, 23, 27 on the main workbook, then
it just places it within those same rows on the other worbook leaving me
having to delete all the blank rows. What i want it to do is start filling up
the rows on the alternate workbook from row one and not leave any rows blank.

Does this make sense?