EMT537-538 Help with dynamic data into multiple sheets

kellkay28

New Member
Joined
Sep 10, 2018
Messages
1
I am an Autism Specialist for a local school district and we have developed a spreadsheet to help us graphically represent data from behavior assessments to parents. It also helps us determine "why" students do what they do. Previously, we represented this data as "1 behavior" but realized that this does not accurately represent all behaviors observed. We limit our behavior assessments to 3 behaviors, the idea is to filter the data into 3 separate sheets for behavior 1, 2, and 3. I tried using a table/query to filter the data, but each time we rename the file for a new student, the query does not work and it is no longer dynamic. When I found your video on 537-538, it is perfect...but I keep getting errors. I haven't built the graphs in this sheet, yet- simply because I cannot get it to work. I tried taking your spreadsheet and customizing it, but, this is just more advanced than my current level of knowledge in excel. I have drop down boxes for the data entry in almost each box for Time, Duration, Location, Antecedent, Consequence, Severity, Student Reaction- I need it to filter the information for behavior 1, 2, and 3. I don't know where I am going wrong and it won't let me save the darn thing with an error in the formula. At this point, I'm willing to pay for this to work correctly- I've probably spent 30 hours, at least, trying to get this to work for our team.

I don't see where to provide an attachment, I don't even know where to begin describing my error. Any help is appreciated.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Hi. One thing to remember when you post a question is we cannot see your spreadsheet. It can only be a guess what you are after.
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,325
Members
452,635
Latest member
laura12345

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
Back
Top