copying text on sheet 1 to corresponding cells on sheets 2 to 5

[Lisa]

I want the text entered in A8 on sheet 1(named Productivity) to automatically
transfer to A8 on sheets 2 thru 5. I used the simple formula
=Productivity!a8 in the corresponding cells but when there is no data in
Productivity A8 I get a 0 in the corresponding cells. I would like the
corresponding cells to remain blank if there is not text in Productivity A8.
I am really new to excel, like only used it two weeks! Is there a simple fix
to this?

 

[Per Jessen]

Hi

A formula will always return 0 if it's refering to an empty cell. This
formula will let the cell look empty if no value is entered in A8 in sheet1

=if(Productivity!a8="";"";Productivity!A8)

Regards,
Per

 

[Gord Dibben]

=IF(Productivity!A8="","",Productivity!A8)


Gord Dibben MS Excel MVP

 

[Lisa]

I copied the formula exactly as you have typed it and am being told it is
invalid, any explanation as to why?

 

[Max]

I copied the formula exactly as you have typed it and am being told it is

invalid, any explanation as to why?

The semicolons in Per's formula need to be changed to commas. It's a
settings sort of thing where semicolons are used as separators (in Per's
version) instead of commas. See Gord's suggestion.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:58
xdemechanik
---

 

[ShaneDevenshire]

Hi Lisa,

Typing can get you into trouble:

1. Select cell A2 on sheet2
2. Hold down the Shift key and click sheet5 tab (if they are adjacent, if
not click each sheet tab while holding down the Ctrl key) You are in Group
mode and whatever you do to one sheet of the selection is done to all.
3. Type =
4. Click on the Productivity sheet tab and then on cell A8.
5. Press Enter.
6. You should deactivate Group mode - either right click the tab of any
selected sheet and choose Ungroup or click on a non-selected sheet
(Productivity)