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

N

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.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

E
  • Solved
combine data from two worksheets with similar data but different formats
Replies
6
Views
91
DanteAmor
DanteAmor
L
  • Question Question
VBA Macros Copying Value not formula
Replies
1
Views
221
Special-K99
S
G
  • Locked
  • Question Question
VBA Userform - Change from 1900 Date Format to Long Date
Replies
1
Views
58
Peter_SSs
Peter_SSs
G
  • Question Question
Format Pulled Data from Workbook into a Text Box
Replies
3
Views
47
Skyybot
Skyybot
S
  • Question Question
Creating a random sequence of items from a weighted list with no duplicates
Replies
6
Views
217
shg
shg

Forum statistics

Threads
1,223,885
Messages
6,175,183
Members
452,615
Latest member
bogeys2birdies

Share this page

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