Hi, Pls help me with a macro for removing duplicates from a row (keeping the first entry undeleted) and pasting them along with the first undeleted row horizontally.
Attached file carries the input and expected result.
tks
shreeja.
Hi, Pls help me with a macro for removing duplicates from a row (keeping the first entry undeleted) and pasting them along with the first undeleted row horizontally.
Attached file carries the input and expected result.
tks
shreeja.
This will work
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.
Thanks Mike, it works perfectly.
Could you please update the VB code for 10 columns and for unlimited rows?
thanks in advance.
Shreeja
It's already ready for unlimited rows. You lost me at 10 columns? You mean header columns?
Yes mike. its header columns.
Will it always be a max of 10 columns?
No mike it varies.. but will not exceed 10. could you pls update so that it accommodates max columns?
Tks
Shreeja
Last edited by shreeja178; 08-27-2014 at 01:00 AM.
Give this a try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks