Hi,
I need to extract rows from a master spreadsheet based on the department name which is located in column A.
For example:
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Then I want a formula on another worksheet that copies each row that contains 'hoses' in the first column.
The table is live data attached to a MS query, so its refreshing each day.
I know I could use versions of copying etc, but I need the data to flow into the next sheet without manual intervention.
The department column is a manually entered column and I tried making it a table then filtering it by hoses, but when I refresh the table it looses its filters each time.
Please help! Really stuck with this one. I want something like the sum ifs formula, but I don't want any adding up of data etc.
Thank you!
I need to extract rows from a master spreadsheet based on the department name which is located in column A.
For example:
Department | STOCK_CODE | DESCRIPTION | QTY_IN_STOCK | ORDER_NUMBER | ORDER_DATE | NAME | QTY_ORDER | QTY_DELIVERED | Outstanding | DESPATCH_DATE |
Hoses | A1.5MS/R152 | 152mm x 1.5m Semi-Rigid Aluminium Hose | 32 | 107949 | 04/01/2018 | Naples Components Limited | 6 | 0 | 6 | 08/01/2018 |
Hoses | A1.5MS/R152 | 152mm x 1.5m Semi-Rigid Aluminium Hose | 32 | 107936 | 04/01/2018 | WS Westin Ltd (account 1) | 20 | 0 | 20 | 10/01/2018 |
Purchasing | A3M2PLY102 | 102mm x 3m Flexible Aluminium Hose | 304 | 107940 | 04/01/2018 | North West Aluminium | 30 | 0 | 30 | 08/01/2018 |
Hoses | A3MS/R102 | 102mm x 3m Semi-Rigid Aluminium Hose | 14 | 107961 | 05/01/2018 | Vapourflow Ltd Stores | 5 | 0 | 5 | 08/01/2018 |
Hoses | A3MS/R127 | 127mm x 3m Semi-Rigid Aluminium Hose | 115 | 107876 | 03/01/2018 | Kair Ventilation Ltd | 5 | 0 | 5 | 08/01/2018 |
Hoses | A3MS/R127 | 127mm x 3m Semi-Rigid Aluminium Hose | 115 | 107961 | 05/01/2018 | Vapourflow Ltd Stores | 5 | 0 | 5 | 08/01/2018 |
Purchasing | ALUM102X10 | 102mm x 10m Flexible Aluminium | 1043 | 107813 | 02/01/2018 | Worth Electrical Wholesalers Ltd | 2 | 0 | 2 | 05/01/2018 |
Purchasing | ALUM102X10 | 102mm x 10m Flexible Aluminium | 1043 | 106813 | 29/11/2017 | Vortice Elettrosociali S.p.A £ A/C | 9 | 0 | 9 | 08/01/2018 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Then I want a formula on another worksheet that copies each row that contains 'hoses' in the first column.
The table is live data attached to a MS query, so its refreshing each day.
I know I could use versions of copying etc, but I need the data to flow into the next sheet without manual intervention.
The department column is a manually entered column and I tried making it a table then filtering it by hoses, but when I refresh the table it looses its filters each time.
Please help! Really stuck with this one. I want something like the sum ifs formula, but I don't want any adding up of data etc.
Thank you!