Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Seperation w/ multiple sheets
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
sales data seperation | Excel Worksheet Functions | |||
number seperation | Excel Programming | |||
time seperation | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions |