Data Seperation w/ multiple sheets

K

Kcope8302

I have a workbook with 4 Sheets(PTR,NMP,Reference data, Work Area). The first
2(PTR and NMP) are used to display the data from Work Area and Reference
Data.

In the Work Area I paste a dataset composed of all projects from the year
for all teams. In reference data I have a list of project numbers relevant
for my team.

For PTR and NMP to have the correct data I first need only the relevant
projects in the Reference tab to be seperated from all other projects in the
workarea sheet. Column A in both Reference Data and WorkArea have the project
numbers.

Then I once I only have the projects relevant to my team I need columns C
and S to be searched for 'PTR', if found paste that whole line of data in the
PTR worksheet. Otherwise put it in the NMP worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy line if 21
Copy and paste entire line starting at cell W 5
Lookup and copy cells if match found 2
Tracking Resources as Trade Types - Rather than Individuals 1
Delete string if string has only one item 2
Copy entire row to different worksheet 5
Copy Row if Column A matches between different worksheets 1
Compare cells and copy columns after match 2

Top