Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to add data to the bottom of a column using macro
I have data that I am importing from another program (see sample 1 below).
This data will be changing values as well as number of rows each time I export. I need a way to determine the last line as the number of rows varies and then insert static as well as dynamic information. (See sample 2) In the first column I will be inserting "02" on the last row. In the second column i will be inserting the same numbers "150080380549" on the last row. On the 3rd column I need to count the number of rows (excluding the last line)and place this figure. On the 4th column, I will be summing the column and placing this on the last row of the column. 01 155080380549 0000718504 000000003195 01 155080380549 0000718505 000000003195 01 155080380549 0000718506 000000601920 01 155080380549 0000718507 000000177000 01 155080380549 0000718508 000000001456 Desired Result of last line: 01 155080380549 718504 3195 01 155080380549 718505 3195 01 155080380549 718506 601920 01 155080380549 718507 177000 01 155080380549 718508 1456 02 155080380549 6 786766 Thank you, Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
I have ad address in one column. I need to break apart the data | New Users to Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
filling a forumla down a column from data across a row | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |