See attached worksheet. I need a macro that will loop through column A, find any duplicates, delete that cell and the cells next to it in columns B & C. (SHIFT CELLS UP) In the attached worksheet, the highlighted cells should be all that is left when the macro is complete.
Thanks In advance,
jbmerrel
jbmerrel,
I can not follow your logic.
Can you post another workbook, with the raw data in columns A thru D, and the results you are looking for (manually formatted by you) in columns G thru J?
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
you can try this but im not sure if this is what you want
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks