Hi,
I have a large spreadsheet ranging from A1 to CC572. The 572 rows are for the crews, machinery, etc and the A:CC columns are for dates/hours and costing (E.g. Column J: Date/Hours, Column K: Cost, Column L: New Date/Hours, Column M: New Cost etc). This is a template for projects but want to avoid the time consuming process of hiding all rows that are note related any particular project for printing. I am looking for a macro to apply to a button that when clicked will hide all unrelated rows?
I have attached the spreadsheet.
Bookmarks