Computing.Net > Forums > Office Software > Excel Data Transfer Between Workshe

Excel Data Transfer Between Workshe

Reply to Message Icon

Original Message
Name: DaveR
Date: July 28, 2007 at 21:21:48 Pacific
Subject: Excel Data Transfer Between Workshe
OS: XP Professional
CPU/Ram: 2.2/2gig
Model/Manufacturer: Dell/Latitude D810
Comment:

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


Report Offensive Message For Removal

Response Number 1
Name: Bryco
Date: July 29, 2007 at 04:48:49 Pacific
Subject: Excel Data Transfer Between Workshe
Reply: (edit)

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


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Excel Data Transfer Between Workshe

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software