Hello,
I have a data input row of cells (C1:C5) on sheet 1, i need to copy and paste these cells into another sheet (sheet 2) and transpose them on a button press using VBA, everytime new info is entered and copied it needs to be place in the row beneath on sheet 2.
hopefully it makes sense?
thanks reg
Bookmarks