Transfer rows of data from multiple workbooks to master workbook based on value in row
I'm a bit of a self taught excel user, so my VBA knowledge is a bit limited. I have created timesheets for employees that work in our shop. Our company manufactures products for different industries, such as mining, wind power generation, general industrial applications, and so forth. I modified some time sheet templates I found for excel to accommodate our company's actions. Each employee has their own workbook, in which the months are separated into different worksheets. Each sheet is divided further into weeks and in each weekly section the areas of information are divided. I have attached an example worksheet for reference.
There are 7 workbooks (one for each employee), each with 12 sheets (one for each month)that I need to reference. I want to create a master sheet that will pull information from everyone's timesheets if they worked on a particular job. In other words, I would like to type a job number into a cell in the master sheet, then have excel look through everyone's timesheets and pull over only the rows of information that contain that job number and populate those rows in the master sheet. From there I can further manipulate the data to get further information for a particular job.
I have been searching and have only gotten limited advice on this subject. I was hoping to accomplish this without VBA through a combination of formulas, but I have failed in that field. Please let me know if this is possible. Thank you in advance for any help.
|Joe Smith.xlsx||370.38 KB|