COpy & paste a cell with formula

Closed
jem - Oct 11, 2010 at 01:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 14, 2010 at 09:28 AM
Hello,

Please help me out on this. I have a problem to copy & paste in excel.
What i want is to copy the result of formula in Column "A1" then stops when no formula exists.
I got 10,000 rows to do this over & over agin.

Appreciate anyone helps on this.

many thanks,

james

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 14, 2010 at 09:28 AM
Hi James,

It is not clear what you are aiming for.

If you want to copy the result of a formula in another cell use =A1 in the target cell, with A1 being the cell containing the formula.

Note: A1 refers to a cell and not to a column.

Could you show a piece of your worksheet for better understanding of your query?
Or post your entire workbook using a site like www.Speedyshare.com.

Bestr egards,
Trowa
0