Copy data from one sheet and paste in another sheet with diferent columns RRS feed

  • Pergunta

  • Hello, I'm trying to create a macro that copies data from the X worksheet that is a result of a form and compile responses on the worksheet Y. However in the worksheet Y the columns are different. So I wanted a macro where I was able to specify which data from the X worksheet goes to a specific column of the Y worksheet, including concatenating some as needed.

    For example,

    Take column 1 and column 2 of spreadsheet X, concatenate and paste column 5 of spreadsheet Y


    terça-feira, 3 de outubro de 2017 01:41

Todas as Respostas