First time posting so i hope you can help.
Thanks in adavance.
I need to copy data from one sheet (Saudi) only copying 1 particular column (D) and transpose that data (keeping the values in there) to another sheet (Results) to the next available row.
I have figured out how to transpose to the next sheet but cant get it to find the next line to use.
Data to copy
Transpose to next line
Code
New contributor
Chizie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.