Hi again Dan,

I will also need to use this feature with lots of data. I also need
run a cumulative totals. there lay several problems.<

As you say 'there lay several problems'. The short answer is YES! what
you are trying is very achievable, and it probably doesn't involve
very complicated formulae, just some clear thinking.

You say you are trying to 'shift' data from one sheet to another.
Don't think of it that way, think more along the lines of the end
result as in what does that new sheet need to get the result you want.

Post again with more detail of your desired results and I'm sure
someone will come up with what you need.

HTH
Martin