I have 4 columns of data namely ETD, FTD, GTD and HTD. These acronyms are entered in the header row of columns E,F,G ans H of the worksheet. Under these columns are 2000 rows of numbers.
I have also created a new column in column I and it is called TD_to_use. The formula for this column is =MAX(E2:H2) where the row number will change for each row.
Another column J, called TD_type should contain a macro to provide the header name of the row that has the maximum value. Hence if the number under ETD is highest of the E:H range, the macro will provide the answer ETD in the appropriate row of this column.
How do I write this macro??
A sample is attached.
Raury
Bookmarks