I have a question and I dont know if this and be done but I was wondering is there is a away to make a formula increase itself per colunm.
=L12&" - "&I12&" "&H12&" "&J12&" - "&K12 <---- this is the formula that I am using
Say this is in A12 and I want to copy this to A13.
Is there away to make the the number 12 (=L12&" - "&I12&" "&H12&" "&J12&" - "&K12) change to a number 13 and increment by 1 for each and ever line I enter this in. 14,15,16 and so on.
So =L12&" - "&I12&" "&H12&" "&J12&" - "&K12 would change to this =L13&" - "&I13&" "&H13&" "&J13&" - "&K13 and so on.
What I am doing is pulling words from 4 different columns and making one column. and I am trying to figure out the best way to do this so I am not having to type this formula for thousands of columns.
Any ideas?
Bookmarks