Insert data from another sheet - Copy

Shwetha Sakaray

Can you please provide a formula where I can copy data from one sheet to another using formula.

No vlookup is required.

This is a simple copy of the data from one sheet's column to another sheet's column.

Seth Morth

Hi! Is there a 'Condition' or 'Criteria' to trigger this need to copy? I've always done these with an Automation workflow, see attached .pdf (Copy Row is at the very bottom). If there is no condition you can have it do so automatically at a scheduled time interval.

• Seth

Automation Workflow Copy Row.pdf

Shwetha Sakaray

Hi Seth,

Thanks for the reply.

This copies all the columns from a row, but I need only one column from the row not all.

Example:

In Sheet 1, there are Employee ID, Employee Name, Address, Salary columns. Whenever this row gets added in Sheet 1, we need to add Employee ID in Sheet 2.

Could you please provide me steps to handle this case.

Regards,

Shwetha