find all blank cells in worksheet then call macro

[Gazou]

Good morning,

I have searched the forum but have not find what I am looking for. I need a Macro that will find all blank cell in a range of columns and rows and for every time blank cell, it calls a index match macro.

anyone has any suggestions?

thanks
Eric

[mjr veverka]

What does "index match macro" mean to you, what is it ?

[sintek]

Please Login or Register  to view this content.

[Gazou]

Hello,

The macro for the index match that I have recorded goes like this. Now I see another problem here, the next thing to match will need to change with the row.

Please Login or Register  to view this content.

Can this be done?

Thanks again
Eric

[sintek]

pls upload a sample file so that we can have a look..

[Marc L]

Or at least crystal clear explain the need for each blank cell …

[Gazou]

Every quarter IL need to update my data. Il add the updated data to sheet 2. to update the data in sheet 1, I will need to look for all the blanks 1 by 1 and then do the index match formulas.

It needs to do: if cell blank, then find the id in that row, search it in sheet 2 (Column B) + search for C1 (course name) in sheet 2 (Column C) , if both criteria match then then return date that is un column C.

Here's a sample.

[sintek]

Must it be match formula insert...

Please Login or Register  to view this content.