Copy/Paste COLUMNS from One Sheet to Another

KGetchell

Good morning!

We are working on updating the Milestones we track on all projects. In order to increase our data points to create more opportunities for more dynamic reporting, I have about 30 columns on a master "template" sheet that I need to add to all of our existing project tracking sheets.

Is there any way to copy/paste COLUMNS from one sheet to another, including the Column Header?

Thank you!

Kate

Lori Cross

Hi, @KGetchell I have used Data Mesh to copy data from my source sheet to another (target) sheet. You must have one column on each sheet with common data, like an order # or SSID# but it is easy to set up and the target sheet is always current with the master's data. I hope this is helpful. Lori

KGetchell

Thank you, @Lori Cross. The data copy is not the challenge, it's the physical columns.

Example:

Sheet 1: Rows A, B, C, D

Sheet 2: Rows A, B, C, D, E, F, G, H

Goal: COPY Columns E, F, G, and H from Sheet 2 into Sheet 1 (including Headers)

Genevieve P.

Hi @KGetchell

If you use a Copy Row workflow or if you manually use the Copy Row option on a row, this will automatically add any columns that don't exist on the source sheet to the destination sheet with the same names. See: Things to know about moving and copying rows between sheets

Cheers,

Genevieve

Pauline J

I have the same challenge -- over 100 sheets that need to match, and need to add 5 more columns -- when I copy the row (select copy to another sheet) the row doesn't copy, and the new columns are not added to the destination sheet. Isn't there a way to copy these columns into all the other sheets without having to recreate every column one at a time on each sheet? Some of these are contact lists and drop-downs .... it will be a lot of work to do this. Fingers crossed!

Wendy P

I have the same issue as well. I thought you could copy a row from 1 sheet into a new sheet and it would populate the column headers, but it isn't working.

Genevieve P.

Hi @Wendy P

It will add new columns to the destination sheet if they don't exist already - try scrolling to the right to see if your newly created columns are there! 🙂

Keep in mind any of the previous columns will still be showing as well. Copying a row does not overwrite existing columns but adds new ones. Let me know if this makes sense!

Cheers,
Genevieve