|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I have a spreadsheet which allows a user to determine their budgets for a
given year. I want these to be written to a database.
The problem I have is as follows
Take a spreadsheet with the following columns
Account Number Description/Name BudgetPeriod1 BudgetPeriod2...BudgetPeriodn
I want the user to be able to click on an entry and for the application to
do various things depending on what they click on
for example if they click on an account number or description to provide
options to retrieve child accounts (or siblings). If on a budget I want it to
create a new sheet zoom on that period or create a sheet with the
transactions on.
To really make it complex I'd rather their was a little as possible of this
magic visible to the user. In otherwords hopefully without using the cell
comments and/or the naming of a range. Remebering of course that users can do
things like rename sheets/workbooks, delete rows,columns whatever
Now for all of these to work I need to store extra information about each
cell with data in it so I can consult this information later when extracting
the required information.
What I'm wondering is there a way of doing this. I'm wondering if XMLMaps
would do it and if so how they work.
|
|
|