Microsoft Business. Microsoft Enterprise. Browse All Community Hubs. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Show only Search instead for. Did you mean:. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 3 years, 9 months ago. Active 3 years, 9 months ago. Viewed 3k times. The formula is shown below: ActiveSheet. Range "GG43". Range "VV43". Value" But the code doesn't work and I get a syntax error. Pedro R. Range ""VV43"". Value" , assuming the worksheet name is correct with no typos.
In formulas, you need to double up on quotes. Otherwise VBA thinks you're at the end of the. Even you last question about changing L11 to Complete works just fine. I am able tochange from Overdue to anything else without throwing an error. I'm going to copy all of this code and your column Z formulas back into my original workbook and will let you know if it works.
When you change L11 from Overdue to something else you'll need to blank I11 to prevent L11 changing back to Overdue. I didn't make the change that you mentioned below because I don't mind those numbers being there.
So the cells in column I do turn blank once there is a completion date noted. Thus, it is working as expected, even when I make a change to the status. Don't know if you noticed the one line macro in the sheet module I used to change the formulas. When I entered the formula and dragged it down the colors went goofy so I used the macro to change them all in one go. Re: Update cell based on value in another cell Bueller? Re: Update cell based on value in another cell Can you post a sample worksheet that exhibits the issue.
Including the macro. Re: Update cell based on value in another cell First thing you need to understand are how events work. To stop this from happening you need to temporarily disable events in your code by using Code. Re: Update cell based on value in another cell Correct me if I'm mistaken, but isn't it column I the OP's wanting to fire the event? The following linking formula will be updated in destination sheet that will link cell A1 of both sheets.
By entering the linking formula manually, we can update data in cell A1 of Sheet2 based on a condition if the cell value of A1 on Sheet1 is greater than We can do that by entering this logical condition in an IF function.
If cell A1 on Sheet1 meets this condition then IF function returns the value in cell A1 on Sheet2 otherwise it will return blank cell. Here is the formula to link the cells of both sheets based on this condition. Suppose we have a drop-down list in cell A1 of Sheet1 and we can update cell A1 on Sheet2 by entering link formula in cell A1 on Sheet2.
In cell A1 on Sheet2, we will manually enter this linking formula to update data automatically based on the cell value selected from the drop-down list. Linking data in a real data set is more complex and depends on your situation. You might need to use techniques other than those listed above. If you are in a rush and want your problem answered by an Excel expert, try our service. The first question is free. Kindly reply. Thanks for you question!
The experts who write these blogs are also online and available to help. By continuing to use this website, you agree to their use. Connect anytime to free, instant, live Expert help by installing the Chrome extension Add Excelchat to Chrome.
0コメント