Super Hard Problem.......i think

austin350s10

Active Member
Joined
Jul 30, 2010
Messages
321
This is kinda complicated and im not sure if it's an excel or VBA question but here goes!

I work at a home care company and we are redoing out client care plan form which is composed of many check boxes for tasks the caregiver needs to do in the home.

PROBLEM: I am trying to create a report that summarizes the tasks the user checked off on a separate sheet in the same workbook. I was thinking each task listed one after another in one column that auto expands based on the amount of tasks being checked.

QUESTION:Is this even possible?
 
Last edited by a moderator:

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
21,283
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
Hi
Yes, it certainly sounds feasible.
I'd suggest maybe putting your parent tasks in one column and your sub tasks in an adjacent column
They could then be sorted by the parent column to insert into the report.
It's obviously going to be more complex than that, but it might give you something to think about
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

It'd help if you posted an example of what you have now and what you want as an end result. If you PM me your e-mail address I'll send you a copy of the board's HTML maker, which will let you post a shot of your sheet.
 

austin350s10

Active Member
Joined
Jul 30, 2010
Messages
321
Thank you for that but I think I may have a solution. The answer is a pivot table the only confusing part is getting the check box text values into the pivot table.

I had to send the check box text values to a separate hidden sheet and use that as a reference to the pivot table.

The hidden sheet would look something like this:
A1 = task 3
A2 = ""
A3 = task 1
A4 = ""
A5 = task 2

As soon as I tell the pivot table to not show (blank) values and sort A-Z
I get exactly what im looking for.

Pivot table gives me:
A1 = task 1
A2 = task 2
A3 = task 3

Im sure there is a way to do this via VBA but I have no idea how to do that. If you think this problem could be solved with a bit of VBA code I would love to hear more. Let me know and I can provide further examples...

Thanks,

-Austin-
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,422
Messages
5,837,147
Members
430,478
Latest member
masoodb1358

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top