How do I set up a constant reference to a cell that moves?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that gets it's data from an outside program. When I
refresh the spreadsheet, if a new product is added, it gets inserted
alphabetically, moving all of the other cells (rows) down. My worksheets that
reference the cells now have the wrong data as the information has moved. Is
there a way I can reference that specific data even if it moves to a
different cell when I refresh?
 
how do you refer to the cell?
you might want to change your references to vlookups, index matches or the
like
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move cell and maintain reference 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Formula refers to empty cells even when cells contains data 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Absolute References and worksheets 0
how do I referance a data valuation cell from another worksheet 2
How do I create a formula that references a specific tab in Excel? 1
Refer to a worksheet/name using cell contents? 5

Back
Top