Looping the macro

[sitaram86]

Hi Friends,

Someone kindly help me in looping the below mentioned macro till the last selection of a cell will be a blank one

macro.JPG

Please find attached the excel file with desired output. Shortcut key for the macro is Ctl + m

As of now i have to press and hold the key manually till all the data is converted into desired output format. Can anyone help me to do these activities in 1 single click ?

thanks

[davesexcel]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[davesexcel]

Assuming your actual is exactly like your sample.

Please Login or Register  to view this content.

[sitaram86]

That's awesome davesexcel thank u very much for the help

[AliGW]

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.