Data Movement Between Sheets

crook_101

crook_101

Well-known Member
Joined
Oct 20, 2008
Messages
687
Hi,

Problem - I need to merge two sheets to prepare a data sheet for a mail merge.

I have laid out as best I can below and probably driven down into too much detail. I have tried a formula approach but the sheet just grinds to a halt with the number of index/match's required

WB1 Sheet1 (DTH Master) contains the base data that I need to append data to, layout example below that contains approx 2.5K rows:

Excel 2007<TABLE style="BORDER-RIGHT: #a6aab6 1px solid; BORDER-TOP: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BORDER-BOTTOM: #a6aab6 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL></COLGROUP><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0; TEXT-ALIGN: center"><TH></TH><TH>A</TH><TH>AY</TH><TH>AZ</TH><TH>BA</TH></TR></THEAD><TBODY><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">2</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Tech No</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Start of "paste in BA3 - column number 53 row 3</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center">162</TD><TD><<LOADS TD of<><TD>other data</TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center">198</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">5</TD><TD style="TEXT-ALIGN: center">243</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">6</TD><TD style="TEXT-ALIGN: center">1396</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR></TBODY></TABLE>
DTH Master​

I have hidden rows B>>AX for convenience of posting.

My second sheet, Detail, shown below contains approx 500K rows:

Excel 2007<TABLE style="BORDER-RIGHT: #a6aab6 1px solid; BORDER-TOP: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BORDER-BOTTOM: #a6aab6 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0; TEXT-ALIGN: center"><TH></TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>I</TH><TH>J</TH><TH>K</TH><TH>L</TH><TH>M</TH><TH>N</TH><TH>O</TH><TH>P</TH></TR></THEAD><TBODY><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Tech No</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Issued</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Cancelled</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Incomplete</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Unfulfilled</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Revisits</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Right First Time</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">RFT Score</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Completion Rate</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Revisit Rate</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Job Reference</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">Visit Date</TD><TD style="BORDER-LEFT: black 1px solid">Job Type</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">21</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">162</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">107417255</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">02/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Service</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">34</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">162</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">100.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">100.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">107433828</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">05/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">103</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">162</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">107669174</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">26/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">104</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">162</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">107669174</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">01/04/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">111</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">162</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">107712511</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">28/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">217</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">198</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">107378680</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">02/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">244</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">198</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">100.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">100.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">107459192</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">07/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Service</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">297</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">198</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">107634528</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">21/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">310</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">198</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">107628412</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">26/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">327</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">198</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">107658058</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">02/04/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">356</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">198</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">107893617</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">12/04/2011</TD><TD style="BORDER-LEFT: black 1px solid">Install</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">396</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1396</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">100.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">100.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">107390702</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">28/02/2011</TD><TD style="BORDER-LEFT: black 1px solid">Service</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">409</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1396</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">107437541</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">04/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Service</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">605</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1522</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">0.00%</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center"></TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">107332547</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">02/03/2011</TD><TD style="BORDER-LEFT: black 1px solid">Service</TD></TR></TBODY></TABLE>
Detail​

What I need to do for the merge is to align the detail data on the same rows as the DTH Master using the "tech number" column as an identifier (Access primary key).

Example below:

Excel 2007<TABLE style="BORDER-RIGHT: #a6aab6 1px solid; BORDER-TOP: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BORDER-BOTTOM: #a6aab6 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0; TEXT-ALIGN: center"><TH></TH><TH>A</TH><TH>AY</TH><TH>AZ</TH><TH>BA</TH><TH>BB</TH><TH>BC</TH><TH>BD</TH><TH>BE</TH><TH>BF</TH><TH>BG</TH><TH>BH</TH><TH>BI</TH><TH>BJ</TH><TH>BK</TH><TH>BL</TH><TH>BM</TH></TR></THEAD><TBODY><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">2</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Tech No</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Tech No</TD><TD>Issued</TD><TD>Cancelled</TD><TD>Incomplete</TD><TD>Unfulfilled</TD><TD>Revisits</TD><TD>Right First Time</TD><TD>RFT Score</TD><TD>Completion Rate</TD><TD>Revisit Rate</TD><TD>Job Reference</TD><TD>Visit Date</TD><TD>Job Type</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center">162</TD><TD><<LOADS TD of<><TD>other data</TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0.00%</TD><TD style="TEXT-ALIGN: right">0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107417255</TD><TD style="TEXT-ALIGN: right">02/03/2011</TD><TD>Service</TD></TR></TBODY></TABLE>
DTH Master​


Once this first row has been copied and pasted, I then need the next row of data pertaining to "162" to be pasted to the right of this on the same row, shown below but wuth a load of cells hidden for ease of viewing:

Excel 2007<TABLE style="BORDER-RIGHT: #a6aab6 1px solid; BORDER-TOP: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BORDER-BOTTOM: #a6aab6 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0; TEXT-ALIGN: center"><TH></TH><TH>A</TH><TH>AY</TH><TH>AZ</TH><TH>BA</TH><TH>BB</TH><TH>BM</TH><TH>BN</TH><TH>BO</TH><TH>BP</TH><TH>BQ</TH><TH>BR</TH><TH>BS</TH><TH>BT</TH><TH>BU</TH><TH>BV</TH><TH>BW</TH><TH>BX</TH><TH>BY</TH><TH>BZ</TH></TR></THEAD><TBODY><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">2</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Tech No</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Tech No</TD><TD>Issued</TD><TD>Job Type</TD><TD>Tech No</TD><TD>Issued</TD><TD>Cancelled</TD><TD>Incomplete</TD><TD>Unfulfilled</TD><TD>Revisits</TD><TD>Right First Time</TD><TD>RFT Score</TD><TD>Completion Rate</TD><TD>Revisit Rate</TD><TD>Job Reference</TD><TD>Visit Date</TD><TD>Job Type</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center">162</TD><TD><<loads of</TD><TD>other data</TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD>Service</TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0.00%</TD><TD style="TEXT-ALIGN: right">100.00%</TD><TD style="TEXT-ALIGN: right">100.00%</TD><TD style="TEXT-ALIGN: right">107433828</TD><TD style="TEXT-ALIGN: right">05/03/2011</TD><TD>Install</TD></TR></TBODY></TABLE>
DTH Master​


This process continues until all of the data for "162" has been pasted into row 3 then it begins again in row 4 pasting data for "198".

Couple of things I have checked:

  • i have pivoted the data to ensure there are sufficient columns to paste the data into
  • the identifiers are not solely numeric, there are some alpha/numerics in there
  • some individuals may not have any data to paste across
  • the number of rows to paste across is not a given and should be seen as being any variable
  • My coding skills are limited but I can ammend code to suit but I cannot write it from scratch to this extent (yet) and I just got lost using the macro recorder for this one
That is all:biggrin:

Seriously, if anyone can resolve this, 1 I will be mighily impressed and 2 I will be forever in your debt!!

Cheers,
Ian
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Crook 101,

Try this (first use only the sheet Detail):

Important: make a backup copy of your data (sheets Detail and DTH Master) before using the macro below.

1) Copy the code below.

