If you want duplicate entries copied from one cell into another just make the formula for the receiving cell say that.
I have to do invoices with PO#'s, and the way I do it i put these long text/ number po numbers in several cells. (this way they appear at the top and near the address so they are on the packing labels too)
while i can use formulas to automatically update numeric cell contents when i change other cells, is there a way to make a text in a cell mirror automatically the text of another cell? in other words, if i type in COM78654 in cell 1a, is there a way to format cell 2b to make it update and have that same info in it? rather than just copying/ pasting all the time? thanks --fj