View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wienmichael wienmichael is offline
external usenet poster
 
Posts: 11
Default Offset to a referenced cell

Cell B2 Sheet2 in my workbook returns the value from cell A1 Sheet1. I want
cell B3 Sheet2 to return the value from a cell offset to cell A1 Sheet1,
(e.g. 2 columns right). However, I want to be able to change the cell in
Sheet1 that cell B2 Sheet2 references (e.g. to cell A2 Sheet1). I still want
cell B3 Sheet2 to return a value offset 2 columns right, but this time to
cell A2 Sheet1. Help. Thanks