Walking through an array

[indijonesjames]

Okay,

I have a, what I think, is likely a simple question. I looked through some threads without successfully finding one similar so I'll ask.

I'm an Engineer currently stuck working on this finance issue because the lady who ran it left the company - no idea how it got to me rather than someone in Application Development... anyways.

Basically, I have a list of names in a column, I want to create a variable inside a reference that will increment through that column and place it's value inside the reference. For example

For examples: c:\sheets\[variable] which will change in B1, B2, B3 to reflect the content in cells A1, A2, A3

Is it possible to do this?

I could do it manually but the sheet has has over 100 references that need to be made.


Anyways, thanks!

[mrice]

="c:\sheets\" & A1

pasted into B1 and copied down?

[indijonesjames]

I think that just might work. It seems really simple.

So, if my reference looks something like..

=+'\\asdf\EmployeeResources\Development\Succession Management and Planning\Succession Management Individual Development Plan\[blah.xls]Objective 2'!$G$2

What syntax would I require to get the cell to work in place of 'blah'? I got a simple reference working, but this one references another workbook.

[mrice]

Have a look at ..

http://www.mrexcel.com/forum/showthread.php?t=67881

[indijonesjames]

I'm using Win 7 Pro 64bit, subsequently I am using 64bit Excel 2010.

Therefore I can't get the morefunc to work correctly as indirect.ext hasn't been written yet.

I managed to do some concatenation and hardcoding to work around not being able to do it.

Thanks, anyways.