Create a list based on a list

[Tresfjording]

Hi ...

I have this list of volunteers containing names, addresses, email etc.
For active members the cell with the name, is colored green.

How can I get a list of active members i a new worksheet?

I advance thanks ...

regards
Øyvind Granberg

[LeoTaxi]

Not to say without excel file

Kind regards
Leo

[Tresfjording]

Oh ....
Sorry ...
Here is a test file ...



https://1drv.ms/x/s!AoTBup2FdjrGg4g_fpk2DLErzdaAPw

(Upload would not work for me today)

Tresfjording

[Winon]

Hello Tresfjording,

Try this Code below. Just Change your Ranges and Sheets to suit.

Please Login or Register  to view this content.

Check out the attached working sample Workbook.

Regards.

[Tresfjording]

Thank you very much! ...

I am struggling here.

Tried to implement this to another spreadsheet.

Like this:

Please Login or Register  to view this content.

It produces an Run-Time error 424.
Clicking on Debug, and the line defining variable Lastrow is marked in yellow.
Can't seem to figure out why ....

--tresfjording--

[Winon]

Hello Tresfjording,

I am not allowed to help you, if you do not follow the Forum Rules.

Go Back to Post#5, Click on Edit Post and follow the instructions below.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thank you.

[Tresfjording]

Done ...

Sorry, new to forum and programming.

[Winon]

Thank you Tresfjording,

Please try the Code below:

Please Login or Register  to view this content.

Hope that helps!

Regards.

[Tresfjording]

That did it ...

Thanks a LOT!!!
I owe you one ...

[Winon]

Hi Tresfjording,

You are welcome, glad I could help!

As for the

I owe you one ...

, a Click on the Star at the bottom of my Post to the left, would suffice, thank you.

Please remember to mark your Thread as "Solved".


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

It is customary to give feedback to those that have helped you by clicking on the asterisk (Add Reputation) at the bottom of their post.

Enjoy the Forum!

Regards.