Someone enters information in sheet 1 auto create row in sheet 2

Jessica_W

Hi,

I have two sheets: “De-install sheet” and “Inventory sheet”. Is it possible to automatically create a new row in the “De-install sheet” when someone enters information (date, serial# etc…) and selects “De-Installed” from the drop-down list in the “Inventory Sheet”. I would also like the new row to be populated with the date, serial#, and an auto-populated email (already built in “De-Install sheet”).

Thanks,

Jessica

Paul Newcome

Have you looked into a Copy Row automation?