Code: 
Sub NamesData_v4()
'
'Prg    : NamesData_v4
'Author : Markmzz
'Date   : 31/05/2011
'Version: 04
'
    'Sets the macro variables explicitly
    Dim LastRowL1, LastRowL2, LastColL1, NextCol As Long
    Dim RL1, RL2, CL1, CL2, NCL1, NCL2 As Long
    Dim myArrayL1, myArrayNL2, myArrayCL2 As Variant
 
    'Disable screen updating
    Application.ScreenUpdating = False
 
    'Determines the total number of rows in the first list
    LastRowL1 = Cells(Rows.Count, 1).End(xlUp).Row
 
    'Determines the total number of columns in the first list
    LastColL1 = Cells(1, Columns.Count).End(xlToLeft).Column
 
    'Stores the total number of columns in the first
    'list in variable NCL1
    NCL1 = LastColL1
 
    'Sort, in ascending order, the first list
    Range(Cells(2, 1), Cells(LastRowL1, LastColL1)).Sort _
        Key1:=Range("A1"), _
        Order1:=xlAscending
 
    'Sets the dimensions of the array corresponds
    'to the data from the first list
    ReDim myArrayL1(1 To LastRowL1, 1 To LastColL1)
 
    'Stores the data from the first list in the corresponding array
    myArrayL1 = Range(Cells(1, 1), Cells(LastRowL1, LastColL1))
 
    'Defines the starting column of the second list
    '(two columns to the right of first list)
    NextCol = LastColL1 + 2
 
    'Creates the second list starting column,a column without
    'repeating the data of the first column of the first list
    Range(Cells(1, 1), Cells(LastRowL1, 1)).AdvancedFilter _
        Action:=xlFilterCopy, _
        CopyToRange:=Range(Cells(1, NextCol).Address), _
        Unique:=True
    Cells(1, NextCol).Font.Bold = False
 
    'Determines the number of rows in the second list
    LastRowL2 = Cells(Rows.Count, NextCol).End(xlUp).Row
 
    'Defines the dimensions of the array corresponds to the
    'data in the first column of the second list
    ReDim myArrayL2(1 To LastRowL2, 1)
 
    'Stores the data in the first column of the second list in
    'the corresponding array
    myArrayL2 = Range(Cells(1, NextCol), Cells(LastRowL2, NextCol))
 
    'Determines the maximum number of repetitions of a single
    'data from the first column of the first list
    Cells(1, NextCol + 1).FormulaArray = "=Large(Countif(R2C1:R" & LastRowL1 & _
            "C1,R2C" & NextCol & ":R" & LastRowL2 & "C" & NextCol & "),1)"
 
    'Determines the number total of columns in the second list
    NCL2 = Cells(1, NextCol + 1).Value * NCL1
    'Defines the dimensions of the array corresponds to the data from the
    'second list
    ReDim myArrayCL2(1 To LastRowL2, 1 To NCL2)
 
    'Defines two and one as the current row and column numbers of the first list
    RL1 = 2
    CL1 = 1
 
    'Navigates the data in the field of the first column of the second list
    For RL2 = 2 To LastRowL2
        'Show the progress of the macro in the status bar
        Application.StatusBar = "Processing row " & RL2 & " of " & LastRowL2
 
        'Defines one with the current column number of the second list
        CL2 = 1
 
        'Navigates by data field of the first column of the first list that
        'are equal to the current field of the first column of the second list
        Do While myArrayL1(RL1, 1) = myArrayL2(RL2, 1)
            For CL1 = 1 To LastColL1
                'Fills the array to the second list
                myArrayCL2(RL2, CL2) = myArrayL1(RL1, CL1)
                CL2 = CL2 + 1
            Next CL1
 
            RL1 = RL1 + 1
            'Checks if the current line number of the first list is greater
            'than the total number of rows in the same list
            If RL1 > LastRowL1 Then
                Exit Do
                'Exits the loop
            End If
        Loop
    Next RL2
 
    'Populates the column labels from the second list
    For CL2 = 1 To NCL2
            CL1 = CL2 - Int((CL2 - 1) / (LastColL1)) * (LastColL1)
            myArrayCL2(1, CL2) = myArrayL1(1, CL1)
    Next CL2
    Range(Cells(1, NextCol), Cells(LastRowL2, NextCol + NCL2 - 1)) = myArrayCL2
 
    'Autofit the columns of 2nd List
    Cells(1, NextCol).CurrentRegion.EntireColumn.AutoFit
 
    'Enable screen updating
    Application.ScreenUpdating = True
 
    'Reset the Status Bar of the Excel
    Application.StatusBar = False
End Sub

2) Give a right-click in the Worksheet Tab that contains the list (sheet Detail) and choose View Code.

3) In VBA window that appears, choose Module on the Insert menu of the respective window.

4) Now, paste the code copied in step 1) and close the VBA window.

5) Again on the worksheet that contains the list (sheet Detail), activate the View tab, choose Macros in the Macros group.

6) In the Macro dialog box, select the name of the macro NamesData_v4 and click the Run button.

7) Finally, copy the data from the list created in the sheet Detail to the DTH Master worksheet.

Markmzz
 
Upvote 0
Hi Mark,

Many thanks for this but I am getting a runtime error at line:

Code: 
Range(Cells(1, NextCol), Cells(LastRowL2, NextCol + NCL2 - 1)) = myArrayCL2

3rd line from the bottom of your code.

Any thoughts??

Cheers,
Ian
 
Last edited:
Upvote 0
Crook_101,

Try this new code (No need of the step 7) - copy the data):

Important: make a backup copy of your data (sheets Detail and DTH Master) before using the macro below.

Code: 
Sub NamesData_v5()
'
'Prg    : NamesData_v5
'Author : Markmzz
'Date   : 01/06/2011
'Version: 05
'
    'Sets the macro variables explicitly
    Dim LastRowL1, LastRowL2, LastColL1, NextCol As Long
    Dim RL1, RL2, CL1, CL2, NLC1, NLC2, NCL1, NCL2 As Long
    Dim myArrayL1, myArrayNL2, myArrayCL2 As Variant
    Dim ws1, ws2 As Worksheet
 
    'Disable screen updating
    Application.ScreenUpdating = False
 
    'Store the reference of sheet Detail
    Set ws1 = Sheets("Detail")
 
    'Determines the total number of rows in the first list
    'Start in the column C (3)
    LastRowL1 = ws1.Cells(ws1.Rows.Count, 3).End(xlUp).Row
 
    'Determines the total number of columns in the first list
    'Start in the row 1
    LastColL1 = ws1.Cells(1, ws1.Columns.Count).End(xlToLeft).Column
 
    'Stores the total number of columns in the first
    'list in variable NCL1
    NCL1 = LastColL1 - 2
 
    'Sort, in ascending order, the first list
    Range(ws1.Cells(2, 3), ws1.Cells(LastRowL1, LastColL1)).Sort _
        Key1:=ws1.Range("C1"), _
        Order1:=xlAscending
 
    'Determines the total number of rows in the first list after sort
    'Start in the column C (3)
    LastRowL1 = ws1.Cells(ws1.Rows.Count, 3).End(xlUp).Row
 
    'Sets the dimensions of the array corresponds
    'to the data from the first list
    ReDim myArrayL1(1 To LastRowL1, 1 To NCL1)
 
    'Stores the data from the first list in the corresponding array
    myArrayL1 = ws1.Range(ws1.Cells(1, 3), ws1.Cells(LastRowL1, LastColL1))
 
    'Store the reference of sheet DTH Master
    Set ws2 = Sheets("DTH Master")
 
    'Determines the number of rows in the second list
    'Start in the column BA (53)
    LastRowL2 = ws2.Cells(ws2.Rows.Count, 53).End(xlUp).Row - 1
 
    'Defines the dimensions of the array corresponds to the
    'data in the first column of the second list
    ReDim myArrayL2(1 To LastRowL2, 1)
 
    'Stores the data in the first column of the second list in
    'the corresponding array - Start in the row 2 and column BA (53)
    myArrayL2 = ws2.Range(ws2.Cells(2, 53), ws2.Cells(LastRowL2 + 1, 53))
 
    'Determines the maximum number of repetitions of a single
    'data from the first column of the first list
    'Store in row 2 and column BB (54)
    ws2.Cells(2, 54).FormulaArray = "=Large(Countif(" & ws1.Name & "!R2C3:R" & LastRowL1 & _
            "C3,'" & ws2.Name & "'!R2C" & 53 & ":R" & LastRowL2 & "C" & 53 & "),1)"
 
    'Determines the number total of columns in the second list
    NCL2 = ws2.Cells(2, 54).Value * NCL1
 
    'Defines the dimensions of the array corresponds to the data from the
    'second list
    ReDim myArrayCL2(1 To LastRowL2, 1 To NCL2)
 
    'Defines two and one as the current row and column numbers of the first list
    RL1 = 2
    CL1 = 1
 
    'Navigates the data in the field of the first column of the second list
    For RL2 = 2 To LastRowL2
        'Show the progress of the macro in the status bar
        Application.StatusBar = "Processing row " & RL2 & " of " & LastRowL2
 
        'Defines one with the current column number of the second list
        CL2 = 1
 
        'Navigates by data field of the first column of the first list that
        'are equal to the current field of the first column of the second list
        Do While myArrayL1(RL1, 1) = myArrayL2(RL2, 1)
            For CL1 = 1 To LastColL1 - 2
                'Fills the array to the second list
                myArrayCL2(RL2, CL2) = myArrayL1(RL1, CL1)
                CL2 = CL2 + 1
            Next CL1
 
            RL1 = RL1 + 1
            'Checks if the current line number of the first list is greater
            'than the total number of rows in the same list
            If RL1 > LastRowL1 Then
                Exit Do
                'Exits the loop
            End If
        Loop
    Next RL2
 
    'Populates the column labels from the second list
    For CL2 = 1 To NCL2
            CL1 = CL2 - Int((CL2 - 1) / (LastColL1 - 2)) * (LastColL1 - 2)
            myArrayCL2(1, CL2) = myArrayL1(1, CL1)
    Next CL2
 
    'Fill the data of second list in the sheet DTH Master
    'Start in the row 2 and column BA (53)
    Range(ws2.Cells(2, 53), ws2.Cells(LastRowL2 + 1, 53 + NCL2 - 1)) = myArrayCL2
 
    'Autofit the columns of 2nd List
    'Start in the row 2 and column BA (53)
    ws2.Cells(2, 53).CurrentRegion.EntireColumn.AutoFit
 
    'Enable screen updating
    Application.ScreenUpdating = True
 
    'Reset the Status Bar of the Excel
    Application.StatusBar = False
 
    'Free memory of references of sheets
    Set ws1 = Nothing
    Set ws2 = Nothing
 
End Sub

<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH><TH>K</TH><TH>L</TH><TH>M</TH><TH>N</TH><TH>O</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold">Tech No</TD><TD style="FONT-WEIGHT: bold">Issued</TD><TD style="FONT-WEIGHT: bold">Cancelled</TD><TD style="FONT-WEIGHT: bold">Incomplete</TD><TD style="FONT-WEIGHT: bold">Unfulfilled</TD><TD style="FONT-WEIGHT: bold">Revisits</TD><TD style="FONT-WEIGHT: bold">Right First Time</TD><TD style="FONT-WEIGHT: bold">RFT Score</TD><TD style="FONT-WEIGHT: bold">Completion Rate</TD><TD style="FONT-WEIGHT: bold">Revisit Rate</TD><TD style="FONT-WEIGHT: bold">Job Reference</TD><TD style="FONT-WEIGHT: bold">Visit Date</TD><TD style="FONT-WEIGHT: bold">Job Type</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107417255</TD><TD style="TEXT-ALIGN: right">02/03/2011</TD><TD>Service</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD style="TEXT-ALIGN: right">107433828</TD><TD style="TEXT-ALIGN: right">05/03/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107669174</TD><TD style="TEXT-ALIGN: right">26/03/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107669174</TD><TD style="TEXT-ALIGN: right">01/04/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107712511</TD><TD style="TEXT-ALIGN: right">28/03/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">198</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107378680</TD><TD style="TEXT-ALIGN: right">02/03/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">198</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD style="TEXT-ALIGN: right">107459192</TD><TD style="TEXT-ALIGN: right">07/03/2011</TD><TD>Service</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">198</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107634528</TD><TD style="TEXT-ALIGN: right">21/03/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">198</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107628412</TD><TD style="TEXT-ALIGN: right">26/03/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">198</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107658058</TD><TD style="TEXT-ALIGN: right">02/04/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">198</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107893617</TD><TD style="TEXT-ALIGN: right">12/04/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1396</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD style="TEXT-ALIGN: right">107390702</TD><TD style="TEXT-ALIGN: right">28/02/2011</TD><TD>Service</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1396</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107437541</TD><TD style="TEXT-ALIGN: right">04/03/2011</TD><TD>Service</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1522</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107332547</TD><TD style="TEXT-ALIGN: right">02/03/2011</TD><TD>Service</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1522</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1522</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD>0.00%</TD><TD>0.00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107332547</TD><TD style="TEXT-ALIGN: right">02/03/2011</TD><TD>Service</TD></TR></TBODY></TABLE>Detail


<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>AY</TH><TH>AZ</TH><TH>BA</TH><TH>BB</TH><TH>BC</TH><TH>BD</TH><TH>BE</TH><TH>BF</TH><TH>BG</TH><TH>BH</TH><TH>BI</TH><TH>BJ</TH><TH>BK</TH><TH>BL</TH><TH>BM</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD>Tech No</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Tech No</TD><TD>Issued</TD><TD>Cancelled</TD><TD>Incomplete</TD><TD>Unfulfilled</TD><TD>Revisits</TD><TD>Right First Time</TD><TD>RFT Score</TD><TD>Completion Rate</TD><TD>Revisit Rate</TD><TD>Job Reference</TD><TD>Visit Date</TD><TD>Job Type</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">162</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0,00%</TD><TD style="TEXT-ALIGN: right">0,00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107417255</TD><TD style="TEXT-ALIGN: right">02/03/2011</TD><TD>Service</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right">198</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">198</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0,00%</TD><TD style="TEXT-ALIGN: right">0,00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107378680</TD><TD style="TEXT-ALIGN: right">02/03/2011</TD><TD>Install</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right">1396</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1396</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0,00%</TD><TD style="TEXT-ALIGN: right">100,00%</TD><TD style="TEXT-ALIGN: right">100,00%</TD><TD style="TEXT-ALIGN: right">107390702</TD><TD style="TEXT-ALIGN: right">28/02/2011</TD><TD>Service</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="TEXT-ALIGN: right">1522</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">1522</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0,00%</TD><TD style="TEXT-ALIGN: right">0,00%</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">107332547</TD><TD style="TEXT-ALIGN: right">02/03/2011</TD><TD>Service</TD></TR></TBODY></TABLE>
DTH Master



Markmzz
 
Upvote 0
Crook_101,

Sorry, there was an error in the previous code.

Try this:

Important: make a backup copy of your data (sheets Detail and DTH Master) before using the macro below.

Code: 
Sub NamesData_v5()
'
'Prg    : NamesData_v5
'Author : Markmzz
'Date   : 01/06/2011
'Version: 05
'
    'Sets the macro variables explicitly
    Dim LastRowL1, LastRowL2, LastColL1, NextCol As Long
    Dim RL1, RL2, CL1, CL2, NLC1, NLC2, NCL1, NCL2 As Long
    Dim myArrayL1, myArrayNL2, myArrayCL2 As Variant
    Dim ws1, ws2 As Worksheet
 
    'Disable screen updating
    Application.ScreenUpdating = False
 
    'Store the reference of sheet Detail
    Set ws1 = Sheets("Detail")
 
    'Determines the total number of rows in the first list
    'Start in the column C (3)
    LastRowL1 = ws1.Cells(ws1.Rows.Count, 3).End(xlUp).Row
 
    'Determines the total number of columns in the first list
    'Start in the row 1
    LastColL1 = ws1.Cells(1, ws1.Columns.Count).End(xlToLeft).Column
 
    'Stores the total number of columns in the first
    'list in variable NCL1
    NCL1 = LastColL1 - 2
 
    'Sort, in ascending order, the first list
    Range(ws1.Cells(2, 3), ws1.Cells(LastRowL1, LastColL1)).Sort _
        Key1:=ws1.Range("C1"), _
        Order1:=xlAscending
 
    'Determines the total number of rows in the first list after sort
    'Start in the column C (3)
    LastRowL1 = ws1.Cells(ws1.Rows.Count, 3).End(xlUp).Row
 
    'Sets the dimensions of the array corresponds
    'to the data from the first list
    ReDim myArrayL1(1 To LastRowL1, 1 To NCL1)
 
    'Stores the data from the first list in the corresponding array
    myArrayL1 = ws1.Range(ws1.Cells(1, 3), ws1.Cells(LastRowL1, LastColL1))
 
    'Store the reference of sheet DTH Master
    Set ws2 = Sheets("DTH Master")
 
    'Determines the number of rows in the second list
    'Start in the column BA (53)
    LastRowL2 = ws2.Cells(ws2.Rows.Count, 1).End(xlUp).Row - 1
 
    'Defines the dimensions of the array corresponds to the
    'data in the first column of the second list
    ReDim myArrayL2(1 To LastRowL2, 1)
 
    'Stores the data in the first column of the second list in
    'the corresponding array - Start in the row 2 and column BA (53)
    myArrayL2 = ws2.Range(ws2.Cells(2, 1), ws2.Cells(LastRowL2 + 1, 1))
 
    'Determines the maximum number of repetitions of a single
    'data from the first column of the first list
    'Store in row 2 and column BB (54)
    ws2.Cells(2, 54).FormulaArray = "=Large(Countif(" & ws1.Name & "!R2C3:R" & LastRowL1 & _
            "C3,'" & ws2.Name & "'!R2C" & 1 & ":R" & LastRowL2 & "C" & 1 & "),1)"
 
    'Determines the number total of columns in the second list
    NCL2 = ws2.Cells(2, 54).Value * NCL1
 
    'Defines the dimensions of the array corresponds to the data from the
    'second list
    ReDim myArrayCL2(1 To LastRowL2, 1 To NCL2)
 
    'Defines two and one as the current row and column numbers of the first list
    RL1 = 2
    CL1 = 1
 
    'Navigates the data in the field of the first column of the second list
    For RL2 = 2 To LastRowL2
        'Show the progress of the macro in the status bar
        Application.StatusBar = "Processing row " & RL2 & " of " & LastRowL2
 
        'Defines one with the current column number of the second list
        CL2 = 1
 
        'Navigates by data field of the first column of the first list that
        'are equal to the current field of the first column of the second list
        Do While myArrayL1(RL1, 1) = myArrayL2(RL2, 1)
            For CL1 = 1 To LastColL1 - 2
                'Fills the array to the second list
                myArrayCL2(RL2, CL2) = myArrayL1(RL1, CL1)
                CL2 = CL2 + 1
            Next CL1
 
            RL1 = RL1 + 1
            'Checks if the current line number of the first list is greater
            'than the total number of rows in the same list
            If RL1 > LastRowL1 Then
                Exit Do
                'Exits the loop
            End If
        Loop
    Next RL2
 
    'Populates the column labels from the second list
    For CL2 = 1 To NCL2
            CL1 = CL2 - Int((CL2 - 1) / (LastColL1 - 2)) * (LastColL1 - 2)
            myArrayCL2(1, CL2) = myArrayL1(1, CL1)
    Next CL2
 
    'Fill the data of second list in the sheet DTH Master
    'Start in the row 2 and column BA (53)
    Range(ws2.Cells(2, 53), ws2.Cells(LastRowL2 + 1, 53 + NCL2 - 1)) = myArrayCL2
 
    'Autofit the columns of 2nd List
    'Start in the row 2 and column BA (53)
    ws2.Cells(2, 53).CurrentRegion.EntireColumn.AutoFit
 
    'Enable screen updating
    Application.ScreenUpdating = True
 
    'Reset the Status Bar of the Excel
    Application.StatusBar = False
 
    'Free memory of references of sheets
    Set ws1 = Nothing
    Set ws2 = Nothing
 
End Sub

Markmzz
 
Upvote 0
Hi Mark,

Getting closer....the result in the sheet is picking the headers up but nothing else....

Excel 2007<TABLE style="BORDER-RIGHT: #a6aab6 1px solid; BORDER-TOP: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BORDER-BOTTOM: #a6aab6 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0; TEXT-ALIGN: center"><TH></TH><TH>BA</TH><TH>BB</TH><TH>BC</TH><TH>BD</TH><TH>BE</TH><TH>BF</TH><TH>BG</TH><TH>BH</TH><TH>BI</TH><TH>BJ</TH><TH>BK</TH><TH>BL</TH><TH>BM</TH><TH>BN</TH><TH>BO</TH><TH>BP</TH></TR></THEAD><TBODY><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">2</TD><TD>Tech No</TD><TD>Issued</TD><TD>Cancelled</TD><TD>Incomplete</TD><TD>Unfulfilled</TD><TD>Completed</TD><TD>Revisits</TD><TD>Right First Time</TD><TD>RFT Score</TD><TD>Completion Rate</TD><TD>Revisit Rate</TD><TD>Job Reference</TD><TD>Visit Date</TD><TD>Job Type</TD><TD style="TEXT-ALIGN: right"></TD><TD>Install</TD></TR></TBODY></TABLE>
DTH Master​


Thanks for your help so far,
Ian
 
Upvote 0
crook_101 said:
Hi Mark,

Getting closer....the result in the sheet is picking the headers up but nothing else....

Thanks for your help so far,
Ian
Click to expand...

Crook_101,

You could give me a workbook with fictitious data so that I can do some testing?

Markmzz
 
Upvote 0
crook_101,


Sample worksheets before the macro:


Excel Workbook
CDEFGHIJKLMNO
1Tech NoIssuedCancelledIncompleteUnfulfilledRevisitsRight First TimeRFT ScoreCompletion RateRevisit RateJob ReferenceVisit DateJob Type
21621100.00%0.00%1074172552/3/2011Service
316210100.00%100.00%100.00%1074338285/3/2011Install
41621100.00%0.00%10766917426/03/2011Install
516210100.00%0.00%1076691741/4/2011Install
616210100.00%0.00%10771251128/03/2011Install
71981100.00%0.00%1073786802/3/2011Install
819810100.00%100.00%100.00%1074591927/3/2011Service
91981100.00%0.00%10763452821/03/2011Install
101981100.00%0.00%10762841226/03/2011Install
1119810100.00%0.00%1076580582/4/2011Install
121981100.00%0.00%10789361712/4/2011Install
13139610100.00%100.00%100.00%10739070228/02/2011Service
1413961100.00%0.00%1074375414/3/2011Service
15152210100.00%0.00%1073325472/3/2011Service
16
Detail





Excel Workbook
ABCBABBBCBDBEBFBGBHBIBJBKBLBMBN
2Tech No
3162other data
4198
5243
61396
71522
8
DTH Master





After the macro (not all columns to the right are shown for brevity):


Excel Workbook
ABCBABBBCBDBEBFBGBHBIBJBKBLBM
2Tech NoTech NoIssuedCancelledIncompleteUnfulfilledRevisitsRight First TimeRFT ScoreCompletion RateRevisit RateJob ReferenceVisit DateJob Type
3162other data1621100.00%0.00%1074172552/3/2011Service
41981981100.00%0.00%1073786802/3/2011Install
5243
61396139610100.00%100.00%100.00%10739070228/02/2011Service
71522152210100.00%0.00%1073325472/3/2011Service
8
DTH Master





Excel Workbook
BNBOBPBQBRBSBTBUBVBWBXBYBZ
2Tech NoIssuedCancelledIncompleteUnfulfilledRevisitsRight First TimeRFT ScoreCompletion RateRevisit RateJob ReferenceVisit DateJob Type
316210100.00%100.00%100.00%1074338285/3/2011Install
419810100.00%100.00%100.00%1074591927/3/2011Service
5
613961100.00%0.00%1074375414/3/2011Service
7
8
DTH Master





Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).


1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.


Code: 
Option Explicit
Sub UpdateDTHMaster()
' hiker95, 06/01/2011
' http://www.mrexcel.com/forum/showthread.php?t=554083
Dim wM As Worksheet, wD As Worksheet
Dim c As Range, firstaddress As String
Dim LR As Long, a As Long, NC As Long
Application.ScreenUpdating = False
Set wM = Worksheets("DTH Master")
Set wD = Worksheets("Detail")
LR = wM.Cells(Rows.Count, 1).End(xlUp).Row
For a = 3 To LR Step 1
  NC = 53
  firstaddress = ""
  With wD.Columns(3)
    Set c = .Find(wM.Cells(a, 1), LookIn:=xlValues, LookAt:=xlWhole)
    If Not c Is Nothing Then
      firstaddress = c.Address
      Do
        wD.Range("C1:O1").Copy wM.Cells(2, NC)
        wD.Range("C" & c.Row).Resize(, 13).Copy wM.Cells(a, NC)
        NC = NC + 13
        Set c = .FindNext(c)
      Loop While Not c Is Nothing And c.Address <> firstaddress
    End If
  End With
Next a
wM.UsedRange.Columns.AutoFit
wM.Activate
Application.ScreenUpdating = True
End Sub


Before you use the macro, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm


Then run the UpdateDTHMaster macro.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V
E
  • Question Question
VBA code clean up
Replies
9
Views
573
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
J
  • Question Question
Copy Picture - VBA
2
Replies
10
Views
201
Logit
Logit

Forum statistics

Threads
1,224,518
Messages
6,179,258
Members
452,901
Latest member
LisaGo

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