How to copy a result in formula cell into another cell

[Kerry M]

Hi,
I enter text onto M8 -
I then use this formula to decide what to show in Q8

- =IF(ISNUMBER(SEARCH("B",M8)),"Exceeding 3 hours",IF(ISNUMBER(SEARCH("C",M8)),"Disabled zone / No permit",IF(ISNUMBER(SEARCH("D",M8)),"No Parking Zone","")))

That works fine
What I need to do is,
copy the result -eg. "No Parking Zone" into a holding cell , S2 , I have a macro that uses S2 to print template
(the reason I need a "holding" cellis , I would then like to go to the next row and do it again etc. )
It has to be a formula because i need it to update for each row.

i have tried =if,M8<>"",S2=Q8,"") - but, i get "False" and S2 is left blank

Sorry for the long winded explanation
Hope it makes sense

Cheers

 

[arthurbr]

Perhaps in S2 =if(M8<>"",Q8,"")

 

[Kerry M]

Perhaps in S2 =if(M8<>"",Q8,"")

thanks for that but, i need it to flow onto next rows - eg. if(M9 , if M10 etc

 

[Kerry M]

ok, found a work around - lots of work but, it works
I changed M8 to $M$8 - etc , for all 304 rows - to allow copy/paste to relevant "holding cell"
I made "a print" macro button on each row -
I then had to make a macro - for every row - A_1 A_2 etc
I then used macro button for every row - not a good look but works
macro now copies Q (row number using $ ) to holding cell that is sent to print template
it works ok
just wish, there was an easier way

Any better ideas ?