Complete NEWB and openpyxl project

[Netopia]

Gribouillis

Thank you so much for this. I've been banging my head all day just trying to figure out what I'm doing. My lack of experience and formal training is getting to me.

I'll go over this and see if I can understand exactly what it's doing.

I wonder if I'm even heading in the right direction. I think I should be trying to do something like this:

• Assign a variable "header" and have it read the first row as a list
  
• Assign a variable "data" and have it read in all the data from row 2 onward
  
• Somehow divide that list into 4 separate lists (Group1, Group2, Group3, Group4) by only numerical of data[4]
  
• Somehow sort those lists by only alpha of data[4]
  
• Somehow divide those lists into unique lists based on value of data[4]
  
• Create 4 new workbooks, each named for the Group
  
• Add a tab for each unique value in a group to the group's workbook
  
• Add the header to each of the tabs in each workbook
  
• Add the data for each tab/workbook
  

I feel like I'm overthinking and not mentally using the power of loops, but I'm stuck trying to figure out how to go from this general list of tasks to actually doing it.

I've gotten the data into a single list, but then I find that the list only has a length of 1, so no way to do anything with that. :(

I'm not really looking for anyone to write this for me, but want to learn and understand what I'm doing. I am MOST appreciative of pushes in the right direction and examples that might turn the light on in my head.

I'm going to go play with what you posted now. THANK YOU!