COpy & paste a cell with formula

Closed
Report
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
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 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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