VBA to find a number in column "A"

[buwa84]

hey folks,

I have excel spreadsheet where column A has account numbers. I want to write a VBA code to find the account number specified in cell C1 and
if found within columb A to write " Co" in corresponding column "B" cell

If not found to add the account number to the end of the list

and clear column C1

Thanks a million

[skywriter]

Here you go.

Please Login or Register  to view this content.

[buwa84]

Hey thanks a million

Here you go.

Please Login or Register  to view this content.

[skywriter]

My pleasure.

If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.

If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.

[YasserKhalil]

Try this code

Please Login or Register  to view this content.