# How to copy a result in formula cell into another cell

#### Kerry M

##### New Member
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

Last edited:

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

#### arthurbr

##### Well-known Member
Perhaps in S2 =if(M8<>"",Q8,"")

#### Kerry M

##### New Member
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

##### New Member
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 ?

Last edited:

Replies
4
Views
798
Replies
1
Views
1K
Replies
15
Views
1K
Replies
3
Views
635
Replies
1
Views
1K

1,191,120
Messages
5,984,760
Members
439,909
Latest member
daigoku

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back