More than 1 row of tabs?

Is it possible to have more than one row of tabs?

I would like to use 10 or 12 horizontal rows of tabs.

1 row for each contractor then 10 or 12 tabs in that row.

That might work CK, Thanks.

All I really want is a grid pattern. 10 x 10 sort of thing.

Top row would be say AAA trucking and then 10 links to each of their drivers days numbered AAA1 etc.

I can do it just on buttons to open a page for AAA1 etc, fill in the details and at the end of their shift print out the page but how can I get it to automatically go back to the 10 x 10 grid??

Just trying to make input simpler really. Thought that rows of tabs might be a quick way. A book would be for a week, split into 7 days then each contractor would have a row. Their 5th driver would be Big Truck 5 etc and we input their days work. When they are finished we print a copy for them and save........ Back to the drawing board :-)

Would use maybe 30 on an average day, 60 to 70 at busy times. Some contractors would only have 2 shifts each day and some could have 15 or 16. Wanted to make sure I had plenty to cover and no one was trying to modify it when i'm off.

Originally Posted by FDibbins

I still think if you gave a bit more thought to what you have, and what you want, this could be made simpler. Many users start by designing what the output needs to look like, and then trying to fit the input to match - this is the wrong way round. Figure out how best to enter/input/capture your data FIRST, then we can work around how to resent it the way you want

At the moment we print this sheet out and manually write the information on them then have to type it all up later. Plan is to do it all on pc. If I can have Friday, week 14 page for AAAA Trucking with 10 of these sheets in we can complete them. So F Dibbinns would have his own sheet, when he is finished we print the sheet to show his work for the day and save the sheet. We can then reference this when an invoice is sent in.
Once a sheet for the 7 days and different contractors is built we would just copy and paste from a blank master sheet and change it to our company week number.

Contractor Sheet.xlsm This is the idea I have at the moment. When a driver starts their shift we fill in their details, update it through the day and when we are releasing them we would generate a unique reference for that particular days shift and print it out to hand to the driver. I would need 10 to 15 of these daily and up to 70 or 80 of these at Christmas. My idea was to have tabs for AAA Trucking from 1 to 15 (for the contractors we use most) and then Local Truck 1 and 2 (for a small local company) These contractors are used as required so a contractor might have 3 drivers in today and 12 in tomorrow.

Its ok FDibbins, I don't have to go through the kazillion sheets (I see what you mean though)

My hope is just to enter the information onto those sheets, when they are complete and we are happy to finish up the driver for the day we print a copy for the driver and then save the sheets.

There really isn't any analysis, its only a check if there is any invoice query.

FDibbins Transport invoices us for 4 drivers working on Saturday 2nd June, We say you only sent 3 drivers in, If your drivers haven't all given you a copy of that sheet and the reference number we wouldn't pay you for 4. (Hope that makes sense)

Its more to stop the wise guy drivers from doing 4 hours work, leaving site and parking up then telling their bosses they have done a full day as we pay for 10 or 12 hour days depending on the company we use.

I'm thinking a folder for each week, split into 7 days then tabs along the bottom for F Dibbins 01, F Dibbins 02, Joe Bloggs 01, Joe bloggs 02 etc might be the easiest solution?

I also agree with Ford.
Whilst your form may look "pretty", it is a nightmare as far as extracting information is concerned, what with merged cells & cells containing more than one piece of info.

Back to the man cave to build a bigger drawing board I think

Thanks for your help everyone.

I need help all the time and as much as I can get Ali!

But Danger is my middle name!....... what a fight to get passports renewed

My twisted sense of humour Ali......My passports are a nightmare to renew because my middle name is 'Danger'......... I know

I have been in the man cave, built a new drawing board and gave my head a shake

If I built 7 days like this onto 7 tabs it would obviously give me a week at a time.

I can expand on this to add or remove contractors as required.

Anyone can copy and paste a blank week and rename it in seconds and all we would have to do is change the week number on each days sheet manually at the start of each day. (Our week number is not a standard week number, we are currently on week 14 so manually changing this is nice and easy) (Tried a formula that works until we get to week 1 then is shows we are on minus 8 )Start from scratch.xlsx



If I keep it simple with this sheet is there a way to stop the reference numbers changing each time the sheet is opened? I can create a macro to take the information for a drivers employer, name, details of his days work onto a separate sheet and print that out for them but its no good if the reference we give them changes next time the sheet is opened??

Originally Posted by FDibbins

OK a bunch of very proficient excel experts have strongly advised against going the route you seem determined to follow. Members come here for advice and help, you have been offered both, but turned them down.

You want a few rows of tabs, that is not going to happen. You still want all those tabs though, so I guess you will just have to figure out how to deal with/manage them all?

Wow!...... Thanks FDibbins, seems I wasted my time posting nearly 3 hours before your reply with a totally new idea. Won't bother the experts anymore.

Originally Posted by FDibbins

Why just add another column for date, then have it all on 1 sheet? You seem to be heading in the right direction

A BIG thank you to everyone who has helped me with the bits and pieces I have managed to do so far. Will figure the rest out for myself. Will leave the forum before I get myself into trouble.

Re the week numbers, if the problem is just that they drop to -8, try something like this:
IF(_<1,_+9,_)
replacing the underscores with your current formula.