I have data in Sheet Data and would like to make a report to the Sheet Result. By cutting duplicate data in each row. Then be rearranged as needed. Please help me.
I have data in Sheet Data and would like to make a report to the Sheet Result. By cutting duplicate data in each row. Then be rearranged as needed. Please help me.
Your attachment makes no sense, you also need to tell us what data needs to go where!, you also need to tell us how the rearrangement should be.
Have you used the macro recorder to record your actions? this will give you a very good starting point.
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)