mercmannick
07-28-2005, 11:16 AM
:dunno
i have a shared workbook on a networked drive,
i would like to be able to grab some specific dat from this file without opening it ?
the data i require though is only identifiable as interior colour red , any other data in this col i would like to ignore,
would like to be able to copy entire row and put in new workbook.
basically this sheet (networked one) i would normally put a autofilter on and on col c pick which section i am looking at at time, ie: workcentres "S17", filter to just these , then look in col j and if it is highlighted red then copy this row to a new workbook and so on,
any help would be appreciated
Merc
:banghead:
i have a shared workbook on a networked drive,
i would like to be able to grab some specific dat from this file without opening it ?
the data i require though is only identifiable as interior colour red , any other data in this col i would like to ignore,
would like to be able to copy entire row and put in new workbook.
basically this sheet (networked one) i would normally put a autofilter on and on col c pick which section i am looking at at time, ie: workcentres "S17", filter to just these , then look in col j and if it is highlighted red then copy this row to a new workbook and so on,
any help would be appreciated
Merc
:banghead: