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
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
.
