I have to "duplicate" a section of my spreadsheet to another section. I want
to data to appear in the destination cell(s) only if the source cells
actually contain data. Example:

First Section
Row 1 Date Dept Arrvl
Row 2 10/9/09 KTEB KMDW
Row 3 10/10/09 KMDW KPBI
Row 4 10/8/02 KPBI KTEB
Row 5
Row 6


Second Section
Row 10
Row 11
Row 12
Row 13
Row 14
Row 15
Row 16

So I need a formula to insert into Row 10 - 16 that will duplicate the data
in the correlating cells only if the source contains data in the cell. in
this example Rows 15 & 16 would appear empty since rows 5 & 6 are. I tried
using just "=" and if the date is not in the source, the destination appears
as "1/0/00"

THANKS IN ADVANCE - I really appreciate any help with this - Jennifer

In your second section, you want:

=if(a1="","",a1)

Copy this to the other cells in the section.

Regards,
Fred.

"JB Bates" wrote in message
...
I have to "duplicate" a section of my spreadsheet to another section. I
want
to data to appear in the destination cell(s) only if the source cells
actually contain data. Example:

First Section
Row 1 Date Dept Arrvl
Row 2 10/9/09 KTEB KMDW
Row 3 10/10/09 KMDW KPBI
Row 4 10/8/02 KPBI KTEB
Row 5
Row 6


Second Section
Row 10
Row 11
Row 12
Row 13
Row 14
Row 15
Row 16

So I need a formula to insert into Row 10 - 16 that will duplicate the
data
in the correlating cells only if the source contains data in the cell. in
this example Rows 15 & 16 would appear empty since rows 5 & 6 are. I
tried
using just "=" and if the date is not in the source, the destination
appears
as "1/0/00"

THANKS IN ADVANCE - I really appreciate any help with this - Jennifer

Thanks Fred -- this works for column A -- but the next column are merged
cells - Column C and D and when i try to enter the formula in the merged
cells it only displays the formula. any thoughts?

"Fred Smith" wrote:

In your second section, you want:

=if(a1="","",a1)

Copy this to the other cells in the section.

Regards,
Fred.

"JB Bates" wrote in message
...
I have to "duplicate" a section of my spreadsheet to another section. I
want
to data to appear in the destination cell(s) only if the source cells
actually contain data. Example:

First Section
Row 1 Date Dept Arrvl
Row 2 10/9/09 KTEB KMDW
Row 3 10/10/09 KMDW KPBI
Row 4 10/8/02 KPBI KTEB
Row 5
Row 6


Second Section
Row 10
Row 11
Row 12
Row 13
Row 14
Row 15
Row 16

So I need a formula to insert into Row 10 - 16 that will duplicate the
data
in the correlating cells only if the source contains data in the cell. in
this example Rows 15 & 16 would appear empty since rows 5 & 6 are. I
tried
using just "=" and if the date is not in the source, the destination
appears
as "1/0/00"

THANKS IN ADVANCE - I really appreciate any help with this - Jennifer

Disregard last post - I figured out i had the column set to text and not
general. all is working now - thanks

"Fred Smith" wrote:

In your second section, you want:

=if(a1="","",a1)

Copy this to the other cells in the section.

Regards,
Fred.

"JB Bates" wrote in message
...
I have to "duplicate" a section of my spreadsheet to another section. I
want
to data to appear in the destination cell(s) only if the source cells
actually contain data. Example:

First Section
Row 1 Date Dept Arrvl
Row 2 10/9/09 KTEB KMDW
Row 3 10/10/09 KMDW KPBI
Row 4 10/8/02 KPBI KTEB
Row 5
Row 6


Second Section
Row 10
Row 11
Row 12
Row 13
Row 14
Row 15
Row 16

So I need a formula to insert into Row 10 - 16 that will duplicate the
data
in the correlating cells only if the source contains data in the cell. in
this example Rows 15 & 16 would appear empty since rows 5 & 6 are. I
tried
using just "=" and if the date is not in the source, the destination
appears
as "1/0/00"

THANKS IN ADVANCE - I really appreciate any help with this - Jennifer

Glad to hear it. Thanks for the feedback.

Fred.

"JB Bates" wrote in message
...
Disregard last post - I figured out i had the column set to text and not
general. all is working now - thanks

"Fred Smith" wrote:

In your second section, you want:

=if(a1="","",a1)

Copy this to the other cells in the section.

Regards,
Fred.

"JB Bates" wrote in message
...
I have to "duplicate" a section of my spreadsheet to another section. I
want
to data to appear in the destination cell(s) only if the source cells
actually contain data. Example:

First Section
Row 1 Date Dept Arrvl
Row 2 10/9/09 KTEB KMDW
Row 3 10/10/09 KMDW KPBI
Row 4 10/8/02 KPBI KTEB
Row 5
Row 6


Second Section
Row 10
Row 11
Row 12
Row 13
Row 14
Row 15
Row 16

So I need a formula to insert into Row 10 - 16 that will duplicate the
data
in the correlating cells only if the source contains data in the cell.
in
this example Rows 15 & 16 would appear empty since rows 5 & 6 are. I
tried
using just "=" and if the date is not in the source, the destination
appears
as "1/0/00"

THANKS IN ADVANCE - I really appreciate any help with this - Jennifer