Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding rows during copy???
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding rows based on no of rows specified from a given position | Excel Worksheet Functions | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions |