LinkBack URL
About LinkBacks
As per Martin's request from my earlier thread.
I'm not worried about the order of the data.
What I want is information on turning a grid into a list.
As per Martin's request from my earlier thread.
I'm not worried about the order of the data.
What I want is information on turning a grid into a list.
Last edited by falcon5nz; 06-16-2009 at 10:34 AM.
Try this macro, I got a much longer list than you did:
Please Login or Register to view this content.
_________________
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!)
Thanks Mate. Why did I not think of a macro?
You just made my job so much easier. Not that it's much of a chore but every now and then I had to add to the formula. Which was frustrating.
I have edited the code to fit my worksheet and just wish to know is it possible to get it to paste into Cell A2 so I can have a column heading in Cell A1? If so what do I need to change in my code
Last edited by falcon5nz; 06-16-2009 at 10:32 AM.
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated...
Done that mate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks