Autofill data troubleshooting - skipped cells

**drugramps** · 05-14-2010, 03:37 PM

Hello all,

I'm having trouble autofilling data from skipped cells of another worksheet.
I copied the value from the first worksheet (='Vault Apr19-Aug23'!AU24) into the second one.
What I want to do is autofill the values, but the first worksheet contains the values in skipped cells. When I use the autofill drag feature, it reads the cells hich are directly beside it, for example...AU24, AV24, AW24....etc....
I really want it to read cells, AU24, AW24, AY24..(SKIP A CEL).

Please help me with this one guys. Its getting real frustraing, and I need the help.
Thx in advance guys.

**ChemistB** · 05-14-2010, 04:37 PM

Try this
=INDEX('Vault Apr19-Aug23'!$24:$24,COLUMN(AT1)+COLUMN(A1))
Does that work for you?

**drugramps** · 05-14-2010, 05:19 PM

Wow!
That worked like a charm.
If you have the time to explain exactly how that worked that would be great.
If not I totally understand. What is the best learning resource for Excel?
Please give me a resource if you can.
Thanks alot ChemistB

**ChemistB** · 05-14-2010, 06:31 PM

I learned all this stuff from hanging around here.

INDEX returns a value from a cell in an array
=INDEX('Vault Apr19-Aug23'!$24:$24,COLUMN(AT1)+COLUMN(A1))
'Vault Apr19-Aug23'!$24:$24 is the array that you want to return a value from
COLUMN(AT1)+COLUMN(A1) specifies which column in the array, it would start with
COLUMN(AT1) +1, which is AU, as you drag it right it becomes
COLUMN(AU)+2 which is AW and so on.
Hope that helps.