PDA

View Full Version : [SOLVED] Combine worksheets and move row and columns



RoyceB
01-20-2017, 06:17 AM
I'm pretty new to vbscripts. I used CopyFromWorksheets to combine all worksheets in a workbook into one worksheet which worked great. Is it possible to move rows and columns during the combine? All my worksheets are idnetical and for each worksheet, I want to move A1:L29 into the same columns on the combined sheet (A to L), but then move A31:L59 to columns M:Y so the data is beside the other data, not under it.