Wednesday, 14 August 2013

Trying to create a specific loop in excel to get an output

Trying to create a specific loop in excel to get an output

bear with me on this question. I'm pretty sure it'll be easy for those who
have knowledge in this field, but I do not know much about VBA or how to
create loops in Excel to be creating this formula:
Please review the picture here @
http://img41.imageshack.us/img41/9089/ymhh.jpg.
What I'm trying to construct is a loop that'll concatenate those numbers.
EX. I want to concatenate in this order A2,"-",B2; A3,"-",B2;
A4,"-",B2.....A16,"-",B2 Once everything in A1- A16 is concatenated with
B2, I want to move on to concatenating A1-A16 with B3.EX: A2,"-",B3;
A3,"-",B3.....A16,"-",B3
I know this is possible because certain loops can be created to go through
with this procedure, but I do not know VBA and am not sure if this is
possible with just the pre-existing formulas in Excel. Thanks to anyone
who helps.

No comments:

Post a Comment