Hi All I copy data from a pivot and place in sheet 1 the columns of the pivot will grow to a unknown number but I doubt more than a few hundred, with this data I want to copy it to another sheet but the columns in this sheet cant exceed 19 as need to print the results and also populate a time sheet.
So basically copy A1-R19 to another sheet, if data still exists to the right of R1-R19 repeat the copy and include A1-B19 but paste under the first data countinue till no data exist then move down to A20 and repart the process if data exist and so on !!
Hope this makes sense!! have attached sheet with the desired outcome
Thanks taking the time to look/help
Bookmarks