(Solved) : Link Excel Spreadsheet 2 Columns Column Column Code Use Produce Automated Results New Colu Q29805846 . . . .

Here is a link to my excel spreadsheet (only 2 columns with columnA being the only column that our code will use to produce automatedresults in a new column C.)https://mymaildrury-my.sharepoint.com/:x:/g/personal/jtrentii_drury_edu/EftsWuJP2X5EqOouggNXd4QBqRD-G2uZAmm6WhDYDTyODg?e=lMfQ6GIasked the following question last night on Chegg but this code theygave me is just setting the two columns to have the same value. Ineed the code to search for the strings “Dell”, “Lenovo”, “HP”,“Microsoft Surface”, or “VMWare Virtual Machine” within the cell incolumn A. Depending on which of these strings it finds within theentire entry in column A’s cell, it should write one of these 4strings to the corresponding row