Thank you Satti & Dilip. Why didn't I think of this lol. Instead I
was trying to invent a combination for this.Macro could have easily done it
in single go. but the end user is someone who doesn't know whats cut n
paste. Still wants to be explained on each and every step. Sorry dont have
time to te
*Hi Shine,*
Slight modifications in the method suggest by Satti,
Enter following in cell A3
"" (blank)
Enter following in Cell A4
=A1*OFFSET(A1,0,1)
Now select the range A3:A4 and drag them to the right side as per your need.
Now apply the following formula to get the answer:-
=sum(3:3)
Note:
I'll give a good clerical answer- we'll if it's not required everyday.
Procedure:
1. in cell a2 write =A1*B1 and in cell c2 write =1*D1
2. select cells a2 till d2
3. Now point the mouse on the lower-right part of d2 cell (you will get a
black + mouse pointer)
4. Now drag the formula to the right a