I'm trying to look up values in a spread sheet and then paste them into a seperate sheet that is already formatted. The only catch is that I want to be able to change the code if my lookup if the sheet format changes on the sheet that I"m pulling my values from.

Example: on sheet 1 i have headers and rows that are labaled. Then on sheet 2 I have different headers and titles, but i want to pull data from sheet 1 and paste into sheet 2 using VBA.

sample.xls