automatically change all cell values based on updated entry
I need help:
How to do this:
If I change any value on column C, then it will automatically change all cell value on column C with the updated value based on same criteria on column B
like I have column b12 value as Test a then I change the value on c12 from 20 to 23, how to make automatic change on all value on c which have same criteria with b12 to the updated value (23)??
please help
Thank you
Right click the sheet tab and select vie code and copy and paste the below code
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Re: automatically change all cell values based on updated entry
thank you so much Mr. Sixthsense, it works like a charm. one more thing, how to make it works for all sheets at once??
Thank you again, you're the man.
Last edited by ruliansyah; 01-31-2013 at 10:42 PM.
Glad it helps you and thanks for the feedback
Just a first line has been changed in the below code, DELETE the previous code from the sheet event code. The below code should be pasted in THISWORKBOOK code window. Refer the below to know how to add the code in THISWORKBOOK CODE window.
To add code in ThisWorkbook Code Window
- Copy the below code
- Select the workbook in which you want to store the code
- Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
- In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
- Right-click on the ThisWorkbook object, and choose View Code
- Where the cursor is flashing, choose Edit | Paste
Please Login or Register to view this content.
Last edited by :) Sixthsense :); 01-31-2013 at 11:57 PM.
Ok mr. sixthsense, in that case it will run i change worksheet right?? what if it run automatically without having to change worksheet??
Not sure what you are trying to say by way of the above sentenceOriginally Posted by ruliansyah
I'm sorry for my bad english, I just tried the last code you gave, it doesn't run...
Oops.. Mis-understood
Replace the previous code of THISWORKBOOK code with the below one
Please Login or Register to view this content.
Works Great, you're the man, you save methank you so so so much for your help.
another question,
Still the same topic but to change the value on column B itself, let say I have some B cell with the value "Test A" then if I change the value in any cell from "Test A" to "Test A1" it would change all "Test A" value on entire B column into "Test A1" and so within another sheet. I believe it use oldvalue method but I don't know how it works.
Last edited by ruliansyah; 02-01-2013 at 04:00 AM.
Glad it works and thanks for the feedback
another question,
Still the same topic but to change the value on column B itself, let say I have some B cell with the value "Test A" then if I change the value in any cell from "Test A" to "Test A1" it would change all "Test A" value on entire B column into "Test A1" and so within another sheet. I believe it use oldvalue method but I don't know how it works.
Replace the previous code of THISWORKBOOK code with the below one
Please Login or Register to view this content.
Re: automatically change all cell values based on updated entry
That is very very very great things ever, It really works... you are the man mr. Sixthsense
thank you again for your help
You're welcome
For sharing this is the workbook with the code given by mr. Sixthsense
as a note: the column b and c cannot use formula, it will replace the value with formula result instead
Thanks for sharing the file
Replace the Selection Change event Code with the below one to make the code to keep the previous cell value based on Column-B alone
Please Login or Register to view this content.
Thanks for the update mr. Sixthsense but still if I input value "TOTAL dari Pro1" on cell b11 and I use formula "=sum(c5:c10)" on c11 then when I hit enter, the value on c11 will show result of the formula only and the formula itself is gone, but never mind, I will use the d column for the formula.
Sorry I missed to read the FORMULA Issue, Replace the previous code with the below Revised Code
Please Login or Register to view this content.
mr. Sixthsense, tried the update but still don't work with formula
I believe this will be the Final Code, Replace the previous code with the below:-
Please Login or Register to view this content.
Re: automatically change all cell values based on updated entry
WOW That is a very perfect mr. Sixthsense... Thank you so much...
Glad it fulfilled your requirement completely
Once again thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks