Is it possible to select multiple values according to a specific tab layout ?

**Robertodeladrue** · 11-21-2022, 02:39 PM

To be a bit more accurate, here's my problematic :

I have a workbook with many tabs, I'm working with some of them, the other not necessarily.
I want to consolidate some values that are all displayed in different tabs, but under the same configuration (let's call them tab 50 to tab 65)

So Tab 66 is the consolidation of the previous tabs (same format still).

Easy so far. The problem is, my manager would like that the cumulative data on tab 66 only take into account the data from tab 50 to 65 IF AND ONLY IF the tab is SITUATED between tab 50 (the first in the workbook in which I pick data) and tab 65 (the last in the workbook in which I pick data).

To be clear, if for instance I move the tab 58 to the left (out of the range between tab 50 and tab 65), then the data in this tab is not picked up anymore.

Is there any solution for this peculiar issue ? Thanks in advance fellow excel team

**TMS** · 11-21-2022, 02:48 PM

Typically, the approach to this is to have a dummy Start and End worksheet, which can both be hidden.

Then, for example, you can use something like =SUM(Start:End!A2) on your Summary sheet. This will SUM the cell A2 on all worksheets between Start and End. So, 50 to 65. To exclude a sheet, drag it outside the Start and End sheets (either way).

**Robertodeladrue** · 11-22-2022, 06:35 AM

Works perfectly fine, that's just perfect. A BIG THANK YOU to you

**AliGW** · 11-22-2022, 06:48 AM

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

**TMS** · 11-22-2022, 06:58 AM

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Is it possible to select multiple values according to a specific tab layout ?

LinkBack

Thread Tools

Rate This Thread

Display

Is it possible to select multiple values according to a specific tab layout ?

Re: Is it possible to select multiple values according to a specific tab layout ?

Re: Is it possible to select multiple values according to a specific tab layout ?

Re: Is it possible to select multiple values according to a specific tab layout ?

Re: Is it possible to select multiple values according to a specific tab layout ?

Thread Information

Users Browsing this Thread

Similar Threads

Pivot chart layout to show multiple values on same line

[SOLVED] How to manually to select multiple csv files and select specific colounms from csv

select and sum the values for specific ID

[SOLVED] How to select multiple different cells that contains specific text

If 4 cells have specific values then x; Select Case?

Select multiple columns bases on specific value in Row 1

[SOLVED] How to select all cells to the last cell in a specific column and copy values

Bookmarks

Bookmarks

Posting Permissions