I need to create order forms for my company so that an order is placed by "store location" in tab 1, then I need tab 2,3,4,5 etc... to auto-populate by vendor so the purchasing manager can just look at vendor when making orders. For example store "north" fills in tab 1, column A with "vendor1", column B "product name", column C "quanity", column D "unit price" column E "total price" . "Vendor1" would be the identifier for tab2 (vendor2 tab3 etc...), then the data i need populated would be comumns B through E from tab1.
This is way beyond my skill level, so i don't have an attempt to post. I'm not sure if it's even possible. Any help would be appreciated.
Bookmarks