Need help for checkbox based calculation

[hnd]

Hi,

I am new to VBA. Want to have a template as explained below. Help required.

I have a group and sub-group of data in one sheet. Based on my checkbox selection in second sheet, group and sub-group of data should be displayed in third sheet or in first sheet. Then with that, whatever values these has against it I need that as default values in a summary table. Fourth sheet is with some more values added. A button in one of the sheet third or fourth. When i click, i need details in fifth sheet. This should contain third sheet and fourth sheet summary and also multiply of third and fourth sheet values. Slightly complicated, please help.

Attached is the sheet.

Thanks & Regards,
hnd

 

[Luke M]

Rather than trying to control everything through checkboxes, keeping track of groups and subgroups, I think things will be much easier if we utilize the Data - Group function within XL. Check out the attached. I've grouped your data on Sheet1, and now with a few clicks on the +/- outline buttons, you can see various groups, and the SUBTOTAL function lets you naturally work with only the visible data. Let us know what you think.

 

[hnd]

Hello Luke,
Thanks for the reply. But there are no attachment in your reply.
Could you please attach the file.

Regards,
hnd

 

[Luke M]

Yikes! My apologies. That's what I get for having too many window tabs open...

 

[hnd]

Thanks Luke. It worked well for me.
Appreciate your help.

Regards,
hnd