ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   transferring cells.. (https://www.excelbanter.com/excel-discussion-misc-queries/153156-transferring-cells.html)

marketing123

transferring cells..
 
Below is the correspondence from my intial question.

I do not have any information in the B4 on my "master" worksheet, but I do
not want it to show up as a zero on my second sheet.

Any suggestions?


Your formula looks fine. What is the value in B4 on the "master" worksheet?
Also, check the cell formatting where your formula is.

Regards,
Paul

--

"marketing123" wrote in message
...
I am trying to link cells from a master page to individual pages, however
whenever I do this, the number 0 shows up on the individual page. Here is
an
example of the code I tried:

=master!B4

Any suggestions or help would be appreciated!
--
marketing123


--
marketing123

Gary''s Student

transferring cells..
 
=IF(master!B4="","",master!B4)
--
Gary''s Student - gsnu200735


"marketing123" wrote:

Below is the correspondence from my intial question.

I do not have any information in the B4 on my "master" worksheet, but I do
not want it to show up as a zero on my second sheet.

Any suggestions?


Your formula looks fine. What is the value in B4 on the "master" worksheet?
Also, check the cell formatting where your formula is.

Regards,
Paul

--

"marketing123" wrote in message
...
I am trying to link cells from a master page to individual pages, however
whenever I do this, the number 0 shows up on the individual page. Here is
an
example of the code I tried:

=master!B4

Any suggestions or help would be appreciated!
--
marketing123


--
marketing123


PCLIVE

transferring cells..
 
See Max's response to your original post.

--

"marketing123" wrote in message
...
Below is the correspondence from my intial question.

I do not have any information in the B4 on my "master" worksheet, but I do
not want it to show up as a zero on my second sheet.

Any suggestions?


Your formula looks fine. What is the value in B4 on the "master"
worksheet?
Also, check the cell formatting where your formula is.

Regards,
Paul

--

"marketing123" wrote in message
...
I am trying to link cells from a master page to individual pages, however
whenever I do this, the number 0 shows up on the individual page. Here is
an
example of the code I tried:

=master!B4

Any suggestions or help would be appreciated!
--
marketing123


--
marketing123





All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com