I am trying to link a cell in one worksheet with a particular cell in another
worksheet but it has to meet a certain criteria. I am pulling into excel on
worksheet one my database from my business inventory with all of our prices.
On the other worksheet pages I want to create price sheets for various
customers. I want to link to certain products on worksheet one and pull the
correct pricing to the other worksheets. However, as our inventory changes,
the actual "row and column reference" for the item will not always be the
same. I want to link the information by a "search" field. For example, I
want worksheet 2 to look at worksheet 1 and find in column # 2 the
information for the product with the number 15. Column 2 will contain all
the numbers for our inventory products. I want the first line of my price
sheet on worksheet 2 to be the product # 15 from worksheet # 1. This product
# 15 may move around on page one as I refresh my data each week with new
pricing information. I always want the #15 data to show up on the SAME line
in the price sheet on worksheet 2. How do I reference this to make this
happen correctly and not mess up my price sheets each week. Thanks!