Okay, don't know if this is possible. Don't know how much of this you'll need
but I'm trying to make this the short story.

I have a text file that I currently copy into a master workbook. I have if
statements to compare 4 identifiers (col. a-d). If all 4 match then it
copies the new stuff into the remaining weeks. The users would like to
combine some stuff and only show a sub-total for one of the identifiers. Can
I total these up during the copy process?

SAMPLE RAW DATA
Jon Doe.....A1....B1....C1....Wk1...Wk2...etc
Jon Doe.....A1....B1....C2....Wk1...Wk2...etc
Jon Doe.....A1....B1....C3....Wk1...Wk2...etc
Jon Doe.....A1....B1....C4....Wk1...Wk2...etc
Jon Doe.....A1....B2....C1....Wk1...Wk2...etc
Jon Doe.....A1....B2....C2....Wk1...Wk2...etc

Now I only need the sub-total for all B1s, I still need the details for B2s.

EXAMPLE CLEANED DATA
Jon Doe.....A1....B1....C....SumWk1...SumWk2...etc
Jon Doe.....A1....B2....C1....Wk1...Wk2...etc.
Jon Doe.....A1....B2....C2....Wk1...Wk2...etc.

Someone suggested using an array but I'm not very familiar with them.

Am I stuck copying to the master and then doing a sub-total?