Automation -Logics

Help Studio
, ,
1

Hi ,

I am practicing automation.
Problem statement:

  1. Need to read the input data in column A of excel sheet “Topics” .
  2. Go to www.octopart.com and put the each input in search bar and then scrub the “authorized distributors” and " Unauthorized distributors" data.
    image
    image1636×832 132 KB

    image
    image1612×568 91.1 KB
  3. then need to write the scrubbed data(from cell “B2”) in 2 different sheets of same excel with the corresponding input (in column A)we given.

Problem i am facing is , i can able to write the which i scrubbed from website. i dunno have add my input (Column A)to the corresponding data from website. I have attached the excel data and program file also. Kindly help on this,

Data.xlsx (24.3 KB)
Main(Autosaved).xaml (22.3 KB)