Updating Charts and Ranges Using VBA

[5150]

All,

I need help to modify the code below to make both charts use the same Header(s) highlighted in yellow on Row 6 of the attached xl file each time the code updates the source ranges. I appreciate your help.

Please Login or Register  to view this content.

[5150]

I updated the code above to reflect the macro procedure inside the xl file attached for better understanding of the task.

[Andy Pope]

Please Login or Register  to view this content.

[5150]

Works perfect. Thank you so much!