ads_3131
05-08-2012, 02:31 AM
Hello....
Could really do with some expert help with my attached spreadsheet.....
Basically , i want sheet2 to look at the table in sheet1 and pull only the rows out that are our problems..... and place neatly into sheet2 in the formated table....
I know the formula in sheet2 will need to lookup a set range of (F4:F29) as a starting point in sheet1..... where if any text is in this column , then copy that row and place it neatly into sheet2's formatted colum, i just dont know how to implement this?
any help would be appriciated ......
tar
Could really do with some expert help with my attached spreadsheet.....
Basically , i want sheet2 to look at the table in sheet1 and pull only the rows out that are our problems..... and place neatly into sheet2 in the formated table....
I know the formula in sheet2 will need to lookup a set range of (F4:F29) as a starting point in sheet1..... where if any text is in this column , then copy that row and place it neatly into sheet2's formatted colum, i just dont know how to implement this?
any help would be appriciated ......
tar