Please see attached example.
I want to add some code in to a macro that runs down column W in sheet 2 and where a cell is blank then change the corresponding cell value in Column S Sheet 1 to Yes.
For example, Sheet2 W6 on the attached example has a value so Sheet1 S6 should be yes.
I know I could achieve this with a simple IF formula in sheet 1 but I don't want formula's as I want to be able to over-ride some if need be and wouldn't want to be losing the formulas.
Many Thanks,
Adam.
Last edited by adam2308; 09-01-2011 at 06:21 AM.
Adam,
You've confused me a bit. You have conflicting statements in your post..
and where a cell is blank then change the corresponding cell value in Column S Sheet 1 to Yes.
For example, Sheet2 W6 on the attached example has a value so Sheet1 S6 should be yes.
So if a cell is blank, change the corresponding cell to Yes? But Sheet2 W6 has a value (so it isn't blank) so change corresponding cell to Yes?? When I looked at the workbook, Sheet2!W6 is blank (it does not have a value). So... ?
~tigeravatar
Apologies - I am confusing myself now!!
If the cell in Sheet2 Column W is blank then the corresponding cell in Sheet 1 wants to be "No".
If the cell in Sheet2 Column W is NOT blank then the corresponding cell in Sheet 1 wants to be "Yes".
adam2308,
Detach/open workbook ChangeDVvalue in w1 from w2 - adam2308 - EF790328 - SDG15.xls and run macro ChangeDVvalue.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
I'm sorry Stan but from what I understand on your code, this is not quite what I am looking for.
Correct if I am wrong but it appears to me that your code is using the text in column V but the actual worksheet that I am working on does not have this text. It is merely there to illustrate which cells they refer to in Sheet 1.
Last edited by adam2308; 08-31-2011 at 10:35 AM.
adam2308,
You should have mentioned this....but the actual worksheet that I am working on does not have this text. It is merely there to illustrate which cells they refer to in Sheet 1.
Detach/open workbook ChangeDVvalue in w1 from w2 - adam2308 - EF790328 - SDG15.xls and run macro ChangeDVvalueV2.
Thanks Stan. That does the trick now, sorry for the confusion.
adam2308,
You are very welcome.
Glad I could help.
Thanks for the feedback.
Come back anytime.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks