Need sub total VBA code. Attached the sample file. It is not a constant row. Sometime total field in 4th row or 8th row depends upon the data.
Need sub total VBA code. Attached the sample file. It is not a constant row. Sometime total field in 4th row or 8th row depends upon the data.
1. What determines where the TOTAL goes?
2. Have you considered using the built-in GROUP or SUBTOTAL functions instead?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It should apply Sum() fucntion of the row where "Total" mentioned.
If it is allowable to modify the setup of the sheet then you could put the following formula in cell C2 and copy down, as shown in the attached file:Let us know if you have any questions.Formula:Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
it is okay but i need VBA code on the same column "B6" & "B11". Row number is not constant sometimes it would be "B8" or "B20".
vba code to subtotal of the blank address
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks