This can be done through VBA macro code but it could get messy. In your post
you allude a database of accounts. If you are familiar with databases this
would be my prefered method of dealing with something like this only because
it is more flexible than VBA Code is. Excel can still hook up to your
database (Access) and retrieve all of the info that you need either through
queries or pivot tables. Just my two cents...
--
HTH...

Jim Thomlinson


"T.A. Oliver" wrote:

I don't know if I used the best subject, but I will try to explain. I have
experience in creating macros in visual basic, but for the project I'm
working on, I'm not sure if macros are the best tool. I am trying to update
a database of accounts. When I update the main list of accounts, I want the
changes to reflect on the sales rep's sheet and if an account was switched,
it would then be deleted from the other sales rep's sheet. I am so confused.
Need help...