VBA .formula with dynamic element

? In the attached file I am trying to create a interface that allows the user to select fileds that are on the raw tab and creat a new tab that will return columns of data from the raw tab. It is necessary to use the match offset formula I have but I am having problems dynamically updating the formula in the VBA loop.? I know all the fields that can be used on the new tab so I put them on the form with check boxes and I reached the point where I can get the fields that are checked off to return on the new sheet but I am having trouble getting the formula to copy correctly. ? if you press control "t" and enter in a bogus name and click the create NOPCB tab you will notice the formula that is being copied over is incorrect.? ? The formula in cell C21:? iF($B21<>"",OFFSET(raw!$D$1,ROW(NOPCB!$D1),MATCH(C$20,NOPCB!$D$1:$CQ$1,0)-1),"") ? should by dynamically changing the....."Match(C$20..." to "MATCH(D$20.."...etc but? it returns "jk" in all the columns becuse the column is not changing dynamically. ? I do not know how to update that reference in the .formula? =? part of the ? VBA loop. ? Let me know your estimate. ## Deliverables I will only accept bids under <= 25$US