Copy column from one sheet to other sheet

HILDA KOSOVICH

I have a master sheet with the event name, date, location etc. that when a row is added to master sheet I just need the name and dates of event to be imported to new sheet (Event Shipping Manifest). Can that be done?

Thank you for your help.

Andrée Starå

Hi @HILDA KOSOVICH

There are two options.

1. Copy the whole row and hide the other columns that aren't needed.
2. Use VLOOKUP or INDEX/MATCH to collect only the columns as needed.

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

HILDA KOSOVICH

I'm not familiar with vlookup so i will review https://help.smartsheet.com/function/vlookup

thx, Hilda

Andrée Starå

@HILDA KOSOVICH

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mary_A

@Andrée Starå I'm looking to do a similar process as @HILDA KOSOVICH --- one thing that strikes me is that your proposed solution seems to require manual action on the destination (copy to) sheet.

Specifically, a person must enter a key value in a column on the destination side for the VLOOKUP to act on. Is this correct? Or is there an automated way around this manual, human step?