Search results

I have about 100 part numbers on a spreadsheet. Cell (D721) example. As you can see there about 10 columns and 15 rows of data tied to each part number. How can I sort the data by part number and keep all the existing cells surrounding the part number intact including the formulas...

I have three ranges a2: s18 u2:am18 and an2:be18. I need to print the ranges on an 11x17 sheet of paper in landscape. I want the charts to be the right size. If I were to cut and paste and use shrink to fit I can fit 4 on each sheet. I have to do this for quite a few worksheets daily, so I...

Thank you so much for your help. This will work.

It does give me the correct date. But it doesnt break down to hours. Is this possible?

The first schedule shows work being performed on the 24th and 25th. I need it so that the system would move those hours to the 23rd and 22nd due to the weekend.

The calculations are correct, I just need to figure out how to not assign a date that will be on a saturday or sunday. I also need the calender to only account for 20 hours in a calender day. 4am through 12am. These are the 20 hours that work is performed.

Here is the file

I am trying to update these start dates to reflect a 5 day work week with 2 - 10 hour shifts. Currently my start dates are just calculated by subtracting process time from ship date. It does not account for the 4 hours not worked each day or weekends. This one has me stumped. Tried workday...

Right now I get a daily report which is an excel dump of 1000's of parts and the daily requirement for that part #'s work order. depending on the number of work order calling for that part, the same part # could show up a dozen times or more. I copy out the part numbers that I need and put...