I would like to consolidate multiple rows into one row. An example is attached, with beginning and ending versions on each tab.
I need to move each of the "New Task" columns (N-U) to one line based on each "house" number (column B). The final version lists the "New Task" numbers out to the far side, as there could be many numbers and it could extend out very far.
In your raw data in your original file, are columns V to Y listed after M? Or they can be listed in any column since you can have any number of "New Task" columns?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Columns V to Y can be put in any column in the final product.
Try this:
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!)
Here's another
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Excellent, it worked! Thanks for your help!
If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks