I want to be able to populate a table in a separate tab from a cell that isn't blank in the master table
I manufacture copper goods and have a production schedule but some items go out for subcontract work (plating, brazing etc). When I enter the external subcontractor works order no into the cell I want this to automatically populate in my external sub-contract table I have created on a separate tab
What formulas would I use to do this?
Hope it makes sense