Copying and pasting visible filtered data ONLY to a new plan

[Peter Rooney]

I've posted this question on the MSDN board, but as I'm not sure if it can be
done at all, let alone coded, I thought I'd ask it here, too.

I have a plan which contains a number of projects, each broken down into
activities carried out by one of four teams in my department - the
appropriate team name is held in a dedicated column for each task and sub task

I have created filters to filter the database depending on the contents of
this column, and they work fine. Filtering also works OK if I use Autofilter.

However, I want to then copy the filtered data to a new plan, but when I do,
not only do I get all the filtered data, but all the other tasks in between,
too.

Is there anything I can do to paste only the visible, filtered data into my
new plan?

Cheers

Pete

 

[John]

Pete,
No need to cross post. Every MVP I know reviews posts in each newsgroup
and you already posted this yesterday in the developer newsgroup. I gave
a reply and one thread should be sufficient. Although you may believe
cross posting will get additional responses it can also waste someone's
time if the answer has already been given in another newsgroup.

John

 

[Peter Rooney]

Sorry, John,

I just wasn't sure if this was a VBA problem, or whether you just couldn't
do what I'm trying to to in Project anyway - hence my post here - I didn't
realise you guys visited both types of board. I wasn't sure if I should post
what might be a "Project" type question, as against a developer type question
on the developer board.
Sorry to take up your time and I'll stick to the developer board in future!

Regards

Pete

 

[John]

Pete,
I know the various types of newsgroups can be confusing to a poster. As
I said, the MVPs (and even others who respond) generally check all
newsgroups. We've actually seen more "rogue" posts than anything else. I
define a "rogue" post as one that has nothing to do with any part of
Project (i.e. posts on Excel, Word, etc.). If a post is related to
Project but in the wrong group (i.e. VBA question in the main
newsgroup), most MVPs will answer the question anyway. If they don't
have that expertise, then they may advise posting in a more appropriate
group.

We pride ourselves in being one of the best newsgroups for getting
answers but that "service" does take time (we are all volunteers) and we
would rather not spend unnecessary time answering a post that is already
been addressed.

Just use your best judgment as to which newsgroup is most appropriate
but only pick one per question. We will take it from there.

John