|Well, that didn't clear up anything for me.|
re: "i have sales transactions that i want to split between for the time it happend"
I don't know if we have a language issue here, but the grammar in that statement makes no sense.
As I said in my previous response, please read the How To referenced in my signature line then post some examples of your data with Column letters and Row numbers.
Once you have shown us what you data looks like, give us an example of what the desired results should be - using the data, not just words.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.