SpasticUnicorns
New Member
- Joined
- Jan 15, 2014
- Messages
- 6
Hi all,
I've been trying to find some info on the best way to do this but I can't really find anything. I currently have created a sheet that if we input a part number it will populate cells with the price, description and relevant pat number for each supplier. I want to be able to add a button for each supplier that can open our purchase order sheet, take the values of the cells in price, description etc and insert them into the relevant row of the PO. If the first row is filled then go to the next and so forth. Is this even possible?
I've been trying to find some info on the best way to do this but I can't really find anything. I currently have created a sheet that if we input a part number it will populate cells with the price, description and relevant pat number for each supplier. I want to be able to add a button for each supplier that can open our purchase order sheet, take the values of the cells in price, description etc and insert them into the relevant row of the PO. If the first row is filled then go to the next and so forth. Is this even possible?