Flowchart for Automated Excel Product Name Matching and Highlighting
1 Report
Flowchart for Automated Excel Product Name Matching and Highlighting
Related Recommendations
Other works by the author
Outline/Content
See more
Find 'Product Name' column in Sheet0
Yes
Add to matched list & Write part in adjacent cell
End
Is match_found true?
No
Did user click Yes?
NO
Inner Loop End: Next part
Highlight cell color
Update MaxList record
Is cell value not empty?
Store Sheet1 Col A into Dictionary
Outer Loop Start :Iterate through Sheet0 Rows
Start
MsgBox: 'Do you want to clear cell color & removed names?'
Outer Loop End: Next row
Call Subprocess: ClearCells
Does part exist in Dictionary?
Clear cell color
Write 'Matched Products' in header & Set Font Bold
Split cell value by semicolon (;)
MsgBox: 'Completed'
Inner Loop start: Iterate through split values
文章
Is current array size > MaxList?
Collect
0 Comments
Next Page