I am working on a project database where I have multiple suppliers. Each row (columns A to DG) in the database (tab "Process Equipment") is one piece of equipment, valve or pump etc etc,
I would like to have a separate tab for each supplier (Pentair, Burkert, BTL etc etc) to make ordering easier instead of cutting and pasting 20 to 50 rows of information cross to a new tab.
Column N has the suppliers name in the cells.
Thank for your help.
Bookmarks