Copying/pasting a row of cells to a cell x distance away.

[JackDownAHill]

Hello there,

Not sure if this is possible or not.

I'm looking to be able to copy and paste a series of cells based on an input code a dynamic distance away from the formula cell.

In the image, there is an input value. This defines where along the scale the string is placed.
There is a predefined value. This defines which string to use.
and then the scale at the top.

At the moment, I'm using a vlookup for =B5&A5 in a database of all the possible code combinations. However this doesn't play kindly when I try and ad new strings of values (Adding A11 to the existing A8 to A10 strings for instance). I'm in need of a more elegant solution that allows me to change it around without having to generate a new array (that documant is already 20mb and almost crashes every time I open it).

Any help would be appreciated.

Thanks, Jack

 

[onlyadrafter]

Hello,

one solution, (there will be better).


In D2 enter

=IF($A$5=B$1,INDEX($B$8:$D$18,$B$5,3),IF($A$5=C$1,INDEX($B$8:$D$18,$B$5,2),IF($A$5=D$1,INDEX($B$8:$D$18,$B$5,1),"")))

and copy over as far as required.

Change D18 to a row number that you will not exceed.

Don't know how much bigger this will make your file.