Filling a series

  • Thread starter Thread starter Hot-Rod
  • Start date Start date
H

Hot-Rod

I can't seem to fill a series the way i need it, I think
it's looking at the last number, but does anyone know how
to make it fill down a column by the sheet name, as
opposed to the last character typed?

I want it to fill like:

=(Sheet1!A1)
=(Sheet2!A1)
=(Sheet3!A1)

but I get:

=(Sheet1!A1)
=(Sheet1!A2)
=(Sheet1!A3)
 
I answered this at about 1:30pm on Tuesday in the first thread you
started--"filling series problem". It's really a pain in the ass when
you ask the same question in multiple differently named threads instead
of sticking to the original.

="Sheet"&ROW(A1)&"!A1"

Alan Beban
 
Hi

You'd have to use something like this, which uses the row number to
increment the fill:
=INDIRECT("sheet"&ROW()&"!A1")
 

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

filling a series down the column 1
AutoFill with sheet reference help 6
how do I create a nonadjacent series for autofill to go by? 3
specific data 1
formula referring to a worksheet 3
Set non-continuous PrintArea via Function / Name 0
Series fill only copying and fill series greyed out 1
Cell Reference 1

Back
Top