Hi,

Yes, have one tab with all the data for the 2 way split. Have another where
we have data for 3 way slit. So we will have 2 output ranges, one for 2 ay
splits and another for 3 way splits.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Cheekyaardvark" wrote in message
...
So if I break out the files into seperate tabs where the % splits are
static then we can get a solution...
I.E. One tab where the for 2 splits, one for 3 way etc