Need design advice.
I develop many Access programs, but some units will not use Access (don't
get me going on their ability and mindset) . They insist on making a simple
excel ss once each year with monthly/annual totals, then use a new file for
each FY. I'm trying to table all the data for use in access, since I use
access to show various data summaries from many units.
I don't mind so much writing code to get the info and append it to access
tables so I can keep several years worth of data in one table, except some
units use a FY cycle, others use a CY cycle, and some even use a month cycle,
which makes it near impossible to keep up with the importing and consistency
of data from these changing file names. If I could build a table in Excel
that would take their entries and append it to a table so I can easily import
it from a single file instead of dealing with EOY file changes and relinking,
that would be great.
So I need to design a basic worksheet so it won't scare those that enter
data and so they can view their info in basic rows with monthly summaries,
yet append the data (in another worksheet?) to a table to link and analyze it
over a period of years.
So Im looking for ideas for managing this...