How to google table when you write data to a cell immediately transferred to another sheet in a cell? An example is two sheets of 1 car, 2 sales.

How can I make it so that when I enter the data in the "brand" column in the "machine" sheet, it immediately transfers the brand name to the sales list in the "name" column

And then when I enter the price, car sheet, car price in the column, it transferred the price to the sale list in the left pay column.

And there is some tutorial on this topic, I read about IMPORTRANGE, but I do not know if it is suitable for this task or not.

  • Transfer - copy data or transfer? Copy: direct cell reference = other_list! A1. Without an example of data, there is nothing more to offer ... - vikttur
  • Well, I need to copy the data to another sheet - Valery ostap
  • @Valery ostap The more specifically you describe the required action, the faster you will receive an adequate response. You can copy data in different ways: with a direct link to the cell, both during onEdit processing, and by time trigger, and using different functions. But the choice of means essentially depends on specific goals and situations ... And they are not indicated. - Alexander Yermolin

0