Macro HELP!

[gexcel15]

Hello,

I would like to create a macro-enabled template that will take the TOTALS (row) from each of the below columns and move them to the bolded section below.

Thanks for any assistance you can provide! G[TABLE="width: 1476"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]



Pre-tax $[/TD]
[TD]After-tax $[/TD]
[TD]Catchup $[/TD]
[TD]Roth $[/TD]
[TD]Roth Catchup $[/TD]
[TD]Company Match[/TD]
[TD]Company Base[/TD]
[TD]Temporary Incentive Credit[/TD]
[TD]Additional Company Base[/TD]
[TD]Nova Enhanced Company Base[/TD]
[TD]Transition Credit[/TD]
[TD]Loan1[/TD]
[TD]Loan2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]280.97[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]187.32[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]346.02[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]346.02[/TD]
[TD="align: right"]173.01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]173.01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]734.38[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]440.63[/TD]
[TD="align: right"]220.31[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]73.44[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]TOTALS1080.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]786.65[/TD]
[TD="align: right"]674.29[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]433.77[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2975.11[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TRP[/TD]
[TD]After-tax $[/TD]
[TD]Company Base[/TD]
[TD]Company Match[/TD]
[TD]Loan 1[/TD]
[TD]Pre-tax $[/TD]
[TD]Catchup $[/TD]
[TD]Roth $[/TD]
[TD]Roth Catchup $[/TD]
[TD]Transition Credit[/TD]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]674.29[/TD]
[TD="align: right"]786.65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1080.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]433.77[/TD]
[TD="align: right"]2975.11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[philwojo]

I am not great with Macro's yet, still learning, but is there a reason you need this to be done with a macro?

Seems like you could just point the Bolded section to the specific cells in the Totals row and that would work, is there a reason you don't want to do it that way?

 

[gexcel15]

Hi Phil,

Yes - I could point the Bolded section, however, this is something that's daily (at least 4x/week), for various payrolls and I'd have to copy the BOLDED row to every single workbook, every time.

In other words, the BOLDED row TRP....After Tax... is something that needs to be included in every Excel workbook for various Payrolls ran during the week. Payrolls are run Every day except Fridays.

Thank you

 

[My Aswer Is This]

Normally we would never say:

take the TOTALS (row)

We would normally say:

Take row (4)

You want a script to look down column A to it finds a cell with bolded text

And then look down and find the

"and move them to the bolded section below."

How do we know where the bolded section is ??
You should say to row 65