Hello everyone,
I'm sure this will be really easy for someone, but I've been stuck for ages, so any help would be appreciated please.
I have a table with over 2,000 rows of data.
I would like a macro that starts by copying data from C4:V4 and pastes it as values into C1:V1.
Then it would copy the results from W1:Z1 and paste it as values into W4:Z4.
Then it would move down and copy data from C5:V5 and paste it as values into C1:V1.
Then it would copy the results from W1:Z1 and paste it as values into W5:Z5.
And so on, so the last row (for example row 2000), it would copy data from C2000:V2000 and paste it as values into C1:V1.
Then it would copy the results from W1:Z1 and paste it as values into W2000:Z2000.
But the number of rows might change, so it needs to be able to loop for as many rows as there is data. Column C would always hold data (until the whole row is blank).
Thank you so much!
I'm sure this will be really easy for someone, but I've been stuck for ages, so any help would be appreciated please.
I have a table with over 2,000 rows of data.
I would like a macro that starts by copying data from C4:V4 and pastes it as values into C1:V1.
Then it would copy the results from W1:Z1 and paste it as values into W4:Z4.
Then it would move down and copy data from C5:V5 and paste it as values into C1:V1.
Then it would copy the results from W1:Z1 and paste it as values into W5:Z5.
And so on, so the last row (for example row 2000), it would copy data from C2000:V2000 and paste it as values into C1:V1.
Then it would copy the results from W1:Z1 and paste it as values into W2000:Z2000.
But the number of rows might change, so it needs to be able to loop for as many rows as there is data. Column C would always hold data (until the whole row is blank).
Thank you so much!