Find Column Title instead of using Ranges

[xyang06]

I have a Excel sheet with 3 columns, Start date (Column Title: Start), End date (Column Title: End) and Price (Column Title: Price).
My current macros is calculating the New Price (365 days) based on the Price given and the Start and End date. The current macros, I have inserted Column Ranges, but each time the the sheet will be different, so can someone help me to change this macros so that it work with multiple sheet where it finds the 3 different Column Titles first and then apply the formula and output New Price will be in the first blank column.

Please Login or Register  to view this content.