I am in need of help to build up a macro that will replace the column names at row 4. I have an excel sheet that looks like the sheet1 in the attached. I need to replace the column names for those column name "Proposal#" that has values 1 and 1.* that starts from row 5. It has to loop columnwise and check for each proposal# and if the value is 1 or 1.* then it should replace. The desired output is in the Sheet2. Can anyone please help me on this.
Bookmarks