Hi All,
I have a macro code for copying rows based on columns I want to copy and paste it into new worksheet. It open excel files in a folder and copy all data based on columns that I declared. The problem is that the code hyperlinks the sheet name and the cell where I copied the data. Is there...