Populate a field based on a selection in excel 2003
Posted on 2012-03-20
I don't use excel that often but I am stuck until I can convert the data. I have an excel file and the first tab contains two cells. Cell a1 has a heading of supplier, cell b1 has a heading of supplier number. I have a second tab called suppliers that contains the actual data of suppliers and supplier numbers. I was able to create a drop downlist in the first tab so basically you can press an arrow button and the list of suppliers shows up based on the supplier data in the suppliers tab. My question is what do I have to do to have the supplier number populate in cell b1 automaitcally based on the supplier they select in the "a" cells. I don't know how to tie this from my suppliers tab or the syntax. Does that make sense?