Subtotal Query

[[email protected]]

Hi,

I want to edit the below code instead of mentioning the column numbers for each column from 4th column till last column the subtotal need to be calculated.

Since number of column may vary each time i want flexible code to calculate subtotal from 4th column till end of column

Existing Code:

[protonLeah]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[[email protected]]

Hi,

Kindly refer the attached excel, where columns are increased from 10 to 12 in sheet 2.

I need to amend the vba code to flexible to use when columns are increase or decrease.

[protonLeah]

Please Login or Register  to view this content.