I have a massive database that I need to convert the records to the horizontal here is a sample
I need it to look like this
Please Login or Register to view this content.
etc....Please Login or Register to view this content.
Help!!! This driving me crazy and I'm under a deadline, I'll tried multiple VBA's and none have worked
Last edited by JBeaucaire; 12-05-2012 at 09:20 PM.
This should do it:
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-05-2012 at 09:57 PM. Reason: updated a line of code
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It's kind of working for the first record in every number but it keeps repeating on it self like this
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-05-2012 at 09:55 PM.
Sorry I don't know how to get the dialogue box to make it look less messy
See the attached
Gary's Student
Try post #2 again, I've changed a line of code, this should delete those rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks