I would like to inquire about copying and pasting repeated items.

kdg041

Currently, when using smart seats, each item is used in duplicate, only the content and number of participants are being changed, and manual copying and pasting are currently being performed.

I think it's very unreasonable in that regard. And I want to say. I'd like to sort the list on a completely different sheet and paste the name on the worksheet, for example if "aaaaa" can automatically paste when typing "22-235"

Paul Newcome

If you have it stored on a separate reference sheet, you can use an INDEX/MATCH or VLOOKUP with cross sheet references to pull "aaaaa" into a column when you type "22-235" into another column.