Deleting data on multiple sheets

[Matt40Forte]

Hi everyone,

I am wondering if someone can help me with an issue I've been having recently. I keep track of multiple metrics for people on multiple different reports, and was wondering if there was a way to delete these people and their data across each workbook without having to manually open up each workbook and delete them. For instance, I might have data on the same person in two separate workbooks as seen below. Is there a method I could use to search and delete all data on Joe Smith across all workbooks? Any help would be greatly appreciated.


[TABLE="width: 792"]
<colgroup><col width="167" style="width: 125pt; mso-width-source: userset; mso-width-alt: 6107;"> <col width="148" style="width: 111pt; mso-width-source: userset; mso-width-alt: 5412;"> <col width="131" style="width: 98pt; mso-width-source: userset; mso-width-alt: 4790;"> <col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4717;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <col width="152" style="width: 114pt; mso-width-source: userset; mso-width-alt: 5558;"> <col width="127" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;"> <tbody>[TR]
[TD="class: xl64, width: 167, bgcolor: #ED7D31"]Specialist[/TD]
[TD="class: xl64, width: 148, bgcolor: #ED7D31"]Leader[/TD]
[TD="class: xl64, width: 131, bgcolor: #ED7D31"]Team[/TD]
[TD="class: xl64, width: 129, bgcolor: #ED7D31"]Subteam[/TD]
[TD="class: xl64, width: 105, bgcolor: #ED7D31"]Region[/TD]
[TD="class: xl64, width: 97, bgcolor: #ED7D31"]Start Date[/TD]
[TD="class: xl64, width: 152, bgcolor: #ED7D31"]Title[/TD]
[TD="class: xl64, width: 127, bgcolor: #ED7D31"]BizDev?[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #FFD966"]Joe Smtih[/TD]
[TD="class: xl65, bgcolor: #FFD966"]John Smith[/TD]
[TD="class: xl65, bgcolor: #FFD966"]Team 1[/TD]
[TD="class: xl65, bgcolor: #FFD966"]Team 1a[/TD]
[TD="class: xl65, bgcolor: #FFD966"]Ohio[/TD]
[TD="class: xl66, bgcolor: #FFD966, align: right"]10/3/2016[/TD]
[TD="class: xl65, bgcolor: #FFD966"]Specialist[/TD]
[TD="class: xl65, bgcolor: #FFD966"]No[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 773"]
<colgroup><col width="140" style="width: 105pt; mso-width-source: userset; mso-width-alt: 5120;"> <col width="173" style="width: 130pt; mso-width-source: userset; mso-width-alt: 6326;"> <col width="128" style="width: 96pt; mso-width-source: userset; mso-width-alt: 4681;" span="3"> <col width="59" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2157;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;"> <col width="64" style="width: 48pt;" span="3"> <tbody>[TR]
[TD="class: xl73, width: 140, bgcolor: #EF5B2D"]Last, First[/TD]
[TD="class: xl73, width: 173, bgcolor: #EF5B2D"]Team Member[/TD]
[TD="class: xl73, width: 128, bgcolor: #EF5B2D"]Team Lead[/TD]
[TD="class: xl73, width: 128, bgcolor: #EF5B2D"]Region[/TD]
[TD="class: xl73, width: 128, bgcolor: #EF5B2D"]Site[/TD]
[TD="class: xl73, width: 59, bgcolor: #EF5B2D"]Hours[/TD]
[TD="class: xl73, width: 83, bgcolor: #EF5B2D"]MTD Dials[/TD]
[TD="class: xl73, width: 64, bgcolor: #EF5B2D"]DPH[/TD]
[TD="class: xl73, width: 64, bgcolor: #EF5B2D"]Assists[/TD]
[TD="class: xl73, width: 64, bgcolor: #EF5B2D"]PPH[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #8497B0"]Smith, Joe[/TD]
[TD="class: xl72, bgcolor: #E7E6E6"]Joe Smith[/TD]
[TD="class: xl68, bgcolor: #E7E6E6"]John Smith[/TD]
[TD="class: xl68, bgcolor: #E7E6E6"]Ohio[/TD]
[TD="class: xl68, bgcolor: #E7E6E6"]Cleveland[/TD]
[TD="class: xl69, bgcolor: #E7E6E6, align: right"]50.00[/TD]
[TD="class: xl67, bgcolor: white"]500[/TD]
[TD="class: xl71"]10.00[/TD]
[TD="class: xl70, bgcolor: #E7E6E6"]250[/TD]
[TD="class: xl71, bgcolor: #E7E6E6"]5.00[/TD]
[/TR]
</tbody>[/TABLE]