holdsworth
New Member
Before I start I understand that this problem has occured due to bad design but the amount of time put into the form so far prevents me from turning back!
I currently have a formula as basic as =$a1-$b1, I want to be able to drag this right and get =$a2-$b2 etc etc, I have over 600 rows to do with 12 columns so doing a paste drag down copy paste transpose over 600 times isnt a great solution, any help would be great!
I currently have a formula as basic as =$a1-$b1, I want to be able to drag this right and get =$a2-$b2 etc etc, I have over 600 rows to do with 12 columns so doing a paste drag down copy paste transpose over 600 times isnt a great solution, any help would be great!