I'm trying to filter a column.
The data in the sheet is referenced from an Original Sales Order and then I have 2 separate tabs of Sales Orders... one for US and one for UK.
On the UK tab I only want it to filter through the UK items (references in column B of the original sales order tab) and on the US tab I only want the US items displayed.
Firstly I do not know if this is the best way to go about it and secondly the whole sheet disappeared and only shows the rows relevant to the filter.
I still need the whole sheet to show - as there are other areas on the sheet that are needed but when I add the filter it will only show the lines referencing UK or US.... how do I still get the whole sheet to appear but only show the lines required? Any help on this very greatly received.
Many thanks.
Bookmarks