I have multiple files that are sent to me on a monthly basis. They're laid out with End of month dates to the left, then an unneeded "Days in Month" column, then tons of different headers, with values underneath. Each file has a tab laid out the same, one for Days, one for FTEs, one for Cost. I don't have access to Power Query, but we will be moving up to Excel 2016 in a few months, so need something in the meantime.
So, for each of about 20 different files each month I would like to bring the values from all three sheets into one sheet with Five columns:
1) Placement -this is the header values
2) Month-Yr (beginning of month, though data reflects End of month)
3) Days
4) FTEs
5) Cost
I've attached a sample workbook. I'm thinking there should be a simple lookup formula I can use to bring in my values, but so far I'm not having luck trying an index/match route. Any help would be appreciated.
Bookmarks