Hi,
Hope some one can help me on my query. I would like to write a macro which display a result as describe on the attachment. Is it possible to copy the data from one cell to other cell and insert a blank row?
Thanks for your help!
Hi,
Hope some one can help me on my query. I would like to write a macro which display a result as describe on the attachment. Is it possible to copy the data from one cell to other cell and insert a blank row?
Thanks for your help!
Hi
select your range and run this
tell is it ok?Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Hi Tom1977,
Thanks for your quick reply. Would you mind to attached any example to understand? I have never write any macro in excel. Also will this solution match the result describe on my "dummy_data" attachment?
Thanks
In attachment there is file with macro
select your range press Alt + F11 and press F5 to run code (this is one of few method to run macro)
I have tried the script and selecte the range but It doesn't show the result as mentioned on my initial file. How can i replicate this script to my dummy_data file?
Thanks in advanced!
In your first post was such statment
and in your file is thiswrite a macro which display a result as describe on the attachment
So I was able only to guess what results should be and my code does what I read from above.Results shoud be here
And if You want run code in Your file:
1. Press Alt + F11
2. Press "insert" on windows tab which will appear
3. choose module
4. past code into module.
and use e.g. pressing F5
Last edited by tom1977; 05-30-2012 at 04:43 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks