That sounds a little confusing, is it possible you could upload a sample
workbook?
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have the
opportunity to add attachmnets to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)
*Why not add a workbook?*
Providing a workbook will not only get you your answer quicker but will
better illustrate your problem, usually when we can see your data (-it
can be dummy data but must be of the same type-) and your structure it
is far easier for us to give you a tailored, workable answer to your
query :)
Kcope8302;416232 Wrote:
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 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.
What I am specifically looking for is a copy function that will first
verify
that it is a project for my team and then that PTR is located in C or
S. And
then another that verifies it does not have PTR in column C or S and
pastes
those lines.
--
Simon Lloyd
Regards,
Simon Lloyd
'The Code Cage' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=115857