Copying rows, but without automatically adding every single column into the 2nd sheet
I didn't see a discussion about this with a quick search, so here goes:
When I copy a row from one sheet to another, the 2nd sheet automatically gets updated to include every single column in the original sheet. This is a real hassle when I have 220 columns in the original sheet, but really only want 40 or so of them in the 2nd sheet. I end up hiding 180 columns of unnecessary data.
Then if I ever add a column or change a name in the original sheet, the 2nd sheet gets yet another column added during the next copy event.
a) is there any way to use the copy function to create a new row, but not add Every Single column into the 2nd sheet?
b) it would be fantastic to have the option when setting up the copy automation to choose whether to add all columns, or populate the new row using only the columns that already exist in the 2nd sheet.