PeggyLang ✭✭✭✭✭

I have two worksheets (A & B). Both worksheets contain rows of individual store data.

Worksheet A has a check column that indicates whether or not a 'spin off' scope of work needs to take place. If the column is checked the row is copied to Worksheet B where we track the 'spin off' scope of work. There are some common columns of information we need from Worksheet A in Worksheet B. The 'pain point' we are running into is when the row is copied, or populated via DataMesh to Worksheet B we get ALL of the columns from Worksheet A. We only need some of the columns.

Is there a way to limit what columns get copied over?

If no, what is the best way to handle this minor 'pain point'? I'm guessing the easiest solution would be to hide the columns that are unwanted?

Best Answer