You could post a small example of the sheet with say about 20 entries preferabely with the split already made so that I can see where you want it and where you are getting it from
Is the name of the sheet that you use always the same name?
Macros are much better especially because you dont need to copy and paste the formular. I generaly have a sheet that has my macro and I then point the macro to find the sheet with the info and proces it with just one click.

Michal