Hi.. Badly need a help in the excel collation data. I need to combine data from multiple rows into one row in a separate sheet. My worksheet has 92,000 rows and 80 columns in this I have a a column which has a unique id but have a different values in rows and most of them are blank. I have attached the sample spread sheet for reference. Can any provide me the macro Pls.
Last edited by gan143; 09-09-2012 at 09:15 AM.
Try this
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.
Hi Mike.. It is working fine.. but I have received an error for this line.. Range("a1").Resize(i, UBound(a)).Borders.LineStyle = xlContinuous.. Can you help me understand on this pls.. or I can ignore & starting working the sheet...
Try this one, I believe my first code was missing the first column.
Please Login or Register to view this content.
Mike.. Same error..
Im not sure why, you can remove that line. All it does is add the border around the data.
Is there any other way to fix this error.. Mike...
If your sure you have 80 columns then try
Please Login or Register to view this content.
Mike.. It worked without any error.. Thank you very much for your support.. It is incredible .. U made my day.. Thanks..
Could try this and see if it would work..
Please Login or Register to view this content.
Same error.. Mike.. No change
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks