Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Duplicating info from one cell to another | Excel Discussion (Misc queries) | |||
Formula for duplicating info from one cell to another | New Users to Excel | |||
How do I stop worksheets from duplicating cell in a different wor. | Excel Discussion (Misc queries) | |||
Duplicating cell value between worksheets | Excel Worksheet Functions | |||
Duplicating Cell Information | Excel Worksheet Functions |