F
Frank L
I have 16 spreadsheets and 1 spreadsheet named "Masterlist".
I name one of the sheet tabs "85002" and then assign that name t
cell A3 by using,
=MID(CELL("filename",A1,FIND("]",CELL("filename",A1))+1,255 .
I need to have the newly named sheet "85002" reference column F of th
"Masterlist" sheet and beginning at row 5 going downward, return an
row that has the 85002 number in column F, without all of the empt
rows between where the cells where 85002 may be found.
For instance if "Masterlist's" cell F10 has 85002 entered, then all o
the values in that row, in columns A through K would be transfered t
the new sheet beginning on row 5. Then, if F13 contained 85002 i
would appear in the next row on the new sheet without having 3 empt
rows in between the two rows.
Is this possible?
Frank
I name one of the sheet tabs "85002" and then assign that name t
cell A3 by using,
=MID(CELL("filename",A1,FIND("]",CELL("filename",A1))+1,255 .
I need to have the newly named sheet "85002" reference column F of th
"Masterlist" sheet and beginning at row 5 going downward, return an
row that has the 85002 number in column F, without all of the empt
rows between where the cells where 85002 may be found.
For instance if "Masterlist's" cell F10 has 85002 entered, then all o
the values in that row, in columns A through K would be transfered t
the new sheet beginning on row 5. Then, if F13 contained 85002 i
would appear in the next row on the new sheet without having 3 empt
rows in between the two rows.
Is this possible?
Frank