Help with Macro please

[chef]

Hi,
Not sure if this is possible.

I have 2 worksheets. one is called previous and the other called current

Both have identicle headings and approx 15000 rows.

In column A on both sheets is a financial code but they can be added to each month.

I want to be able to lookup/match column A in both sheets and in current worksheet identify any new codes, maybe by an indicator of 1 say in column I.

I then want to sort this and only be left with the new codes and associated headings.

I hope I have explained this well enought and hope possible. Any help is greatly approeciated.

Many thanks

 

[CWatts]

On your current tab, insert a column before your column of financial codes. They should now be in column B with a blank column A. I'm assuming the financial codes for previous are in column A.

Put this formula in column A and drag it down your list.
=IF(ISERROR(MATCH(B2,Previous!A:A,0)),"New","")

Go back up to your top row of data and select A1. Turn on your auto filter (under Data). You'll then get drop downs. On the drop down in A1, click it and REMOVE the check mark from New. You'll be left with everything that was old. Highlight rows 2 to the end end and right click and delete them. THen disable your auto filter and you'll be left with new ones (and you can delete column A)

 

[chef]

Hi,
thanks for quick helpful response.

regards