Macro to copy certain cells to new worksheet based on cell value

[mmctague]

Basically here is what I want to do.

If column N of Project Pipeline =TBD, N, C, then Copy cells B:E & M&N of that row over to Project tracker A:F. As more projects as added and meet criteria or if existing ones change to meet the criteria they are added to the end of the previous result.

Here is what it currently does
When I run the macro again it keeps the old data plus returns the old data and the new.

What I want is it to only return new data at the bottom of the list

Any help would be appreciated.

-Mike

[mmctague]

i have modifiyed the code but get no result

Please Login or Register  to view this content.

[Steffen Thomsen]

Hi,

try this code in sheet 1 code module

Please Login or Register  to view this content.

This will fire every time a value changes in column N and if the value is change to "TBD", copy the range to Sheet 2

[mmctague]

Thanks Steffen, but how can i get it to return a chage or add at the bottom of the last querry in sheet 2.
See my workbook attached

[Steffen Thomsen]

In the file you have, try chaning a value in column 14 (N) as soon as you change a value there to "TBD" the cells will be appenden to the tracking page.

[mmctague]

It does work but if something in sheet 1 row 23 changes to TBD, N, C, OR H i want it to pull over to sheet two the next avaliable row not inline.

Is that possible?

[mmctague]

Anyone have any Ideas?

[Steffen Thomsen]

Then just modify it,

Please Login or Register  to view this content.

[mmctague]

I need it to pull more than one value (TBD, C, N, or H)

I did this but it didnt work

Please Login or Register  to view this content.

[mmctague]

Marking this as solved. the code below worked . Thanks for all the help its much appreciated.

Please Login or Register  to view this content.