Row reference increment but preserve column reference

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

Guest

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
 
Copy this formula into the leftmost cell where you want the data

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

Then put this in the next cell to the right, adjusting the reference in the
COUNTA() function to reflect the cell used above

=OFFSET('[120 RANDOM WORDS.XLS]GROUP 3'!$A83,COUNTA($A1:A1),0)

& Copy it to the other cells
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Formula for Next Sheet and Every Other Cell 12
Autofill cell references with a pattern of every 110 rows 3
Row increments - 7
Dragging across columns: I want column constant, but row increment 6
Match and delete rows on two different sheets from reference numbers 4
Column reference in Vlookup formula 1
Can an incrementing value in a cell point to different worksheets? 3

Back
Top