VBA isnumber(match()) formula

[tomas]

Hi

I need a makro which can apply a formula in c column for each row which has corresponding entry in column B. I recorded makro but it's for statis range and can't find out how to do it dynamically

thanks

 

[vletm]

tomas
You need to Upload a Sample file
with clear rule
which would explain
needed result.

 

[tomas]

tomas
You need to Upload a Sample file
with clear rule
which would explain
needed result.

sorry I forgot. Column B should contain 1 additional record to column A but number of rows will differ so It will differ also for column C which has the formula in

 

[vletm]

tomas
I would do it this way - without formulas...

Edit something within A&B-columns ...

 

[tomas]

tomas
I would do it this way - without formulas...

Edit something within A&B-columns ...

I just don't understand what you have done

 

[vletm]

tomas
Didn't You ask a macro which would do something?
Do that file give needed results?
~'to check, if b-column values can find from a-column'
... after that, the next step could be to understand it.

 

[tomas]

I can only see module with my recorded makro..........

 

[vletm]

tomas
I also show that Your macro ... and I didn't use it as I wrote.

There is one more macro in 'Sheet1'.
Did You test as I tried to ask that file? to verify do it work?

 

[tomas]

thanks this will work out for me