I have two workbooks, the first workbook is a data entry sheet and the second
one is the source / database workbook. If I enter an item to the first
workbook and click the search button, it will search in the source workbook
and fill the columns in the first workbook with the data found.Some cells in
the source workbook contain formula, I want to copy the formula but the
reference cell will change according to the row where I enter the item in the
first workbook. Is there any way to do it? Any idea will be of great
help...Thanks!