Create printable daily work orders based on criteria within a column.

Hi Everyone, I'm trying to do something a bit out of the ordinary and I'm not sure the best way to go about it.

Basically we have a sheet which lists out the schedules for our guys broken down in a row and sorted by day. The girls in the office then take that information and write the work orders for the guys out by hand. Since the schedule only changes every 6 months. This way has worked fairly well so far.

However I would like to use the power of excel to automate the process and make it much easier.

Here is what I'm wanting to do. We currently have say 1000 rows. Each row will have the location, tech name, day, etc. What I'm wanting to do is create a button for each day of the week and when pressed it will search through each row looking for the corresponding day and then copy the column information for that row to the work order sheet and print that sheet to the default printer, then immediately go to the next row that corresponds with that day and do the same until it has run out of rows that correspond with that day.

If anyone could help me get started with this I would greatly appreciate it!

Thanks again!

Hello MyDjinni,

Perhaps the following code as a starting point may help:-

Please Login or Register  to view this content.

I've attached my test work book for you to peruse:-

When you enter a day in the search box in cell A1 of sheet1 and click on the "FIND" button, the code will filter, in this case, Column C for all day values entered into the search box, transfer the relevant data to sheet2 and then print the result.

I've only made assumptions with the above as we don't have a sample of your work book to work from and I feel that your Work Orders sheet just may be set out somewhat differently. So please upload a sample of your work book (use dummy data - just a few rows) and place some notes giving a precise description of how you would like it to work.

I hope that this helps.

Cheerio,
vcoolio.

Awesome, I'll give this a try and come back when I have questions.


Thanks again!

You're welcome MyDjinni. Come back any time.

Cheerio,
vcoolio.

Sorry for the delay in my response. I had an unexpected trip and just got a chance to really dig into it. I like what you've done, but I need something just a tad different.

Here is what I've partially come up with.

Please Login or Register  to view this content.

The problem I've run into is rather than copy the value from one of the columns from the row that Saturday was found on. It's copying from whichever cell I had clicked on before pressing the button.

My goal is to load those variables with the values of the cells from each column within the row that contains Saturday in column "C". Then copy those values to the cells in a workorder sheet I'm designing.

After the sheet is reviewed and printed then it will repeat the process for the next line until it hits the bottom.

I'm sure I'm making a rather obvious mistake, hopefully your wiser eyes can help see what I cannot.

Thanks again!

I gotcha, I'll have them review prior to executing the code. So we wont need to pause the script.

So it will go like this
1. Gather all information of a certain day.
2. Put the data cell by cell for the current row in the work order.
3. Send workorder to printer, then goto next row.
4. Repeat process for all the specific rows.

I will put a button up for each day (Monday - Sunday) and have them click on the button to run the code specific for that day.

I apologize for the confusion.

Thanks again,

Sorry for the delay in response. I just wanted to check in and see if anyone had any ideas on how we could accomplish the task I laid out.

Thanks again!

would be better if we see your workorder sheet

this gives you the data in variable

Please Login or Register  to view this content.

Kind Regards
Leo

Thanks guys, I'll update you shortly once I get a chance to apply what you've given me.

Thanks again!