Find Matching Value In Other Worksheet and Create Chart

[ExcelAndExcel]

Hello,

If in worksheet 'A', each record contains a username column and columns for multiple days,
what would the VBA be to select the username in a row in worksheet 'A', find the corresponding row with that username in another worksheet, and
create a line chart, with the two rows being the two series to show trends over multiple days.

Then, if a user clicks another username in worksheet 'A', how can the previous chart be deleted and a new one created?

Thank you!

 

[ExcelAndExcel]

bump