Hi guys,

I have another problem that I hope you can help me with!

I have 2 spreadsheets of delivery information. Sheet 1 contains data of all stores in the UK with addresses. Sheet 2 containts contacts of all stores that promotional matrial needs to be sent to.

The only common cell in a column of 4 digit store numbers.

I need to delete all rows from sheet 1 that do not contain a value in the store number column that is displayed on sheet 2.

Hope that makes sense.

ps

for forum moderators or regular posters, where does your knowledge of Excel come from? Is it experience, or are there books / courses you can reccommend?

Many thanks,

Chris