I want to extract information from one sheet to auto fill a purchase order (separate sheet) based on a selection of PO# (a single cell)
Can anyone let me know the best way to set this up?
I have a template for the PO already and I have another sheet with a heading matching each of the items on the PO.
I want to be able to select which row auto fills the PO template.
Can anyone let me know the best way to set this up?
I have a template for the PO already and I have another sheet with a heading matching each of the items on the PO.
I want to be able to select which row auto fills the PO template.