Hi,
I want to sum several cells on different sheets, but only include the cells if the worksheet is visible.
Subtotal 109 can be used to exclude cells when row or column is hidden, but how to make this work when the entire sheet is hidden?
/ Kim
Hi,
I want to sum several cells on different sheets, but only include the cells if the worksheet is visible.
Subtotal 109 can be used to exclude cells when row or column is hidden, but how to make this work when the entire sheet is hidden?
/ Kim
Last edited by kimrh; 08-06-2015 at 11:17 AM.
if you have hidden sheet name then use indirect function keeeping same as wokingsheet
Hi,
Thanks for helping out, but unfortunately I'm not sure if I understand what you mean.
/ Kim
if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you could just enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though
Pull the sheets out of that range before you hide them
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
Think this might work if I adjust the macro to move the sheets around.
Thanks!
/ Kim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks