SplitRow | A row for Eureka to put two rows side by side | Grid library

I'm currently trying to work on a macro that will look for grades and count assignments done. It works...for the most part...But I'm having some trouble with it being very static. I've hardcoded a specific range, but I need it to be dynamic, in case more/less columns are in the spreadsheet or if columns not related to grades are added at the end (such as Finalized). My coworker may need Math/History/Science Grade 4 or 5 or 6. You get the idea.

Before macro is run:

After macro is run:

Hello I am new on flutter, I am work in a widget named split row, i use a ListView with three childrens: Text Widget, ListView Builder widget and a Container Widget.

I use the Text for a Tittle, a Map to fill the ListView Builder, and the container to add widgets to ListView Builder, every thing works fine but when i remove an item this item is removed from the map, from the ListView Builder too but not update the values.

To explain myself better I made an example with a textField and a Text, in the first I entered the value of the map key three times and in the second the text is formed with the word data and the map key. This is what happened

As you can see when i delete data1 the item it disappears leaving only data 0, data 2 and data 3, but value 111 it remains and value 333 disappears. obviously values ​​do not correspond to map elements except 000 => data 0

I have already been researching in forums, I have searched stackoverflow, on websites and I have not found anything that helps me

This is the code:

I'm trying to update values of each LabelRow in my SplitRow every time VC appears one the screen (it has to be like that). I've tried using .cellUpdate on both LabelRows but it just crashes. When I use .updateCell on just one of LabelRows, it updates value of that row just fine. Is there a way to update both of them at the same time? I tried to use .updateCell on SplitRow but then I can't update values (they are read-only?). The failing code part:

So I'm trying to set a filter to replace a hyphen with a
to spit it onto a new line. I've created a filter like this:

I have some data like below :

I have this macro that formats my Excel sheet. It changes the color of the top row and adds a filter, freezes pane, etc.

I have a personal workbook I saved it to, so I can use it in any Excel file I open.

It works if I run the macro from the developer tab. If I try running it using a hotkey it does not work.

The only thing that works when I use the hotkey is it will add a filter to the top row.

I'm failing to set the print area for an external, temporary, workbook. I have a main sub which I use to move to the private sub below. In the main sub, I have defined the tempWB properly, however, I can't seem to get it to work in the private sub. I get this error:

It works if I change the workbook to ThisWorkbook, but not for the outside workbook.

I am new using VBA and I've run into something that has been puzzling me: when I run a pivot on the following line of code it takes a really long time for it to finish when in reality it should not take that long. If anyone knows what the problem with it is or if you have some ways to make my code run more efficiently please let me know.

I m using the below code to insert Freeze Panes (working perfectly) but i m wondering if there is a way to import Freezing Panes using sheet Name or Codename avoiding ActiveSheet. Thanks in advance!