R
Rominall
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?
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?