Help to make macro to blank cell if equal to another cell "dynamic".

[RuairiO]

Hi all,

Quick question (I hope) Very new to macros, but so far really enjoying playing around with them and learning and trying to apply it to an excel dashboard I use at work.

I use a simple advanced filter macro to extract unique list of names and copy to a column, then I need to remove or blank some names from an exclusion list. This list of names is used in my dashboard.

The below works fine, but I would like to make it "dynamic". Now it will just blank the 2 names I have in K2 and K3 respectively, but if a name is added in K4 and so on I would have to update the macro. Since my colleagues use my dashboard I would prefer to avoid this.

I was thinking to use For again in some way for the 2 and 3 in Cells(2, 11) and Cells(3, 11) so For j = 2 to 10, but it's not working out...

Any tips (or hints even) would greatly appreciated.

Please Login or Register  to view this content.

[sintek]

Hallo RuairiO

Welcome to our Forum...

Please take a moment to read our forum rules...here
Your post does not comply with Rule # 2
2. Programming code must be enclosed in code tags to improve readability. (A, Z)

Please Login or Register  to view this content.

So...Edit your post...Highlight the code and press the # button

Also...Have a look at yellow banner on Top about uploading a sample file...This assists with accurate supply of correct code assistance...

[RuairiO]

Hi all,

I actually figured it out kind of... I had to use one more Next I didn't notice that. I've done it now like this.

I do notice it makes now a lot of loops. Will that be an issue if the data is quite large?

Please Login or Register  to view this content.

[sintek]

Why not upload a sample file as suggested and we can simplify for you...
Thanks for adding code tags

[RuairiO]

Yeah sorry. Attached it now (hopefully).

Thanks for any feedback/hints. Much appreciated.

Br,

Rory

[sintek]

One way...

Please Login or Register  to view this content.

[RuairiO]

Could have sworn I replied with a thanks earlier, but anyway big thank you! I really appreciate you taking the effort to help some random guy from the internet! I hope to pay it forward in the future!

[sintek]

Glad I could contribute...Tx for rep...Please remember to mark as SOLVED...