Hi All, I an trying to create a macro which finds the last non empty cell of a row(Rownumber is always 5), copies the data till that cell of Row 5 and paste that data as values after transposing. I tried to record a macro by copying the data but it dint work. Can any one please help
Bookmarks