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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,647
Office Version
  1. 365
Platform
  1. Windows
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.
 
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,152,479
Messages
5,770,323
Members
425,612
Latest member
martinijr

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