kaper thanks for the reply, the macro wont work becouse i should have clarified that i need the transposed numbers to be a formula becouse they feed a what if data table and if they would be hard cosded i wont get any new simulations. is there a way to get the columns transposed but keeping the columns as a reference?