Hi I have been searching your posts and found a VBA post to split one row into multiple rows, however I need something that will return a little different results. I am looking for some help with this.
I have uploaded my sample data with a data tab and a result tab.
I would like to copy specific columns until the entire row is copy down (basically in a database format), along with the headings copying down in the last column.
I hope someone could help me.
Thanks for your help
UPLOADTEST1.xlsm
Try
Please Login or Register to view this content.
@ jindon,
Nice as always!
But your Code copies the Results 18 times instead of only once?
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
I don't know what you mean but I read the problem as my result.Originally Posted by Winon
@ jindon,
But your Code copies the Results 18 times instead of only once?
@ jindon,
What I am trying to say is that your Code Copies the Results over and over down to Row 127 instead of down to Row 8 only.
7 (column E to K) * 18 (rows) makes 126 rows + heading = 128
That's how I read the problem
@ jindon,
Sorry jindon,
You are right.
I did not notice the OP gave us a short example of the Results he is after.
Your Code is flawless!
Thank you so much it worked
Last edited by katkins0429; 03-10-2013 at 03:23 AM. Reason: SOLVED
Thank you again for this code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks