Copy data from specific named worksheets and combine on a single worksheet

NHagedorn

New Member
Joined
May 11, 2012
Messages
37
Office Version
  1. 365
Platform
  1. Windows
Hello all. First post/attempts at this VBA. I have had no luck copying and pasting every code I could find... either they copy data from every page, have errors, or require some toolkit.

I'm trying to combine all data from two different sheets XPO, and DDD into one sheet CDR. I'm also attempting to add either XPO or DDD to the data row depending on which sheet they came from.

XPO is a copy and paste of sheet OTHER, along with summations.

DDD is also a copy and paste of sheet MORE, along with summations.

XPO and DDD were developed for the purpose of setting up matching data and headers, and summations.

Desired Finished Product SHEET CDR

[TABLE="width: 262"]
<tbody>[TR]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]ID
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]NAME
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]Volume
[/TD]
[TD="class: xl66, width: 94, bgcolor: #D9D9D9"]Sheet Name
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]Q SUM
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]111
[/TD]
[TD="class: xl67, bgcolor: transparent"]Bob
[/TD]
[TD="class: xl67, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]19
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]222
[/TD]
[TD="class: xl67, bgcolor: transparent"]May
[/TD]
[TD="class: xl67, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]333
[/TD]
[TD="class: xl67, bgcolor: transparent"]Mary
[/TD]
[TD="class: xl67, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]444
[/TD]
[TD="class: xl67, bgcolor: transparent"]Frank
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]37
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]555
[/TD]
[TD="class: xl67, bgcolor: transparent"]John
[/TD]
[TD="class: xl67, bgcolor: transparent"]5
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]26
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]666
[/TD]
[TD="class: xl67, bgcolor: transparent"]Steve
[/TD]
[TD="class: xl67, bgcolor: transparent"]6
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]19
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]777
[/TD]
[TD="class: xl67, bgcolor: transparent"]Larry
[/TD]
[TD="class: xl67, bgcolor: transparent"]7
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]888
[/TD]
[TD="class: xl67, bgcolor: transparent"]Walt
[/TD]
[TD="class: xl67, bgcolor: transparent"]8
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]18
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]999
[/TD]
[TD="class: xl67, bgcolor: transparent"]Buck
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]18
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]aaa
[/TD]
[TD="class: xl67, bgcolor: transparent"]Smith
[/TD]
[TD="class: xl67, bgcolor: transparent"]11
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]12
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]bbb
[/TD]
[TD="class: xl67, bgcolor: transparent"]Joy
[/TD]
[TD="class: xl67, bgcolor: transparent"]22
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]21
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ccc
[/TD]
[TD="class: xl67, bgcolor: transparent"]Carly
[/TD]
[TD="class: xl67, bgcolor: transparent"]33
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kristin
[/TD]
[TD="class: xl67, bgcolor: transparent"]44
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]37
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]eee
[/TD]
[TD="class: xl67, bgcolor: transparent"]Bennett
[/TD]
[TD="class: xl67, bgcolor: transparent"]55
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]29
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]fff
[/TD]
[TD="class: xl67, bgcolor: transparent"]Suzy
[/TD]
[TD="class: xl67, bgcolor: transparent"]66
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ggg
[/TD]
[TD="class: xl67, bgcolor: transparent"]Tracy
[/TD]
[TD="class: xl67, bgcolor: transparent"]77
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]hhh
[/TD]
[TD="class: xl67, bgcolor: transparent"]Amy
[/TD]
[TD="class: xl67, bgcolor: transparent"]88
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]16
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]iii
[/TD]
[TD="class: xl67, bgcolor: transparent"]Wendy
[/TD]
[TD="class: xl67, bgcolor: transparent"]99
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]19
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]jjj
[/TD]
[TD="class: xl67, bgcolor: transparent"]Lauren
[/TD]
[TD="class: xl67, bgcolor: transparent"]12
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]32
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]kkk
[/TD]
[TD="class: xl67, bgcolor: transparent"]Cole
[/TD]
[TD="class: xl67, bgcolor: transparent"]13
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]27
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]lll
[/TD]
[TD="class: xl67, bgcolor: transparent"]Karen
[/TD]
[TD="class: xl67, bgcolor: transparent"]14
[/TD]
[TD="class: xl67, bgcolor: transparent"]XPO
[/TD]
[TD="class: xl67, bgcolor: transparent"]18
[/TD]
[/TR]
</tbody>[/TABLE]

DDD SHEET
[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]ID
[/TD]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]NAME
[/TD]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]Volume
[/TD]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]Q Sum
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]111
[/TD]
[TD="class: xl66, bgcolor: transparent"]Bob
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]19
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]222
[/TD]
[TD="class: xl66, bgcolor: transparent"]May
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]25
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]333
[/TD]
[TD="class: xl66, bgcolor: transparent"]Mary
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]25
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]444
[/TD]
[TD="class: xl66, bgcolor: transparent"]Frank
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]37
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]555
[/TD]
[TD="class: xl66, bgcolor: transparent"]John
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]26
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]666
[/TD]
[TD="class: xl66, bgcolor: transparent"]Steve
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]19
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]777
[/TD]
[TD="class: xl66, bgcolor: transparent"]Larry
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]25
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]888
[/TD]
[TD="class: xl66, bgcolor: transparent"]Walt
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]18
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]999
[/TD]
[TD="class: xl66, bgcolor: transparent"]Buck
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]18
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
</tbody>[/TABLE]

MORE SHEET
[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]ID
[/TD]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]Item #
[/TD]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]NAME
[/TD]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]Volume
[/TD]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"]Q1
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Q2
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Q3
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Q4
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]111
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6685
[/TD]
[TD="class: xl66, bgcolor: transparent"]Bob
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]222
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5643
[/TD]
[TD="class: xl66, bgcolor: transparent"]May
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]333
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]245242
[/TD]
[TD="class: xl66, bgcolor: transparent"]Mary
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]444
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7697
[/TD]
[TD="class: xl66, bgcolor: transparent"]Frank
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]23
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]555
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4674
[/TD]
[TD="class: xl66, bgcolor: transparent"]John
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]666
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2424
[/TD]
[TD="class: xl66, bgcolor: transparent"]Steve
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]777
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]95797
[/TD]
[TD="class: xl66, bgcolor: transparent"]Larry
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]888
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]245245
[/TD]
[TD="class: xl66, bgcolor: transparent"]Walt
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]999
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]244
[/TD]
[TD="class: xl66, bgcolor: transparent"]Buck
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6
[/TD]
[/TR]
</tbody>[/TABLE]

XPO SHEET
[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]ID
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]NAME
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]Volume
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]QSUM
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]aaa
[/TD]
[TD="class: xl67, bgcolor: transparent"]Smith
[/TD]
[TD="class: xl67, bgcolor: transparent"]11
[/TD]
[TD="class: xl67, bgcolor: transparent"]12
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]bbb
[/TD]
[TD="class: xl67, bgcolor: transparent"]Joy
[/TD]
[TD="class: xl67, bgcolor: transparent"]22
[/TD]
[TD="class: xl67, bgcolor: transparent"]21
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ccc
[/TD]
[TD="class: xl67, bgcolor: transparent"]Carly
[/TD]
[TD="class: xl67, bgcolor: transparent"]33
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kristin
[/TD]
[TD="class: xl67, bgcolor: transparent"]44
[/TD]
[TD="class: xl67, bgcolor: transparent"]37
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]eee
[/TD]
[TD="class: xl67, bgcolor: transparent"]Bennett
[/TD]
[TD="class: xl67, bgcolor: transparent"]55
[/TD]
[TD="class: xl67, bgcolor: transparent"]29
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]fff
[/TD]
[TD="class: xl67, bgcolor: transparent"]Suzy
[/TD]
[TD="class: xl67, bgcolor: transparent"]66
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ggg
[/TD]
[TD="class: xl67, bgcolor: transparent"]Tracy
[/TD]
[TD="class: xl67, bgcolor: transparent"]77
[/TD]
[TD="class: xl67, bgcolor: transparent"]25
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]hhh
[/TD]
[TD="class: xl67, bgcolor: transparent"]Amy
[/TD]
[TD="class: xl67, bgcolor: transparent"]88
[/TD]
[TD="class: xl67, bgcolor: transparent"]16
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]iii
[/TD]
[TD="class: xl67, bgcolor: transparent"]Wendy
[/TD]
[TD="class: xl67, bgcolor: transparent"]99
[/TD]
[TD="class: xl67, bgcolor: transparent"]19
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]jjj
[/TD]
[TD="class: xl67, bgcolor: transparent"]Lauren
[/TD]
[TD="class: xl67, bgcolor: transparent"]12
[/TD]
[TD="class: xl67, bgcolor: transparent"]32
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]kkk
[/TD]
[TD="class: xl67, bgcolor: transparent"]Cole
[/TD]
[TD="class: xl67, bgcolor: transparent"]13
[/TD]
[TD="class: xl67, bgcolor: transparent"]27
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]lll
[/TD]
[TD="class: xl67, bgcolor: transparent"]Karen
[/TD]
[TD="class: xl67, bgcolor: transparent"]14
[/TD]
[TD="class: xl67, bgcolor: transparent"]18
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, bgcolor: transparent"]0
[/TD]
[/TR]
</tbody>[/TABLE]

OTHER SHEET
[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]ID
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]NAME
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]Address
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]Volume
[/TD]
[TD="class: xl66, width: 64, bgcolor: #D9D9D9"]Q1
[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]Q2
[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]Q3
[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]Q4
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]aaa
[/TD]
[TD="class: xl67, bgcolor: transparent"]Smith
[/TD]
[TD="class: xl67, bgcolor: transparent"]street
[/TD]
[TD="class: xl67, bgcolor: transparent"]11
[/TD]
[TD="class: xl67, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]5
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]bbb
[/TD]
[TD="class: xl67, bgcolor: transparent"]Joy
[/TD]
[TD="class: xl67, bgcolor: transparent"]2 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]22
[/TD]
[TD="class: xl67, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]6
[/TD]
[TD="class: xl67, bgcolor: transparent"]8
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ccc
[/TD]
[TD="class: xl67, bgcolor: transparent"]Carly
[/TD]
[TD="class: xl67, bgcolor: transparent"]3 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]33
[/TD]
[TD="class: xl67, bgcolor: transparent"]5
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]7
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ddd
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kristin
[/TD]
[TD="class: xl67, bgcolor: transparent"]4 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]44
[/TD]
[TD="class: xl67, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]8
[/TD]
[TD="class: xl67, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]23
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]eee
[/TD]
[TD="class: xl67, bgcolor: transparent"]Bennett
[/TD]
[TD="class: xl67, bgcolor: transparent"]5 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]55
[/TD]
[TD="class: xl67, bgcolor: transparent"]7
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[TD="class: xl67, bgcolor: transparent"]6
[/TD]
[TD="class: xl67, bgcolor: transparent"]7
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]fff
[/TD]
[TD="class: xl67, bgcolor: transparent"]Suzy
[/TD]
[TD="class: xl67, bgcolor: transparent"]6 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]66
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]5
[/TD]
[TD="class: xl67, bgcolor: transparent"]7
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ggg
[/TD]
[TD="class: xl67, bgcolor: transparent"]Tracy
[/TD]
[TD="class: xl67, bgcolor: transparent"]7 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]77
[/TD]
[TD="class: xl67, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]5
[/TD]
[TD="class: xl67, bgcolor: transparent"]8
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]hhh
[/TD]
[TD="class: xl67, bgcolor: transparent"]Amy
[/TD]
[TD="class: xl67, bgcolor: transparent"]8 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]88
[/TD]
[TD="class: xl67, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]6
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]iii
[/TD]
[TD="class: xl67, bgcolor: transparent"]Wendy
[/TD]
[TD="class: xl67, bgcolor: transparent"]9 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]99
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]5
[/TD]
[TD="class: xl67, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]7
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]jjj
[/TD]
[TD="class: xl67, bgcolor: transparent"]Lauren
[/TD]
[TD="class: xl67, bgcolor: transparent"]11 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]12
[/TD]
[TD="class: xl67, bgcolor: transparent"]8
[/TD]
[TD="class: xl67, bgcolor: transparent"]7
[/TD]
[TD="class: xl67, bgcolor: transparent"]8
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]kkk
[/TD]
[TD="class: xl67, bgcolor: transparent"]Cole
[/TD]
[TD="class: xl67, bgcolor: transparent"]12 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]13
[/TD]
[TD="class: xl67, bgcolor: transparent"]6
[/TD]
[TD="class: xl67, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]lll
[/TD]
[TD="class: xl67, bgcolor: transparent"]Karen
[/TD]
[TD="class: xl67, bgcolor: transparent"]13 street
[/TD]
[TD="class: xl67, bgcolor: transparent"]14
[/TD]
[TD="class: xl67, bgcolor: transparent"]9
[/TD]
[TD="class: xl67, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]4
[/TD]
[/TR]
</tbody>[/TABLE]



https://drive.google.com/file/d/1MPj33ekjQU564sgNUnx0s7h5V6Hr_Umf/view?usp=sharing

I believe I need the data on the CDR sheet to be values because further manipulation is required.

Thank you for any and all assistance.
 
I will need to do additional manipulations (more cut and paste, summations) to the data on the CDR sheet. So I don't think I can use a VBA that creates a new summary sheet every time which seems to be what most vba's do. Would need it to clear the old data, placing new data.
 
Upvote 0
So I think I figured it out/found what I was looking for... Seems to work :)

Sub Better()
Application.ScreenUpdating = False
Dim wsCDR As Worksheet
Dim LastRowWs As Long
Dim LastRowCDR As Long
Dim StartRowCDR As Long

Set wsCDR = ThisWorkbook.Worksheets("CDR")
LastRowCDR = wsCDR.Cells(wsCDR.Rows.Count, "A").End(xlUp).Row + 1
wsCDR.Range("A2:R" & LastRowCDR).Clear

For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "CDR" And ws.Name <> "Other" And ws.Name <> "More" Then
LastRowWs = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
StartRowCDR = wsCDR.Cells(wsCDR.Rows.Count, "A").End(xlUp).Row + 1 'first empty row
ws.Range("A2:R" & LastRowWs).Copy Destination:=wsCDR.Range("A" & StartRowCDR)
LastRowCDR = wsCDR.Cells(wsCDR.Rows.Count, "A").End(xlUp).Row
wsCDR.Range("E" & StartRowCDR & ":E" & LastRowCDR) = ws.Name
End If
Next
Application.ScreenUpdating = True
End Sub


One issue though.... how do I get it to not copy the zeros from when I initially set up the copy and pastes to XPO and DDD sheet?
 
Upvote 0

Forum statistics

Threads
1,226,871
Messages
6,193,448
Members
453,800
Latest member
dmwass57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top