Grouping or Combining sheets

TWILSON29

New Member
Joined
Nov 5, 2013
Messages
30
Good Afternoon Excel Experts,

I'll start by listing my main objective.
Currently each week we use an excel workbook with 5 sheets, Monday, Tuesday, Wednesday, Thursday, Friday.
At the end of the week we save all 5 sheets to PDF, at the end of the month we combine the PDF's and build a monthly shipment manifest.
This allows us to check historical shipment dates.
Having said this I'm trying to figure out a way to keep all this information in excel.
This will make tracking information much easer for everyone.

I have created a dynamic calendar using the instruction given in this video:

What I trying to do is create a "group" of sheets.
Ideally have the calendar + 12 sheets at the bottom of the workbook, one for each month.
This way I can have a group called "March", with in the group of "March" have a sheet for all business days named:
2,3,4,5,6,9,10,11,12,13,16,17,18,19,20,23,24,25,26,27,30,31

I want to then link the cell reference onthe calendar for that date to the sheet it corresponds to.
Click on March 16 and it takes you to product shipped that day.
This will allow me to search the entire work book for a company name, order number, PO number ect.

What I don't want to do is have hundreds of tabs and make a complicated tool to use.
If we don't make it easy then people wont do it...
Not sure this function exists, but if anyone can help it would be much appreciated.

Thank you for your time,

Tyler
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
ASAP utilities would create an INDEX sheet for you, as for grouping sheets in a workbook, never seen that done, you could colour tabs by month
 

TWILSON29

New Member
Joined
Nov 5, 2013
Messages
30
Turns out my idea wont work even if I can stack sheets.
The hyperlink to the sheet is attached to the calendar cell, I was hoping it would change as I changed the month and year :(.
Any ideas would be appreciated.
 

Forum statistics

Threads
1,144,700
Messages
5,725,829
Members
422,644
Latest member
BethGS

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
Top