Hello:
Please refer to attached file.
I need VB code to do following
Will enter number in cell A1.
Once enter is pressed, then look for the same number from cell A10 down.
If it finds it then goto that cell.
If number is not found then add that number to first available cell exculding the row # defined in column I.
Example :
I am entering number 3443 in cell A1. In this case cursor needs to go to cell A11.
Now i am entering 779, in this case it should enter 779 in cell A17.
I hope this is clear.
Please let me know if you have any questions.
Thanks
Riz
Bookmarks