Software

Ask something
Question Locked

Sheet Reference

0 helpful
3 replies

by me2buc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to create a summary sheet in excel 2007 that will reference cell numbers in various sheets without having to type the sheet name in. For instance, if the sheet 2 is Johnson, AZ and cell a1 is "Marketing Location", I would like to have it automatically populate that cell with Marketing Location. I would then like to drag that formula down so that it will list the next location. For instance if the formula was =(sheet2!,A1) then the next would be =(sheet3!,A1) etc.

Your assistance is appreciated.

3 replies

by thumbsup2

Sorry, but drag doesn't work like that.

You could write a script to do it for you. But, it would probably be faster to just type them all in.

This discussion is closed to new replies.