Hi all,

I tried to find the solution of this issue in the forum but could not, hopefully you can help.

I am trying to create a form that once completed by the user will automatically feed in the final information into a specific cell. (See Attachments).

For example the user will fill in the form and select the various options> Product Type>Type of Sales> and then once he did this he will type in the form the relevant number value for Sales for that specific product. Once he completed the form, the value will be automatically feeded in the correct cell in the main Spreadsheet (Yellow Colum).

This automation is required to reduce errors of manual input in the spreadsheet.

Thanks in advance for your help

Example.xlsx