Copy data

  • Thread starter Thread starter cgx79
  • Start date Start date
C

cgx79

Hi,

i hv 50 record in sheet a 30 of them r car number n 20 of them i
car brand. I want all the car number to be able to copy to sheet 2 co
A auto ,but dupilcate car number should not appear.

If i gt 5 car number 1234 then 1234 should only appear once on shee
2..
 
Hi
try the following
- select your sorce range
- goto 'Data - Filter - Advanced Filter'
- check 'Unique entries' and choose your target range
 
Ya i know this but the problem now is how to copy the data 1 want fro
sheet 1 to sheet
 
Back
Top