View Full Version : help find target !!

04-08-2013, 10:24 PM
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

Simon Lloyd
04-08-2013, 11:02 PM
Simply use a pivot table! or filter in place: http://office.microsoft.com/en-gb/excel-help/filter-for-unique-records-HP003073425.aspx