Summarise multiple sheets with checkboxes

**Kazstankgardner** · 06-13-2012, 01:21 AM

Hi All,

I need to put together a vba code, which is way too advanced for my limited vba experience.

Basically.....I have an excel workbook with multiple worksheets in it. The majority of the worksheets are the same and include a variety of checkboxes and dropdowns(form controls). (The sheets were set up this way to ensure ease of use for the end user). I need to summarise all of the active sheets, into one easy to read summary sheet.

I have attached an example of the workbook for your information. Please help......

Thanks

**arlu1201** · 06-13-2012, 06:33 AM

Can you also attach a worksheet showing how you want the output to be shown?

**Kazstankgardner** · 06-13-2012, 08:02 AM

Thanks Arlette,

Apologies, I did not include the following in my original post... If true, then populate with text. (this would be specific text for each checkbox & the drop downs represent times) I would like the summary sheet to be populated in the form of an organizational chart.

I hope the clarifies, please let me know if u require additional information.

Thanks

Kazsta

**arlu1201** · 06-13-2012, 08:19 AM

It will be good if you attach a sample output file.

**Kazstankgardner** · 06-13-2012, 04:25 PM

Please see the attached file.

Thanks again

**Kazstankgardner** · 06-17-2012, 08:19 PM

Hi All,

I have been giving this some further thought and playing around with excel of the past few days. Given the volume and amount of variables to be summarised, I have decided to use option buttons to unhide the rows which contain data based on an IF statement. If anyone is able to help me, that would be greatly appreciated.

Thanks.

Kazsta