Is there an easier way to copy and paste without using macros or vba?

[Ultimate Selector]

Just curious if there is a simple and easy way to copy and paste one line of data from one workbook to another and have it retain it's values and conditional formatting? It simply needs to look exactly like where I copied it from the other workbook. I don't want to have to use vba or macros. Any ideas?

Thanks in advance!
U.S.

 

[Ultimate Selector]

Here is exactly what happens ... First row is actual copy of data.


The second row is after I paste it to another book.

#4
1.8
2.9
2.4
1.8
2.0
1.6
0.9
1.5
1.9
#4

<colgroup><col style="mso-width-source:userset;mso-width-alt:1954;width:42pt" width="56"> </colgroup><tbody>
</tbody>

_____________________________________________

#4

####

####

####

####

####

####

####

####

####

#4

<colgroup><col style="mso-width-source:userset;mso-width-alt:1954;width:42pt" width="56"> </colgroup><tbody>
</tbody>

 

[Ultimate Selector]

Is it because all of my calculations to get the answers for those cells in the pasted post are in the first book?

 

[My Aswer Is This]

So you want the formulas in the second workbook to keep referring to the first workbook?

We would need to see some of those formulas.

 

[Ultimate Selector]

So do I need to have the formula when I paste it? Cuz when I special paste it I check the box to have all formulas and whatnot copied with it as well.

Why doesn't it just paste the data that is in the cells? I don't understand why it won't.

 

[My Aswer Is This]

If you copy the row and then say paste formulas and then you look in that cell on the Formula Bar you will see the formula is still there.

But the results will be different depending on the formula