Python and pandas: Aggregate lines form Excel sheet

[Glyxbringer]

Please have a look to see if this starts what you need correctly.

Hey there...

Unfortunately I was not able to troubleshoot the following error:

These are the sheets: TX
What sheet do you want to process? Copy and paste the sheet name ... TX
Traceback (most recent call last):
  File "D:\Python-Pandas\script.py", line 33, in <module>
    if not mylist in type_dict[sourceFile[mysheet].cell(row=rowNum, column=2).value]:
                     ~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
KeyError: None