Hi,
wanna help code to find the unique target in worksheet which don't know which cells columns located, also don't know vb macros can do it or not, anyone can help me that ? actually if find the target then i would delete all right side columns and upside row.
your help i highly appreciate
Simply use a pivot table! or filter in place: http://office.microsoft.com/en-gb/ex...003073425.aspx
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)
Posting Permissions
Reply With Quote
