Macro Language
 

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...

Macro Language
 

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...

Macro Language
 

I'm not familiar with pivot tables. But with queries from Access to Excel,
couldn't I use macros.

"Jim Thomlinson" wrote:

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...

Macro Language
 

Absolutely you can use macros. My only comment was to store the raw data in
the database side and present it in the excel side (Access backend with an
Excel front end). The queries will just need refreshing in the excel side and
all of the work of which accounts belong to which sales reps can be very
easily handled from the Access side. If you are not familiar with Pivot
tables you should give them a try especally if you are familliar with Access.
This is a very powerful combination for presenting and analyzing data. It is
very effective at getting you around the 65,536 row limit of Excel (my
biggest Excel Pivot Table was linked to over 900,000 records on the Access
side).
--
HTH...

Jim Thomlinson


"T.A. Oliver" wrote:

I'm not familiar with pivot tables. But with queries from Access to Excel,
couldn't I use macros.

"Jim Thomlinson" wrote:

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...