How can I copy specific columns from one sheet to another sheet?

[jonnyrask]

Newbie question,

I have one excel file and two sheets. I need to copy 3 columns out of the 15 columns in sheet 1 and paste those 3 columns into sheet 2. How can I do this?

[PeterA1]

Hi @jonnyrask  You can do this by creating a workflow that reads in both the sheet you want to copy from and the sheet you want to paste to, then use a join to either: Join (vlookup style) matching on a particular field, or Join "By Record Position". It might make it easier if you could supply some example data, there are a few ways you could tackle this. 

[fmvizcaino · Accepted solution]

Hi @jonnyrask ,

You can open each sheet with a different input data tool, join the data and overwrite your sheet from the input file.

Example attached.

Best,

Fernando Vizcaino