Search results

SirJB7, Thanks for the link. I looked at that code and it will loop through a directory and print those files. I was really looking for a routine that will loop through and excel list of hyperlinks that has been sorted or filteered from a larger list bassed on multiple criteria. The database...

I need a loop routine to run down column B and print the pdf's hyperlinked there. I have looked every where and have found many suggestions how to print DOCs, XLS The sheet is formatted like this Latest Rev. Location State AREA - SITE Document Number Revision YES file:\\Production...

Thanks for you responses, I have had a chance to look at both solutions briefly. I will delve into them a little more over the next few days. But it appears both will work. I want to try a couple of different formats with the shifting. ie 2 shifts and 4 shifts to see how it stands up to the...

Hi SirJB7, I liked the look of your formula and could follow what you were trying to do. But It didn't seem to work either. I think mine is doing what I need but need to adapt your range references into it. Your dynamic range formula works great though. Thanks. I am still working on...

Hi, Sajan , thanks for your response. I tried out your formula =IF(COUNTIFS(tblShifts34[shift],$H6, tblShifts34[From Date], "<=" & I$3,tblShifts34[To Date],">=" & I$3)>0, $H6, "") but it did not seem to produce the results I was looking for . It only updated every fourth day to...

By changing the shift pattern, I mean if I needed another sheet with a different pattern, say 10 days on and 4 off having only 2 different shifts, I would like the gantt formula to manage that without having to rebuild it every time. As for the dynamic ranges for would I change it to something...

Sorry about the link it is now public. thought I'd done that in the first place.

I have created a shift calendar that calculates in this instance a 14 on 7 off shift rotation with 3 shift groupings. conditional formatting displays the shifts on a perpetual gantt style showing the shifts against the list of employee names. Conditional formatting works well as long as the...