Thank you for your reply Garry. My intensions are to be able to
"dump"
in information on a monthly basis into a "Data" tab and I want it to
automatically go to the appropriate companies data tab based on the
account number. I will have a graph going for each account tracking
different information. I know how to make a Dynamic Table and
Dynamic
Graph in order to allow things to update automatically there, but I'm
having troubles identifying a good way to be able to just dump in the
fields on the "Data" tab and have everything else automatically
update.
Let me know if you can help me out! Thanks!

I conclude, then, that these 'account numbers' are actually 'client
accounts' as opposed to 'Chart of Accounts' items. In this case
separate sheets makes sense!

If you do what I suggested for adding the named range (as exampled) to
each sheet then the task will be much easier to code. Optionally, you
could upload your file to a website and post a link to it. Make sure it
has account sheets and a sample of the 'Data' fields you want parsed to
each account sheet. (Use dummy account numbers and data)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion