filling a series down a column

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

Hot-Rod

Hi, I was givin this advice, but it doesn't quite work,
anyone have any ideas?

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

You should try to keep in your original thread - as no-one will understand
why you were 'given this advice'. It was me who gave it you. You asked me to
suggest a way so that when you filled down a column, the sheet reference
incremented as you went. Why doesn't it quite work? What does it do? What
doesn't it do?
 
Hot-Rod, you've posted this question 2-3 times before, and received answers
each time. Where exactly are you entering the formula you received, and what
specific result are you looking for? The more precise you are in the
information you supply, the more likely it is someone can come up with a
definitive answer. And please try to stay within a single thread, so we can
all see this through to a successful resolution.
 
Hi Andy (thanks for the advice!) and others..The original
thread is at the bottom? Anyway, I can manipulate slightly
what you gave me, by switching the parenthesis around, and
I can actually get it to fill correctly. But now my
problem is where I have =INDIRECT as the first part of my
formula, I lose the functionality of referencing cells in
other worksheets, which is my main goal, which works by
having just the = sign

like this: =(Sheet3!A1)

I am just trying to enter data on many worksheets and have
that data simultaneously written to one sheet, the one
where I am trying to use this fill...
 
OK

Where you want to use AutoFill, use my formula. Where you don't need
AutoFill, just use the = sign and click away!
 
Back
Top