I was wondering how it is possible to make a value in one cell equal a different value in another cell without using a formula? Thanks!
I was wondering how it is possible to make a value in one cell equal a different value in another cell without using a formula? Thanks!
If you want a cell to automatically contain the value of another cell...without VBA, formulas, or any manual intervention (copy/paste):
The short answer is: No, that can't be done.
If you don't want to use a formula, then it requires VBA. You would use Worksheet_Change to monitor changes in the "another cell" and when it changes, copy the new value to the "one cell".
Why don't you want to use a formula?
Hi and welcome to the forum.
With VBA
Range("A1") = Range("A2")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
For Example, I want the value in cell A1 to automatically produce a different value in cell A2. However I need to do this procedure multiple times. For example if A1=9 I want A2=12, conversely if A1=10I might want A2 to equal 13. How can I do this?
First, no matter how this gets done, you need to describe what value in A1 will produce what value in A2, either by some sort of algorithm, or with a list of possibilities. What is your logic for that?
And why don't you want to use a formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks