Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells in different worksheets
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells from differnet worksheets.......How? | New Users to Excel | |||
Linking Cells from different worksheets | Excel Discussion (Misc queries) | |||
Linking Cells on different worksheets | Excel Discussion (Misc queries) | |||
linking cells between worksheets | Excel Discussion (Misc queries) | |||
formulas for linking cells in different worksheets | Excel Worksheet Functions |