merge two sheets

Si Spence

Dear brains of Planet SS,

I have added 13 columns (some with dropdowns etc) to an existing Sheet and now want to add these new columns to another five sheets.

is there a quick way of doing this please?

I know rows can be copied to an existing sheet, but what about columns?  I was thinking that if i created a new sheet that only contained the new columns then maybe i could merge the new sheet one by one with the existing sheets??.

makes sense?

Shaine Greenwood

Si,

You can copy a single row to the other sheet. 

Columns that aren't already on the destination sheet will get added to it. The only exception to this is System columns, see Copy Rows to Another Sheet for more information.