Evgeniygor
01-16-2009, 09:34 AM
Hi Everyone,
I desparately need your help.
I need to write a simple loop, but I am too new to VBA to do this properly.
Excuse me for such a simple question, but this place seems like the only one, where I can get some help.
the thing I need to do is:
I have several columns
A contains data already.
B has comments about this data.
C is used to input data by me.
What I need to do is that every time I isert some data in C, if it's already in A I need to have comments about this data in D.
Basically I need to check if the value in the cell having been changed is the same as in some data that already exists.
Please help. My loops are not working.
In reality my task is a little more complicated, but If you advice me the simple way of solving, I guess I will get how to apply that to the thing I really need to do.
The only thing I know is that I need to input the code into Sheet1, not into a module. I tried doing DO...LOOP, but I failed. It either doesn't work, or it runs an endless loop, which is bad.
I desparately need your help.
I need to write a simple loop, but I am too new to VBA to do this properly.
Excuse me for such a simple question, but this place seems like the only one, where I can get some help.
the thing I need to do is:
I have several columns
A contains data already.
B has comments about this data.
C is used to input data by me.
What I need to do is that every time I isert some data in C, if it's already in A I need to have comments about this data in D.
Basically I need to check if the value in the cell having been changed is the same as in some data that already exists.
Please help. My loops are not working.
In reality my task is a little more complicated, but If you advice me the simple way of solving, I guess I will get how to apply that to the thing I really need to do.
The only thing I know is that I need to input the code into Sheet1, not into a module. I tried doing DO...LOOP, but I failed. It either doesn't work, or it runs an endless loop, which is bad.