Okay so here is the situation. I have a Workbook with 33 work sheets containing a column which is called "Cert" which contains a number referring to the certification number of an elevator, on the same row as the cert number is a date of when the Elevator itself was used last out on a job. The maximum days an elevator can be used is 500 days, after 500 days we need to summarize all the dates that it was used in one page. The result page has a possibility of holding 250 entries so the results will be spread out on 2 pages. I want that when i input the "Elevator Number" then it pulls all the dates from all worksheets into the result cell range. Here is the workbook.
VBA script to collect data from multiple worksheets
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!