ExcelAndExcel
New Member
- Joined
- Nov 15, 2021
- Messages
- 3
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!
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!