View Single Post
  #1   Report Post  
Pwanda
 
Posts: n/a
Default Row reference increment but preserve column reference

Hi,

I need to refer to another workbook using:

='[120 RANDOM WORDS.XLS]GROUP 3'!$A83

I need to import data from A83-A98 from one workbook to another, but across
a row (ie. autofill does not work). How can i adjust the formula so it
increments the row number but not the column? thanks