Trying to create a formula that will search 50 tabs for a specific person, between specific dates and total miles traveled.
I Have 50 tabs identified by truck number; on each tab the columns A through D are set up as Driver Last Name, start date, end date and miles traveled. They run 4 to 5 trips a month. I need a sheet that shows Drivers in Column A, Jan in B, Feb in C and so on to December in column Z and the last column total for year.
I do not know how to search for the name, select miles from column d if they fall within a specified month and have it show on the total sheet.
Can you help?