Adding Formula to Cell with Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GatorGirl - 19 Mar 2008 22:04 GMT

Column A has hard coded data. I need to add to the hard coded data figure
another cell. I do not want to insert a new column or change the format of
my worksheet. How can this be done without manually adjusting each cell?

Reply to this Message

Bob I - 19 Mar 2008 22:09 GMT

=datanumber+CellAddress
as in
=123+B2

> Column A has hard coded data. I need to add to the hard coded data figure
> another cell. I do not want to insert a new column or change the format of
> my worksheet. How can this be done without manually adjusting each cell?

Reply to this Message

Gord Dibben - 19 Mar 2008 22:43 GMT

What type of data in the cells?

If numbers and you want to add 10 to each, enter 10 in an empty cell.

Copy then select the range to change and Edit>Paste Special>Add>OK>Esc.

If something else and you don't want a helper column and you don't want to
adjust each cell then a macro would seem to be in order.

More details and we could tailor something.

Gord Dibben MS Excel MVP

>Column A has hard coded data. I need to add to the hard coded data figure
>another cell. I do not want to insert a new column or change the format of
>my worksheet. How can this be done without manually adjusting each cell?

Reply to this Message

Rate this thread: