Hi All,
I was hoping someone could help me with the following questions:
I need to search a column for the following words, License, LIC and LICENSE. Once found I want to copy the entire string that contains the word and also two columns on the same row as the word was found and output all into a new worksheet.
I have attached an example worksheet.
But basically would be like following, for the below table I would like to search column D, and for any cell that contains, License, lic, LIC and LICENSE. I would like to copy that entire cell and two other cells on that row
-------A-------B----------C----------------D------------------------E-------------F---------G------------H
1-----SKU----Stocking----Part Number---Description---------------Category-----Source File---QTY----Extended QTY
2-----AGG-----qw--------123------------Enterprise Lic key 9100-----sw------------po--------5
3-----SFT-----qa--------112------------Nexus----------------------hw------------ws--------3-------2
4-----SUPS ---cis ---------67 ------------ENTERPRISE LIC KEY 9100---sw------------aps-------1
5-----STOK ---qqw-------673------------CPU License----------------hw------------eae-------2-------4
6-----SFT----ppch------412356----------MDS-----------------------hw-----------qrgqr-------2-------2
7-----NST----N1k-------726-------------CHASSIS LICENSE-----------hw-----------qrgq--------3
So for example the first and second entries on the new worksheet should look as follows:
-------A-------B----------C----------------D------------------------E-------------F---------G------------H
1-----SKU----Stocking----Part Number---Description---------------Category-----Source File---QTY----Extended QTY
2-----AGG-----qw--------123------------Enterprise Lic key 9100-----sw------------po--------5
5-----STOK ---qqw-------673------------CPU License----------------hw------------eae-------2-------4
Any help would be greatly appreciated
Bookmarks