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

Attached Files

	TEST Substitute Custodian On-Call List TEST.xlsx (25.3 KB, 11 views)
	employee profile test 2.xlsx (56.5 KB, 10 views)