Macro that will calculate sum of cells even if rows are added

[paulr24]

Hey guys,

So I'm trying to create a macro that will simplify dealing with a file we receive at work pretty often. I've enclosed a spreadsheet that shows a very basic example of the files we receive. What I need to happen is this: On the rows that have only the Company # in column A and Total $ in column D (ie. rows 5 and 6), I need the Total $ amount moved up one row and then for the row it was previously in to be deleted (at that point that row should only have the Company $ and no other data in it so it's basically useless). The problem I'm having is that if any rows are added to the file (for instance if an row was added between rows four and five) it would throw off my macro. If anyone has any ideas for me I'd appreciate it!

[AndyLitch]

example.xlsm

How's that ?

[daffodil11]

I went with:

Please Login or Register  to view this content.

[paulr24]

Thanks for the help guys!