Oct 06 2021 05:26 AM
Hello everybody.
I use Excel web, through the Windows computer.
I have two spreadsheets, one to register (Sheet A) and the other with a list of products (Sheet B), which contains some information together.
I want to type the code on Sheet A, and importing the data from Sheet B, the ballots complete themselves on Sheet A.
Here's Worksheet A:
Here's Worksheet B:
Example:
If I type code 680 on Sheet A, I want it to auto-complete SheetA -> A2 and SheetA -> A7. The data to fill in these ballots will be on Worksheet B.
Oct 06 2021 07:31 AM