Question about using Excel as a database
I had a bunch of questions typed out, but decided to stop when I got to five paragraphs. I will try to keep it short(ish) and simple. My boss wants a sort of database in Excel (not Access), and I am having issues with some stuff.
I have created a macro-enabled template in Excel (2007 SP3, Win 7 64-bit), and I need it to output to two or more (up to four) worksheets based on some check boxes. Example: John Doe is available to work in the Central Area, and the West Area, so I would check "C" and "W". The output needs to go to the following sheets: "ALL", "Central", and "West". I also need it to output to another sheet, but that is a big hairy one, so I will ask a followup question later/separately.
I also need the template to stay with the rest of the workbook/file/project, as it will be used on at least one other computer. Attached are the two forms:
(The site will not allow me to upload a macro enabled form, so these are just .xlsx files)
Edit: Wrong profile file
|