how is it not apparent? Do you mean my code, or my task in general?
From the excel file, I want to take the average mean, which for this instance is located in cell e4, and for each SET POINT, which are -20,5,22, I want to paste it into that column of the word table.
So if the set point is -20 I want to paste into the first empty cell of the -20 column,
If it is 5 I want to paste into the first empty cell of the 5 column
If it is 22 I want to paste into the first empty cell of the 22 column.
To differentiate the set points, I have been using if statements, but that has been messy so now I am trying to write three separate macros for each set point. I will be using these macros on the same word table continuously and wish not to change the paste location in the macro every time it is run. I want to find the first empty cell in the specified column, and then select/paste into it or write it in.