Using dropdown list to add data in different sheet in google sheet

I want to know how on doing the following

  1. Dropdown list I know how it works.
  2. I have google sheet with 10 different token in it, each one is the same, just the token name is different.
  3. how can I make it work if I click on dropdown list and choose item2, then it must when I full in the rest of the date save it to that token sheet.

I have tried to use it like this, but I think I may be on the wrong way with it.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.