I am having a problem indexing from the "feed" ssheet to the "Fill in" sheet in the attached workbook. I am just trying to pulll the data from the feed sheet onto the other sheet by the employee name, in this case the highlighted cells.
In the actual workbook there are many more employees but I don't think that matters. There are going to be different feed sheets for each month so it shouldn't be all the complicated.
I was wondering if there was a problem becasue some of the cells in the index I was making are merged and centered as different sizes? I get the report on the feed sheet from a different department so I am trying to work with what I have at the moment. I'm hoping its just a silly over sight thats messing me up seeing as how all I've been doing for a couple weeks is staring at excel.
Thanks in advance for any help you can provide.
Sampleproblem indexing.xlsx
Bookmarks