I am trying to do two things in one Excel Workbook.

I am trying to copy only Expired items (sheet 1 N2 = "EXP") to Sheet 2 D1.

The same worksheet lists up to 10 locations for one National Stock Number (NSN)(one per line - the NSN is the first field - A1 on each row) with a total of about 300 NSNs. The master worksheet has just over 1,000 rows. I am trying to copy just the first NSN entry on Worksheet 1 to Worksheet 3 which will enable me a printable list containing just one entry for each NSN.

Any help would be greatly appreciated.

Thanks

Dave

Dave,

If I am reading your questions correctly and you are doing this for a living then these are fairly basic functions within Excel and if I am reading them correctly then you should encourage your employer to set you up with a basic and intermediate Excel course as it would go a long way.

1. If your NSN number is in the first column and your "EXP" is in the second then copy colums A and B to Sheet2.
Select columns A and B on Sheet2 and go to Data, Sort and select to sort by column B.
Once sorted simply delete all that are not showing "EXP"

2. Copy column A to Sheet3.
With your data in column A selected then go to Data, Filter, Advanced Filter.
Use Filter the list in place.
Your List range will already be selected.
Place a check next to Unique records only.
Click Ok.

You can then sort them if needed.

HTH
Bryan