Hello,

I have an interesting situation, would like some input.

I have a set of values on a sheet which have one similarity which is the acct#
now i want excel to copy that data to an appropriate tab which is numbered
with that specific acct#, i want it to copy all the activity that is in the
same format as the tab is.

So instead of me copying and pasting is there a simpler way of acoomplishing
this task.

Somehow I believe by using an array in a loop to test back and forth untill
it copies all the values.

Here is the data

A1: ACCT# B1: INV# C1: TOTAL $
A2: 333 B2: 551 C2: 33
A3: 333 B3: 552 C3: 55
A4: 642 B4: 553 C4: 136
A5: 642 B5: 554 C5: 352

Everything is already sorted by acct #, so i am just copying and pasting the
section onto a seperate sheet, there is just so many accts and especially
some of them only have one transaction.

So what i need the fomula to do is maybe get the INV# of this sheet and fill
it down and then maybe use a vlookup to get the rest of the information.

Thanks in advance.

Dan