Remove duplicates from Sheet 2
Hi everyone,
I have 2 sheets containing data Sheet 1 A1-AT623 and Sheet 2 A1-AF822. Where I already have data in Sheet 1 I would like to be able to delete (or extract to a 3rd sheet) that row in Sheet 2. If anyone could help that would be fantastic! Cheers Diddy |
Remove duplicates from Sheet 2
Examples and criteria?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Diddy" wrote in message ... Hi everyone, I have 2 sheets containing data Sheet 1 A1-AT623 and Sheet 2 A1-AF822. Where I already have data in Sheet 1 I would like to be able to delete (or extract to a 3rd sheet) that row in Sheet 2. If anyone could help that would be fantastic! Cheers Diddy |
Remove duplicates from Sheet 2
Sorry meant to say :-(
The value on which to look for duplicates is in C in both sheets and is a string 12-14 long with letters and numbers. e.g. F200797863807A Many thanks Diddy "Don Guillett" wrote: Examples and criteria? -- Don Guillett Microsoft MVP Excel SalesAid Software "Diddy" wrote in message ... Hi everyone, I have 2 sheets containing data Sheet 1 A1-AT623 and Sheet 2 A1-AF822. Where I already have data in Sheet 1 I would like to be able to delete (or extract to a 3rd sheet) that row in Sheet 2. If anyone could help that would be fantastic! Cheers Diddy . |
All times are GMT +1. The time now is 11:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com