Need help on the rows & column values to be merged to a single cell.

Hi Guys,

I have a serious problem and need help in writing a macro for the same.

I have attached them as a attachment. Kindly provide me the macro code.

ques.JPGsol.JPGques.JPGsol.JPG

I think a file as attachment would be appreciated.
Now the people with a possible answer will need to re-create your file.

excel sheet attached.Book1.xlsxBook1.xlsx

Or you could try this.

Please Login or Register  to view this content.

phanindrachitta.
Just now saw your attachments.
The code is as per your pictures. (Columns E:I and code result in Column L)
You'll have to change the above code to fit your new needs (attachments)

Good luck, Merry Christmas and a Happy New Year.

John

Hi John,

Thanks for the code, but the code is not exactly to my requirement. Code is concatenating the values from E5 to I5 and showing in L5. But my actual requirement is, VALUE of E4 : value of E5 /n VALUE of F4 : value of F5 /n VALUE of G4 : value of G5 so on.. Mentioned clearly below:

Tax Rebate: 1
Batch to run: 2
Admin Fee applied: 3
Tax Rebate: 4
Action Performed: 5

Kindly provide the code for the same.. Thanks in advance

This one should do.

Please Login or Register  to view this content.

phanindrachitta.
As far as I can see, both codes provided do exactly as your examples show.
If you mean that certain cell values need to be divided by other cell values, please provide which cells need to be divided by what.
As It shows in your examples, that should not be the case because it is very difficult to divide letters by numbers although I am sure there are people who can.

Let us know because I am at a loss for what you want.

Regards

John