Hi
I have a list of current sheet names, could differ fro day to day (as a Macro creates sheets and updates the list:
e.g.
A B
1 | 12345 |
2 | 23456 |
3 | 34567 |
Now on the B column I want to add the formula to say if A1 = one of the sheet name then on that sheet count how many entries are on I:I.
on each sheet C1 equals the sheet name ( the macro that creates the sheets gets it from there).
this I the formula I tried:
And it always comes back as not working.
anyone know any other way to fix this.
Thank you
I have a list of current sheet names, could differ fro day to day (as a Macro creates sheets and updates the list:
e.g.
A B
1 | 12345 |
2 | 23456 |
3 | 34567 |
Now on the B column I want to add the formula to say if A1 = one of the sheet name then on that sheet count how many entries are on I:I.
on each sheet C1 equals the sheet name ( the macro that creates the sheets gets it from there).
this I the formula I tried:
Code:
=if(A2&"!C1"=A2,CountA(A2&"!I:I),"Not working")
And it always comes back as not working.
anyone know any other way to fix this.
Thank you