Data arrangement macro

[makinmomb]

I want to re arrange my data as follows , if i do manually it will take long
, cell reference A meaning on sheet 2

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]D3[/TD]
[TD="class: xl63, width: 64"]TO[/TD]
[TD="class: xl63, width: 64"]A1[/TD]
[/TR]
[TR]
[TD="class: xl63"]E3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A2[/TD]
[/TR]
[TR]
[TD="class: xl63"]J3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A3[/TD]
[/TR]
[TR]
[TD="class: xl63"]O3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A4[/TD]
[/TR]
[TR]
[TD="class: xl63"]N3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A5[/TD]
[/TR]
[TR]
[TD="class: xl63"]F3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A6[/TD]
[/TR]
[TR]
[TD="class: xl63"]G3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A7[/TD]
[/TR]
[TR]
[TD="class: xl63"]I3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A8[/TD]
[/TR]
[TR]
[TD="class: xl63"]H3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A9[/TD]
[/TR]
[TR]
[TD="class: xl63"]B3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A10[/TD]
[/TR]
[TR]
[TD="class: xl63"]K3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A11[/TD]
[/TR]
[TR]
[TD="class: xl63"]M3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A12[/TD]
[/TR]
[TR]
[TD="class: xl66"]C3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A13[/TD]
[/TR]
[TR]
[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl66"]W3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A14[/TD]
[/TR]
[TR]
[TD="class: xl66"]U3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A15[/TD]
[/TR]
[TR]
[TD="class: xl66"]V3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A16[/TD]
[/TR]
[TR]
[TD="class: xl66"]S3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A17[/TD]
[/TR]
[TR]
[TD="class: xl66"]T3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A18[/TD]
[/TR]
[TR]
[TD="class: xl66"]X3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A19[/TD]
[/TR]
[TR]
[TD="class: xl66"]AA3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A20[/TD]
[/TR]
[TR]
[TD="class: xl63"]Y3[/TD]
[TD="class: xl63"]TO[/TD]
[TD="class: xl63"]A21[/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

Rick please adjust this for me on special request

 

[makinmomb]

I need the following shifting automated

[TABLE="width: 128"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]D1[/TD]
[TD]B4[/TD]
[/TR]
[TR]
[TD]E1[/TD]
[TD]B5[/TD]
[/TR]
[TR]
[TD]F1[/TD]
[TD]B6[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]B7[/TD]
[/TR]
[TR]
[TD]K1[/TD]
[TD]B8[/TD]
[/TR]
[TR]
[TD]P1[/TD]
[TD]B9[/TD]
[/TR]
[TR]
[TD]N1[/TD]
[TD]B10[/TD]
[/TR]
[TR]
[TD]G1[/TD]
[TD]B11[/TD]
[/TR]
[TR]
[TD]H1[/TD]
[TD]B12[/TD]
[/TR]
[TR]
[TD]J1[/TD]
[TD]B13[/TD]
[/TR]
[TR]
[TD]I1[/TD]
[TD]B14[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]B15[/TD]
[/TR]
[TR]
[TD]L1[/TD]
[TD]B16[/TD]
[/TR]
[TR]
[TD]M1[/TD]
[TD]B17[/TD]
[/TR]
[TR]
[TD]C1[/TD]
[TD]B18[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]V1[/TD]
[TD]C20[/TD]
[/TR]
[TR]
[TD]T1[/TD]
[TD]C21[/TD]
[/TR]
[TR]
[TD]T2[/TD]
[TD]C22[/TD]
[/TR]
[TR]
[TD]R1[/TD]
[TD]C23[/TD]
[/TR]
[TR]
[TD]S1[/TD]
[TD]C24[/TD]
[/TR]
[TR]
[TD]Y1[/TD]
[TD]C25[/TD]
[/TR]
[TR]
[TD]W1[/TD]
[TD]C26[/TD]
[/TR]
[TR]
[TD]Z1[/TD]
[TD]C27[/TD]
[/TR]
[TR]
[TD]X1[/TD]
[TD]C28[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AA1[/TD]
[TD]C31[/TD]
[/TR]
[TR]
[TD]AC1[/TD]
[TD]B32[/TD]
[/TR]
[TR]
[TD]AB1[/TD]
[TD]C33[/TD]
[/TR]
[TR]
[TD]AE1[/TD]
[TD]B34[/TD]
[/TR]
[TR]
[TD]AF1[/TD]
[TD]B35[/TD]
[/TR]
[TR]
[TD]AG1[/TD]
[TD]B36[/TD]
[/TR]
[TR]
[TD]AO1[/TD]
[TD]C37[/TD]
[/TR]
[TR]
[TD]AL1[/TD]
[TD]C38[/TD]
[/TR]
[TR]
[TD]AM1[/TD]
[TD]C39[/TD]
[/TR]
[TR]
[TD]AN1[/TD]
[TD]C40[/TD]
[/TR]
[TR]
[TD]AD1[/TD]
[TD]B41[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AQ1[/TD]
[TD]B43[/TD]
[/TR]
[TR]
[TD]AR1[/TD]
[TD]B44[/TD]
[/TR]
[TR]
[TD]AS1[/TD]
[TD]B45[/TD]
[/TR]
[TR]
[TD]AT1[/TD]
[TD]B46[/TD]
[/TR]
[TR]
[TD]AU1[/TD]
[TD]B47[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AV1[/TD]
[TD]B50[/TD]
[/TR]
[TR]
[TD]AW1[/TD]
[TD]B51[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

Rick please adjust this for me on special request

If you are talking about what you asked in Message #8 , I am afraid I do not understand the question. Can you explain what you want in more detail please?

 

[makinmomb]

I need a macro on a blank file to do the following

Read file name file1 to shift data to file2 , both files on drive c in folder created Rick Magic ,
it should paste data in the format file2 is

 

[makinmomb]

[TABLE="width: 3328"]
<colgroup><col width="64" span="52" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]NO[/TD]
[TD="class: xl64, width: 64"]JOB NO[/TD]
[TD="class: xl64, width: 64"]CLEAR[/TD]
[TD="class: xl64, width: 64"]PRE[/TD]
[TD="class: xl64, width: 64"]OBL[/TD]
[TD="class: xl64, width: 64"]INV[/TD]
[TD="class: xl65, width: 64"]CLIENT[/TD]
[TD="class: xl65, width: 64"]CONTAINER[/TD]
[TD="class: xl65, width: 64"]W[/TD]
[TD="class: xl65, width: 64"]C[/TD]
[TD="class: xl66, width: 64"]DESTINATION[/TD]
[TD="class: xl66, width: 64"]TRUCK[/TD]
[TD="class: xl66, width: 64"]TRAIL[/TD]
[TD="class: xl66, width: 64"]DRIVER[/TD]
[TD="class: xl64, width: 64"]COMPANY[/TD]
[TD="class: xl63, width: 64"]DATE[/TD]
[TD="class: xl66, width: 64"]X[/TD]
[TD="class: xl66, width: 64"]TYRE F[/TD]
[TD="class: xl66, width: 64"]TYRE B[/TD]
[TD="class: xl66, width: 64"]T Q1[/TD]
[TD="class: xl66, width: 64"]T Q2[/TD]
[TD="class: xl66, width: 64"]SPARES[/TD]
[TD="class: xl66, width: 64"]F1[/TD]
[TD="class: xl66, width: 64"]F2[/TD]
[TD="class: xl66, width: 64"]F1Q[/TD]
[TD="class: xl66, width: 64"]F2Q[/TD]
[TD="class: xl66, width: 64"]POSHO[/TD]
[TD="class: xl66, width: 64"]POSHO[/TD]
[TD="class: xl66, width: 64"]POSHO[/TD]
[TD="class: xl66, width: 64"]PARK[/TD]
[TD="class: xl66, width: 64"]VIS[/TD]
[TD="class: xl66, width: 64"]R T[/TD]
[TD="class: xl66, width: 64"]BON[/TD]
[TD="class: xl66, width: 64"]RT[/TD]
[TD="class: xl66, width: 64"]COM[/TD]
[TD="class: xl66, width: 64"]CT[/TD]
[TD="class: xl66, width: 64"]INS[/TD]
[TD="class: xl66, width: 64"]CC1[/TD]
[TD="class: xl66, width: 64"]CC2[/TD]
[TD="class: xl66, width: 64"]CC3[/TD]
[TD="class: xl66, width: 64"]levy[/TD]
[TD="class: xl66, width: 64"]other[/TD]
[TD="class: xl66, width: 64"]whar[/TD]
[TD="class: xl66, width: 64"]port[/TD]
[TD="class: xl66, width: 64"]delivy[/TD]
[TD="class: xl66, width: 64"]demu[/TD]
[TD="class: xl66, width: 64"]other[/TD]
[TD="class: xl66, width: 64"]$ SALE[/TD]
[TD="class: xl66, width: 64"]$ SALE[/TD]
[TD="class: xl66, width: 64"]$ TOT[/TD]
[TD="class: xl66, width: 64"]$ PROF[/TD]
[TD="class: xl66, width: 64"]%[/TD]
[/TR]
[TR]
[TD="class: xl67"]1[/TD]
[TD="class: xl67"]TR-0722-18[/TD]
[TD="class: xl67"]TR[/TD]
[TD="class: xl68, align: center"]#######[/TD]
[TD="class: xl68, align: center"]#######[/TD]
[TD="class: xl68, align: center"]#######[/TD]
[TD="class: xl69"]MAISON GALAXY [/TD]
[TD="class: xl69"]TCNU1408646[/TD]
[TD="class: xl69"]4.9[/TD]
[TD="class: xl69"]40[/TD]
[TD="class: xl70"]LUBUMBASHI [/TD]
[TD="class: xl70"]T674BUX[/TD]
[TD="class: xl70"]T924DEQ [/TD]
[TD="class: xl69"]SAID YUSSUF KITENGE [/TD]
[TD="class: xl71"]AQUARIUS[/TD]
[TD="class: xl72"]#######[/TD]
[TD="class: xl73"]X[/TD]
[TD="class: xl74, align: right"]0[/TD]
[TD="class: xl74, align: right"]0[/TD]
[TD="class: xl70"]0[/TD]
[TD="class: xl70"]0[/TD]
[TD="class: xl74, align: right"]911000[/TD]
[TD="class: xl74, align: right"]3195000[/TD]
[TD="class: xl74, align: right"]1185000[/TD]
[TD="class: xl74, align: right"]1500[/TD]
[TD="class: xl74, align: right"]500[/TD]
[TD="class: xl74, align: right"]480000[/TD]
[TD="class: xl74, align: right"]250000[/TD]
[TD="class: xl73"]$50 [/TD]
[TD="class: xl73"]$30 [/TD]
[TD="class: xl73"]$100 [/TD]
[TD="class: xl73"]$356 [/TD]
[TD="class: xl73"]$90 [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl74, align: right"]214000[/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl74, align: right"]10000[/TD]
[TD="class: xl74, align: right"]42000[/TD]
[TD="class: xl74, align: right"]15000[/TD]
[TD="class: xl74, align: right"]26000[/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl75"]$180 [/TD]
[TD="class: xl75"]$117 [/TD]
[TD="class: xl75"]$39 [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl76, align: right"]$6,600 [/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl77, align: center"]#######[/TD]
[TD="class: xl77, align: center"]#######[/TD]
[TD="class: xl78, align: right"]43%[/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

[TABLE="width: 658"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]PRE[/TD]
[TD="align: right"]7-Jul[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]OBL[/TD]
[TD="align: right"]10-Jul[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]INV[/TD]
[TD="align: right"]7-Jul[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TRIP NO[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]LOCATION[/TD]
[TD]KASUMBALESA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DATE - TRUCK LOADING [/TD]
[TD="align: right"]1-Sep[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DRIVER NAME[/TD]
[TD]MARIDADI ABUTWALIBU LUKWARO [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CONSIGNEE & DESTINATION [/TD]
[TD]TESCO LTD [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CONT NO[/TD]
[TD]MSKU9984592[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CONT SIZE[/TD]
[TD]40[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]WEIGHT[/TD]
[TD]21.9[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]REF[/TD]
[TD]TR-0664-18[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TRUCK NO[/TD]
[TD]T444CZS[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TRAILER NO[/TD]
[TD]T172DAR[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]LOADED UNDER [/TD]
[TD]SIM [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]WORKSHOP SPARES[/TD]
[TD="align: right"]186[/TD]
[TD] 424,000[/TD]
[/TR]
[TR]
[TD]TYRES QTY FRONT[/TD]
[TD]X[/TD]
[TD] 2[/TD]
[/TR]
[TR]
[TD]TYRES QTY BACK[/TD]
[TD]X[/TD]
[TD] 2[/TD]
[/TR]
[TR]
[TD]TYRES FRONT VALUE[/TD]
[TD="align: right"]535[/TD]
[TD] 1,220,000[/TD]
[/TR]
[TR]
[TD]TYRES BACK VALUE [/TD]
[TD="align: right"]246[/TD]
[TD] 560,000[/TD]
[/TR]
[TR]
[TD]FUEL FROM INARA QTY[/TD]
[TD]X[/TD]
[TD="align: right"]1600[/TD]
[/TR]
[TR]
[TD]FUEL FROM INARA VALUE[/TD]
[TD="align: right"]1495[/TD]
[TD] 3,408,000[/TD]
[/TR]
[TR]
[TD]FUEL FROM TUNDUMA QTY AND VALUE[/TD]
[TD]X[/TD]
[TD] 500[/TD]
[/TR]
[TR]
[TD]FUEL FROM TUNDUMA VALUE[/TD]
[TD="align: right"]520[/TD]
[TD] 1,185,000[/TD]
[/TR]
[TR]
[TD]TOTAL FUEL TAKEN[/TD]
[TD]X[/TD]
[TD] 2,100[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]POSHO 1 DAR - GOING[/TD]
[TD="align: right"]211[/TD]
[TD] 480,000[/TD]
[/TR]
[TR]
[TD]POSHO 2 AT LOCATION[/TD]
[TD="align: right"]50[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD]POSHO 3 RETURN[/TD]
[TD="align: right"]110[/TD]
[TD] 250,000[/TD]
[/TR]
[TR]
[TD]VISA[/TD]
[TD="align: right"]0[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD]ROAD TOLL[/TD]
[TD="align: right"]356[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD]BOND[/TD]
[TD="align: right"]90[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD]LEVY[/TD]
[TD="align: right"]11[/TD]
[TD] 26,000[/TD]
[/TR]
[TR]
[TD]CITY COUNCIL - 1[/TD]
[TD="align: right"]4[/TD]
[TD] 10,000[/TD]
[/TR]
[TR]
[TD]CITY COUNCIL - 2[/TD]
[TD="align: right"]18[/TD]
[TD] 42,000[/TD]
[/TR]
[TR]
[TD]CITY COUNCIL - 3[/TD]
[TD="align: right"]7[/TD]
[TD] 15,000[/TD]
[/TR]
[TR]
[TD]PARKING FLAT EVERY TRIP[/TD]
[TD="align: right"]30[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]WHARFAGE[/TD]
[TD="align: right"]180[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD]PORT[/TD]
[TD="align: right"]117[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD]DELIVERY[/TD]
[TD="align: right"]39[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD]DEMU[/TD]
[TD="align: right"]0[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD]OTHER[/TD]
[TD="align: right"]0[/TD]
[TD] X [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TOTAL EXPENSES[/TD]
[TD="align: right"]4,129[/TD]
[TD]USD[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]5,600[/TD]
[TD]USD[/TD]
[/TR]
[TR]
[TD]SALES COPPER[/TD]
[TD] [/TD]
[TD]USD[/TD]
[/TR]
[TR]
[TD]PROFIT[/TD]
[TD="align: right"]1,471[/TD]
[TD]USD[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MARGIN[/TD]
[TD="align: right"]26%[/TD]
[TD] 2,280[/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

File 1 details into File 2 , i have mentioned what needs to be where , d1 from file 1 to B4 onto cell b4 , while pasting data to retain formats of file 2

[TABLE="width: 128"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]D1[/TD]
[TD]B4[/TD]
[/TR]
[TR]
[TD]E1[/TD]
[TD]B5[/TD]
[/TR]
[TR]
[TD]F1[/TD]
[TD]B6[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]B7[/TD]
[/TR]
[TR]
[TD]K1[/TD]
[TD]B8[/TD]
[/TR]
[TR]
[TD]P1[/TD]
[TD]B9[/TD]
[/TR]
[TR]
[TD]N1[/TD]
[TD]B10[/TD]
[/TR]
[TR]
[TD]G1[/TD]
[TD]B11[/TD]
[/TR]
[TR]
[TD]H1[/TD]
[TD]B12[/TD]
[/TR]
[TR]
[TD]J1[/TD]
[TD]B13[/TD]
[/TR]
[TR]
[TD]I1[/TD]
[TD]B14[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]B15[/TD]
[/TR]
[TR]
[TD]L1[/TD]
[TD]B16[/TD]
[/TR]
[TR]
[TD]M1[/TD]
[TD]B17[/TD]
[/TR]
[TR]
[TD]C1[/TD]
[TD]B18[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]V1[/TD]
[TD]C20[/TD]
[/TR]
[TR]
[TD]T1[/TD]
[TD]C21[/TD]
[/TR]
[TR]
[TD]T2[/TD]
[TD]C22[/TD]
[/TR]
[TR]
[TD]R1[/TD]
[TD]C23[/TD]
[/TR]
[TR]
[TD]S1[/TD]
[TD]C24[/TD]
[/TR]
[TR]
[TD]Y1[/TD]
[TD]C25[/TD]
[/TR]
[TR]
[TD]W1[/TD]
[TD]C26[/TD]
[/TR]
[TR]
[TD]Z1[/TD]
[TD]C27[/TD]
[/TR]
[TR]
[TD]X1[/TD]
[TD]C28[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AA1[/TD]
[TD]C31[/TD]
[/TR]
[TR]
[TD]AC1[/TD]
[TD]B32[/TD]
[/TR]
[TR]
[TD]AB1[/TD]
[TD]C33[/TD]
[/TR]
[TR]
[TD]AE1[/TD]
[TD]B34[/TD]
[/TR]
[TR]
[TD]AF1[/TD]
[TD]B35[/TD]
[/TR]
[TR]
[TD]AG1[/TD]
[TD]B36[/TD]
[/TR]
[TR]
[TD]AO1[/TD]
[TD]C37[/TD]
[/TR]
[TR]
[TD]AL1[/TD]
[TD]C38[/TD]
[/TR]
[TR]
[TD]AM1[/TD]
[TD]C39[/TD]
[/TR]
[TR]
[TD]AN1[/TD]
[TD]C40[/TD]
[/TR]
[TR]
[TD]AD1[/TD]
[TD]B41[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AQ1[/TD]
[TD]B43[/TD]
[/TR]
[TR]
[TD]AR1[/TD]
[TD]B44[/TD]
[/TR]
[TR]
[TD]AS1[/TD]
[TD]B45[/TD]
[/TR]
[TR]
[TD]AT1[/TD]
[TD]B46[/TD]
[/TR]
[TR]
[TD]AU1[/TD]
[TD]B47[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AV1[/TD]
[TD]B50[/TD]
[/TR]
[TR]
[TD]AW1[/TD]
[TD]B51[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

You seem to be posting a lot of data without any explanation and, as best i can tell, without any question related to them.

 

[makinmomb]

Rick if you can understand this , let me explain this again

I have two files

FILE 1
FILE 2

FILE 1 has details to go into FILE 2

FILE 1 data is vertical , FILE 2 is horizontal , i have quoted the cell shift from where to where

Example d1 from file 1 to go b4 of file 2

 

[Rick Rothstein]

I have two files

FILE 1
FILE 2

FILE 1 has details to go into FILE 2

FILE 1 data is vertical , FILE 2 is horizontal , i have quoted the cell shift from where to where

Example d1 from file 1 to go b4 of file 2

Are these files two different worksheets in the same workbook? Or are they two different workbooks? If two different workbooks, what sheets are the files on?