Many good threads but still struggling with what is hopefully a simple problem to solve.
I have been able to create a macro that copies and pastes the values cell by cell but this is the limit of my macro/VBA abilities and does not get me to the goal. What I hope can done is, after copying a range from " wokbook1", the macro will transpose paste the values to the next available row, is this possible?
Thank you.
I have been able to create a macro that copies and pastes the values cell by cell but this is the limit of my macro/VBA abilities and does not get me to the goal. What I hope can done is, after copying a range from " wokbook1", the macro will transpose paste the values to the next available row, is this possible?
Thank you.