I attached a sample workbook to help with the explanaiton. I have a set of data that I am trying to pull onto another sheet. The data sheets are monthly production sheets that I can drop into Excel. The other 2 sheets are how I am trying to gather the information and what I want it to look like when its done.
I am having trouble becasue the numbers are offset from the names I can match them too. Its just the way the system gives it to me and can't be hcanged unless I manually go in and align the rows.
Thanks in advance for any help.
I did try using =offset but the formula kept returning an error so I couldn't save it with my attempt. I used the offet before the match which I'm guessing won't work