Splitting up a table

[Dawn]

I have a table containing several groups of information and I would like to
split this table into separate tables in order to then create charts for each
group. I would then like to be able to update the info in the combined table
and click a button to update the other tables and associated charts. Does
anyone have any tips of what the best way to approach this would be?

 

[Dave]

not without a lot more information. sounds like you need someone who knows
how to design a database and the applications that access it. and you can
do all of that without a line of vba, so you may want to talk to someone who
knows how to do reports and forms for whatever database system you are
using. it is also probably not necessary to separate the data, grouping can
be done in reports, filters in forms, or lots of other ways depending on
what needs to be done.