View Single Post
  #1   Report Post  
brantty
 
Posts: n/a
Default copy formulas by dragging vertically

I have Sheet 1 with raw data in it. Sheet 2, Cell A1 is looking to Sheet1,
H1 for the data (ex. =Sheet1!H1). What formula can I use in cell Sheet2, B1
that will tell it to look to cell Sheet2, A1 and copy the cell just below
Sheet1, H1 or (=Sheet1!H2)?