I have row with 19 columns and one of these columns contains a formula. I
work with two Excel documents simultaneously and I need to be able to select
an entire row of data from one .xls, copy it, and paste it into a different
Excel .xsl file. When I do this, the pasted row no longer contains my
formula. I am only pasting the formula value on the new file, and not the
formula itself. How do I copy an entire row of data where one column has a
formula, and paste in into a different document while keeping the formula in
tact for that one row?