Calculating Months by grouping tab numbers??

B

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
Is there anyway to create a formulae to group tab numbers to create a monthly breakdown?

For E.G.

Tabs 1 - 4 WILL BE JANUARY
Tabe 5-9 - will be February?

There is 52 tabs from 1-52 within the workbook...

Any ideas? Thanks in advance?

Andrew
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

T
  • Question
Data from specific tabs on multiple workbooks
Replies
4
Views
203
tony mcpike
T
C
  • Solved
The Numbered Week of the Month
Replies
5
Views
299
lrobbo314
lrobbo314
E
  • Question
Copy data from a Data Entry form's table to the correct date in another tab
Replies
0
Views
83
Exceleration65
E
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
219
Insurance Dave
I
T
  • Solved
INDIRECT Formula does not like tab names
Replies
3
Views
138
Fluff
Fluff

Forum statistics

Threads
1,214,849
Messages
6,121,925
Members
449,056
Latest member
denissimo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top