problem with find blank cells and assign to names

[Konexcelmath]

Hi again. I'm new in vba-excel. I'm writting a code and i have stack to the following point.

Table:
col. A col. B col.C
1 [merged] GROUP A
2 John 2
3 Kostas
4 George 4 fff
5 Paul gh
6 Mary 6 fff
7 Chris 8
.. ...
20 Dan 10 gf

I would like a help for the code that, finds the blank cells in column B and say to me in which names (col.A) are assign these blank cells. The export I want to be kept in clipboard so to be paste to a word document or automatically open the clipboard. When I paste I want to be shown the merged cell that is the name of the table (GROUP A) and the names of the blank cells of col.B.

Also, with another macro button to tell me which names has the values of col c. ffff and gh. The export should be to another sheet.

Please for your help.

[Naveed Raza]

Better provide sample excel workbook, its make easy to resolve ur query

[Konexcelmath]

Thanks for the reply.
I provide a sample workbook and i'm waiting for your help.

[Naveed Raza]

Hi,

after seeing your file, i need some clarification.

for Kostas, mary, Chris there is no value in Column B then what u want me to do with names ?

for some names there is no value in column B but values there in column C , for this scenario what u want me do ?

[Konexcelmath]

Ok,
One macro will report the names Kostas, mary, Chris that they dont have values in col. B.

Another macro will report the names that have code [gg, ff] in col.C, despite of values of col.B, maybe the name that have code has no value in col.b

So I want two separate macro.

Thanks for your response.

[Konexcelmath]

Hi ,
How you see the clarifications? Can you help?

[Konexcelmath]

Hello, maybe please someone help me found a solution. Thanks in advance.

[Naveed Raza]

try this attached file and let me know is it what u r looking for...

Open the sheet and press Alt+F8 and run it..

Hope its what u r looking for..

[Konexcelmath]

I attach the sample file with the new questions.
Thanks in advance

[Naveed Raza]

Hi Konexcelmath

please try attached file.

let me know if u need any more clarification.

[Konexcelmath]

Ok thanks a lot, is what i have in mind.

[Naveed Raza]

konexcelmath

if your query got resolved and you happy with my solution then please dont forget click on ADD REPUTATION and give your valuable comments.