Hi, I have a worksheet with a macro that I manually run customer data through every week. I have created an additional sheet in the same workbook which uses a series of "if" formulas to populate client name and dates of contact from the macro sheet into a separate sheet. It works fine...until I update the macro....When I run new data, the formulas all change to return data in a different column. So, say that customer name is in column b and last time I spoke to them in column f, when i run the macro, the columns change so now it returns c and g and it's no longer pulling the data I want. How can I prevent this from happening?