Macro will only work in the file where I created it

[LouiseZ]

Hi,

I have created a macro (my first ever), and it works nicely in the workbook where it was created. However, I get the same kind of data several times a week and that data is imported into a new workbook, and I'd like to use the macro I created to calculate some things in the new workbooks. Whenever I try, it says "Runtime error 9" and when I define this it says "Identifier under cursor is not recognized". I have watched several tutorial videos etc. but I just can't figure out what the problem is...
Can someone please help? Below is a snapshot of a part of the code, I assume the yellow part is where the problem is, but I don't know where the problem lies. I don't want the macro tied to a particular workbook because then I'd have to make a new one for each workbook, and that removes the whole idea of it - so I understand that there must be a solution to this?

Very grateful for any help!

 

[LouiseZ]

Can you perhaps edit two dataset files in Notepad, replacing sensitive information with nonsense and deleting all but -say- five rows of data? Please upload that to somewhere and share a link here and also show how you want the end result to look like.

https://liuonline-my.sharepoint.com...dEhjcTLnFrUesBzOJG6Qtl-mM60E1mLqxXPw?e=jdCp0Y (how I want it to look)
"Original" file.

Error

liuonline-my.sharepoint.com

What I am trying to accomplish is to divide analysis with isotype, to get the ratio between the two. However, I want this to be for each gate, so for example I want the gate (flow cytometry talk) CD163 by itself and I want all the analysis that has the gate CD163 divided by all the isotype for CD163. Then I want this for my 5 different gates, and I would love to have the result put into a new sheet next to the "original" sheet. The data points that I want to look at is under the column called X-Med, the rest doesn't matter in this case. So I want all the X-Med data from the analysis divided by isotype, sorted by gate. Does that make sense?

I hope you can access. I saw that the data look distorted in Notepad but once I copied it back into Excel to check, it looked okay again.

Your help is much appreciated!