in our firm every month we import in Excel some data from SAP. On the "Sheet 1" there is the table with imported data, on the "Sheet 2" there are some formulas in which are used values from "Sheet 1". Unfortunately, sometimes when we import data for the new month the columns are moving and thus the formulas become wrong. I decided to write a macro which will search the whole row 5 on Sheet 1 and find cell with text "Overall result" and then use this column in the formula as the last argument. (Formula is : =SUMIF (Sheet 1 F:F; E10; Sheet 1 Z:Z)/100). I need to replace Sheet 1 Z:Z with the right row. Can you please help me with the code? Or maybe if you see another way to solve this problem, please share :) Thank you in advance!!