Create and print report from across multiple worksheets based on cell values

[stkachuk07]

I have created a Macros enabled workbook with multiple worksheets they all have the same column structure but on certain pages some columns are hidin. what i am trying to do is on my report sheet i am wanting to select a Field supervisor and be able to create a report for that field supervisor and print it off showing all jobs and the status of each job that is assigned to them.

[antoka05]

See attached file, I hope that it's what you need.

This is the code that I used:

Please Login or Register  to view this content.

Regards,
Antonio

[stkachuk07]

Ok i have copied and pasted the VBA to my main sheet and it is only pulling the information for three of the five in B8 and i only need it to pull information from the following tabs: Ready, Scheduled, InProgress, OnHold, CTL and Complete. Other than that this is just what i was wanting to do... Thanks for the help

[antoka05]

Try with this new code. You don't find 'Mike Oliver ' because in Info sheet there is a blank at the end of the name, and you don't find 'HARRY BURKHART' because in Info sheet it's writtend without 'D' and in the sheets is written 'HARRY BURKHARDT'.

Please Login or Register  to view this content.

Regards,
Antonio

[stkachuk07]

Antonio,
Thanks for you help this is just what I was looking for

[stkachuk07]

now i got to figure out how to convert the workbook it so i can use it on Google sheets

[stkachuk07]

Antonio,
this works great but i have one more piece of the puzzle i need help with. on my report sheet i would also like to print out reports for who ever the jobs are issued to as well so i can filter either by field supervisor or by the issued to column. can you help with that ?

[stkachuk07]

OK someting has went array with my VBA Code it is not pulling every column from pages in the report what have i done lol