Excel Help needed

[allllec]

right firstly I'm not totally sure this is the right area but hell seems close enough

secondly I'm useless when it comes to excel and such so bear with me

right basically i have 2 sheets

both have just over 5 thousand items.

column a contains a code
column b contains manufacturer

basically one is the old system/website

and the second is the new system/website

so apparently 2 things have happened. since the old system new items have been added to the new list and also not everything imported to the new system correctly so this is going to have to work both ways

i need a way of creating TWO new lists in a new sheet. One will contain items which are on sheet 1 and not sheet 2

and vice versa. sounds simple enough but i have no idea how to go about this.

how would i do this ?

cheers

alec

 

[allllec]

Took the adice i've a very smart chap and just plopped the whole lot in access 2007 and used queries. all sorted now

thanks for trying thou!

ta

alec

 

[allllec]

Hehe =p

i cant believe i didnt think to do it that way in the first place! *pulls face*

Its well efficient, working with several tables all containing upto 13k items without a single bit of lag or issue

right, the big one tomorrow - gotta start putting stuff thats missing on the company website! hopefully goes nice and painlessly like today.

thanks again for your help people