VBA code required for different subtotals across multiple columns.

VBA code required for different subtotals across multiple columns.
i.e. on running a macro the next available line should have subtotal(9,..., for columns H, J, K, M, N, O, P, Q, S, U, V, W, X and subtotal(1,.... for column Y.
Any help would be appreciated.
Steve GrundyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
Why VBA? Use a Table and you can add this feature called a Total Row.

Overview of Excel tables

Once set up this is automatic
0
Steve GrundyAuthor Commented:
Hi Roy,
It’s a function of a new cost sheet I’m developing.
I may require multiple subtotal lines as above to cover different assembly options.

Thanks.
0
Roy CoxGroup Finance ManagerCommented:
There's a SubTotal Function from the Data Tab, but if you mean adding subtotals within the data then that will affect totals below.

Attach an example workbook.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Steve GrundyAuthor Commented:
Hi Roy,

I hope you had a good Easter Break?
Please see attached example sheet, the idea being I could cost up several assemblies (i.e. 3-4 rows per assembly) and subtotal each one up as I go,  I was hoping to achieve this with a Macro so users of all competences could use it trouble free.

Costing sheet example
0
Roy CoxGroup Finance ManagerCommented:
Easter was a long needed rest, thanks.


Can you attach the workbook. Pictures aren't a great help.
0
Steve GrundyAuthor Commented:
I echo you Roy!

Here you go.....
Costing-Sheet-R51---DEVELOPMENT.xlsx
0
Roy CoxGroup Finance ManagerCommented:
I'll take a look later
0
Roy CoxGroup Finance ManagerCommented:
Hi  Steve

I've added a button with code to sub total the data based on Product Code. Is this  what you mean?
Costing-Sheet-R51---DEVELOPMENT--2-.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Steve GrundyAuthor Commented:
Hi Roy,

That looks like it might work for me, I can update the array to sum up each of the required columns, THANKS!
0
Roy CoxGroup Finance ManagerCommented:
Just SubTotal manually but record the actions with the Macro Recorder. The code will need editing but I'll help you with that.
0
Roy CoxGroup Finance ManagerCommented:
Seems the author was satisfied
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.