I have a spreadsheet which is going to have 30+ sheets, of which the top
20(ish)rows are going to contain identical data (milestones dates and
description). I am looking for an automated was to have the same data on each
sheet, rather than have to change each sheet when a date changes, or do the
laborious copy and paste to each sheet.

I wanted to use a formula in a range say A1:M20, and in each cell put
A1=Sheet1!A1, A2=Sheet1!A2
and so on. However this picks up blank cells and displays "0". I have to
pick up the blank cells as at a later date they may contain data. Is there
something I can put in the formula to ensure blank cells are not copied. I
can't use macros as the system doesn't like them and am also trying to avoid
using
A1=IF(Sheet1!A1="","",Sheet1!A1)
as this seems to put data in the cell therefore not allowing the formating I
require.
Any ideas greatly appreciated.
Cheer Laura

Don't quite understand the last bit - if the quotes are next to each other
there shouldn't be anything going into the cell.

Have you seen Tools, Options, View, Zero Values? The only problem is real
zeros also show as blank.

"LauraC" wrote:

I have a spreadsheet which is going to have 30+ sheets, of which the top
20(ish)rows are going to contain identical data (milestones dates and
description). I am looking for an automated was to have the same data on each
sheet, rather than have to change each sheet when a date changes, or do the
laborious copy and paste to each sheet.

I wanted to use a formula in a range say A1:M20, and in each cell put
A1=Sheet1!A1, A2=Sheet1!A2
and so on. However this picks up blank cells and displays "0". I have to
pick up the blank cells as at a later date they may contain data. Is there
something I can put in the formula to ensure blank cells are not copied. I
can't use macros as the system doesn't like them and am also trying to avoid
using
A1=IF(Sheet1!A1="","",Sheet1!A1)
as this seems to put data in the cell therefore not allowing the formating I
require.
Any ideas greatly appreciated.
Cheer Laura

I need the cells empty so that if a cell previous has data that is too large
for a cell that it overflows. I think the problem is that by entering a
formula this is essentially filling the cell even if nothing is displayed.

Any thoughts?

"Martin" wrote:

Don't quite understand the last bit - if the quotes are next to each other
there shouldn't be anything going into the cell.

Have you seen Tools, Options, View, Zero Values? The only problem is real
zeros also show as blank.