Dragging down cells containing names

Tuberockin · Feb 20th, 2002, 05:15 AM

Hello.

This is no doubt a very simple question and I'm sure when an answer pops up I will feel silly for asking the question, but...

How can you drag and expand down a formula if that formula contains a name. For example if I have names such as Start1, Start2, Start3 , and in cell a1 i place '=Start1'. Can i then drag this down so that the following say Start2, Start3 etc. Simply dragging down doesn't seem to work.

Hope this is a clear explanation. A long day, very tired and my skills in explanation were used up by lunchtime.

Thankyou in advance.

[ This Message was edited by: tuberockin on 2002-02-20 04:34 ]

Juan Pablo González · Feb 20th, 2002, 07:11 AM

Try this:

=INDIRECT("Start"&ROW(A1))

And drag it down.

Tuberockin · Feb 20th, 2002, 03:34 PM

Yep, worked a treat, thanks mate.

Feb 20th, 2002, 07:11 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Try this: =INDIRECT("Start"&ROW(A1)) And drag it down. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 05:15 AM	#1
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	Hello. This is no doubt a very simple question and I'm sure when an answer pops up I will feel silly for asking the question, but... How can you drag and expand down a formula if that formula contains a name. For example if I have names such as Start1, Start2, Start3 , and in cell a1 i place '=Start1'. Can i then drag this down so that the following say Start2, Start3 etc. Simply dragging down doesn't seem to work. Hope this is a clear explanation. A long day, very tired and my skills in explanation were used up by lunchtime. Thankyou in advance. [ This Message was edited by: tuberockin on 2002-02-20 04:34 ]

Feb 20th, 2002, 03:34 PM	#3
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	Yep, worked a treat, thanks mate.