- #1

- 612

- 13

You should upgrade or use an alternative browser.

- Thread starter Adel Makram
- Start date

- #1

- 612

- 13

- #2

- 17,200

- 8,506

Just make the value of C1 be "=A1"

- #3

Mark44

Mentor

- 35,287

- 7,140

It's not clear what you're asking here with regard to this part: "and the entire column under C1 to use it in a new operation provided that C1 and the entire column are always updated when A1 changes?"

@phinds's suggestion is fine for copying the value in A1 to C1. Can you be more clear about what is supposed to go in cells C2, C3, and so on?

- #4

- 612

- 13

For example, suppose there is a function F(x) which yields a number on C1. I need to copy this number over the entire column under C1, namely C2, C3,,, etc without repeated typing (=C1) over and over for each cell under C. Is there a way to do that in one shot? Dragging the small box in C1 over the entire column may or may not get the same value as this depends on the way the excel sheet is formed and also this would be time consuming if I have many columns to copy. So I need to update the entire column immediately once the new value of C1 is updated.It's not clear what you're asking here with regard to this part: "and the entire column under C1 to use it in a new operation provided that C1 and the entire column are always updated when A1 changes?"

@phinds's suggestion is fine for copying the value in A1 to C1. Can you be more clear about what is supposed to go in cells C2, C3, and so on?

- #5

Mark44

Mentor

- 35,287

- 7,140

In cell C1 put this formula: =$A$1suppose there is a function F(x) which yields a number onA1. I need to copy this number over the entire column under C1, namely C2, C3,,, etc without repeated typing (=C1)

Now select (highlight) cell C1 and press [CTRL]C (to copy that formula)

Select cells C2 and however many cells you want to copy this formula to.

Press [CTRL]V (to paste the copied formula.

Cells C1, C2, ... should all now display the value that's in cell A1.

If you change the value in A1, the cells that you have copied the formula to should now show the new value in A1.

- #6

- 612

- 13

wow, it works. Thank you. May I ask one more question?Let me rephrase what you wrote slightly, to align with what you said earlier.

In cell C1 put this formula: =$A$1

Now select (highlight) cell C1 and press [CTRL]C (to copy that formula)

Select cells C2 and however many cells you want to copy this formula to.

Press [CTRL]V (to paste the copied formula.

Cells C1, C2, ... should all now display the value that's in cell A1.

If you change the value in A1, the cells that you have copied the formula to should now show the new value in A1.

- #7

- 612

- 13

- #8

Mark44

Mentor

- 35,287

- 7,140

The only way I can think that you can get the values in the column sorted is to write a VB macro to do it. That's a lot more complicated than what you wanted to do before. Maybe someone else will have some ideas.

- #9

- 17,200

- 8,506

I was thinking the same thing. Even w/ a VB macro you have to have some facility to cause the macro to run if any of the cells change. That's probably doable given how sophisticated the Excel object model is but I don't know the method. This assume of course that you don't want to have to click a control to make the change.The only way I can think that you can get the values in the column sorted is to write a VB macro to do it. That's a lot more complicated than what you wanted to do before. Maybe someone else will have some ideas.

Share:

- Replies
- 13

- Views
- 7K