LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default Duplicating Cell to another cell if it contains data

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for Duplicating info from one cell to another Timbo Excel Discussion (Misc queries) 9 April 14th 08 05:23 PM
Formula for duplicating info from one cell to another Timbo New Users to Excel 5 April 11th 08 09:00 PM
How do I stop worksheets from duplicating cell in a different wor. S. Stoia Excel Discussion (Misc queries) 2 March 7th 06 05:10 PM
Duplicating cell value between worksheets Dennis Excel Worksheet Functions 6 January 12th 06 03:42 AM
Duplicating Cell Information [email protected] Excel Worksheet Functions 1 March 10th 05 12:47 PM


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"