Duplicating Cell to another cell if it contains data


J

JB Bates

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
 
Ad

Advertisements

F

Fred Smith

In your second section, you want:

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

Copy this to the other cells in the section.

Regards,
Fred.
 
J

JB Bates

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?
 
J

JB Bates

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

Advertisements

F

Fred Smith

Glad to hear it. Thanks for the feedback.

Fred.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top