Macro to search column with last value and insert TOTAL column to the left

**sbara906** · 07-02-2009, 09:56 AM

Hello All-
I am trying to write a macro that will copy all data from column A of Sheet1, paste/transpose it into row 8of Sheet2, and then add a Total column (with a total formula in row 10) after the last column pasted that has a value. Everytime I run the macro, I will have a different number of values in Column A from Sheet1, so having the Total column added after the last value will be very helpful.

Can anyone help me with this? I have the copy and paste portion down, I just need help with the searching of the last value in row 8 and inserting a total column to the left of that.

Thanks in advance for your help!

**Phil_V** · 07-02-2009, 10:01 AM

Do you mean to the left, or to the right of it?

This line of code will give you the last column:

Please Login or Register  to view this content.

**sbara906** · 07-02-2009, 10:59 AM

My appologies - I meant that I need to insert a Total column to the RIGHT of the last column.

Thanks for your help on the first part, it found the last column with data! Now I just need to the macro to insert total into the column to the right.

Thanks again!

**Phil_V** · 07-02-2009, 11:13 AM

I'm unclear on exactly what the total column is supposed to contain...

then add a Total column (with a total formula in row 10)

So the 'Total' has to go in the column after the last one of row 8 that has data, but in row 10. What is it the total of?

**sbara906** · 07-02-2009, 11:34 AM

To clarify -
The column headings are in row 8, and I need to insert a TOTAL column to the right of the last column with a heading in row 8.

The sum formula (that will sume the row from column L to the last column with a heading) will begin in row 10 (row 9 is blank for formatting purposes).

I hope this helps - sorry I haven't been more clear in what I am attempting to do with this macro.