Please see attached example book.
In it I want to change name "G" in column A to "X" in column C.
And I want to do it for month of May in column B.
So a match won't do the trick because Name G is in 3 times so it should match on G and May from columns A and B.
How to catch this in a simple VBA line?
Thanks!
loop through and then
if range("A" & rowNum).value="G" and range("B" & rowNum).value="May" then range("C" & rowNum).value="X" end if
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hmm yeah that could be a fairly simple solution which I did not think of.
But can it not be done via a match or find on the ranges?
I can make the loop but trying to avoid looping thru all lines.
The example has not that many lines but the real workbook could contain a lot of lines in the end.
No, cause you're doing a find and replace, match will just do the find, and you need to match 2 columns, you could have column c hidden and do it with an IF formula.
You could do it with find on column B for May, then column A for G, then do the neccessary, then do the find again from the previous found cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks