Hello - I have tried the sum when the Total SUM column is always is in F column in different sheets with the help of code but what if we have sheets where the Total SUM is in different column in different sheets ?
How to select such columns , something which searches the header for the term "Total SUM and it should be dynamic ?
Attached file
Hi,
Does this help you?
Please Login or Register to view this content.
Last edited by sweep; 10-13-2022 at 10:59 AM.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Please Login or Register to view this content.
Last edited by sintek; 10-13-2022 at 01:09 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thank you so much.
Sir what if i want of total in Total SUM column in all sheets and more dynamics ?
Like below screenshot :Attachment 800479
Invalid attachment, but am guessing you want to total the SumTotal Column...See amended red snippet above...
Attached file with red arrow autosum which i want
Yep...red snippet added in post 3 does that...
Oh.. I am sorry.. I did not refresh the page.
Thank you so much Sir.
It is very helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks