Microsoft Microsoft excel 2007 full vers...

In column A, I have the following data: 2, 2, x, 2, b, 3, 4, 5. A total of 8 rows of data. The first data can be in any row, I mean the starting row will vary. Now I want to insert 3 rows after the ‘b’ and place the sum of all data above it directly below the ‘b’. In this brief example, the total would be 6. The macro cannot be column specific as the data will not always be in column A. Further, the macro cannot be row specific since data can start at any row and I may want to add just the first row or add the first 25 rows. This macro was exceptionally easy in the spreadsheet I was using but in Excel, I can’t begin to write the necessary code. Any help is greatly appreciated.

re: "This macro was exceptionally easy in the spreadsheet I was using but in Excel, I can’t begin to write the necessary code."What macro are you talking about?

What spreadsheet were you using?

How did the other macro work?

How did it know about all of the variables (row, column, number of cells, etc) that it needed? Did it ask you a series of questions?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History