So i've tried like hell to figure this out but have no programming skills at all. I have basic excel experience most of it self taugh or what i've picked up from reading threads.
What i have is an excel file with 2 separate sheets in a workbook and the first sheet will be a listing of different navy slings along with all info about that one sling spread accross the row.
Each new row has a new and saparate sling assembly part number (p/n#)
as an example; once the info for an x number of slings is entered i will move to worksheet #2 and print the template.
i want to select the part number and make a drop down of all p/n# from sheet#1. when a p/n# is selected i want the other 6 cells to fill in with the correct info.
i could sit there and write a bunch of IF arguements that would get the job done but considering i could have as many as 40 different slings i will have to add and you can only have 8 IF arguements per cell that is going going to take alot of debugging. and like i said i'm very amateur to this.
any help i recieve is greatly appreciated. plz email me @ firstname.lastname@example.org if you want me to email you the xls file so you can get a look at what i'm trying to describe