I have a workbook with 100+ work sheets,
Worksheet 1 - the column header are “the days of the year“ and the rows are a list of equipment and associated readings.
Worksheet 2 - has Vlookup info for worksheet 1.
Worksheet 3 thru 107 - are name for each piece of equipment, Columns are the different readings for that piece of equipment and the rows being the days of the year. These sheets are filled out as info is entered daily on worksheet 1. Column A has a number value for the month each row belongs in.
What I need is a way to print worksheet 3 thru 107 showing the information for a specified month. Possibly by creating a button on Worksheet 2
Worksheet 1 - the column header are “the days of the year“ and the rows are a list of equipment and associated readings.
Worksheet 2 - has Vlookup info for worksheet 1.
Worksheet 3 thru 107 - are name for each piece of equipment, Columns are the different readings for that piece of equipment and the rows being the days of the year. These sheets are filled out as info is entered daily on worksheet 1. Column A has a number value for the month each row belongs in.
What I need is a way to print worksheet 3 thru 107 showing the information for a specified month. Possibly by creating a button on Worksheet 2
