dilligas2u
New Member
- Joined
- Mar 5, 2018
- Messages
- 7
Hope all can understand what I'm looking to do.
I have this sheet called Main
A B C
<colgroup><col style="mso-width-source:userset;mso-width-alt:1308;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:4522;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:3896;width:82pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:3555;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:3128;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2787;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:4551;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:3498;width:74pt" width="98"> </colgroup><tbody>
[TD="class: xl67, width: 37"] [/TD]
[TD="class: xl78, width: 127"]Part Number[/TD]
[TD="class: xl71, width: 110"]Cast Date[/TD]
[TD="class: xl72, width: 100"]Imp[/TD]
[TD="class: xl71, width: 88"]Heat[/TD]
[TD="class: xl71, width: 78"]Line[/TD]
[TD="class: xl71, width: 128"]Reason[/TD]
[TD="class: xl71, width: 98"]Stamp[/TD]
[TD="class: xl67"]1[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/3/2016[/TD]
[TD="class: xl73"]4[/TD]
[TD="class: xl67"]8[/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl76"]Shrink[/TD]
[TD="class: xl70"]Random[/TD]
[TD="class: xl67"]2[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/16/2016[/TD]
[TD="class: xl73"]4[/TD]
[TD="class: xl67"]9[/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl76"]Shrink[/TD]
[TD="class: xl69"]Random[/TD]
[TD="class: xl67"]3[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/21/2016[/TD]
[TD="class: xl73"]3[/TD]
[TD="class: xl67"]10[/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl76"]Shrink[/TD]
[TD="class: xl80"]00[/TD]
[TD="class: xl67"]4[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/21/2016[/TD]
[TD="class: xl73"]2[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl77"]Slag[/TD]
[TD="class: xl80"]00[/TD]
[TD="class: xl67"]5[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/6/2016[/TD]
[TD="class: xl73"]1[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl77"]Slag[/TD]
[TD="class: xl69"]Random
[/TD]
</tbody>
It has 700 rows and charts below that
What I am looking to do is copy entire row between dates to sheet 2018 and be able to keep all data from Main sheet
A B C
<colgroup><col style="mso-width-source:userset;mso-width-alt:1308;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:4522;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:3896;width:82pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:3555;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:3128;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2787;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:4551;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:3498;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:5575;width:118pt" width="157"> <col style="mso-width-source:userset;mso-width-alt:3470;width:73pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:3527;width:74pt" width="99"> </colgroup><tbody>
[TD="class: xl67, width: 37"]
[/TD]
[TD="class: xl74, width: 127"]Part Number[/TD]
[TD="class: xl69, width: 110"]Cast Date[/TD]
[TD="class: xl70, width: 100"]Imp[/TD]
[TD="class: xl69, width: 88"]Heat[/TD]
[TD="class: xl69, width: 78"]Line[/TD]
[TD="class: xl69, width: 128"]Reason[/TD]
[TD="class: xl69, width: 98"]Stamp[/TD]
[TD="class: xl78, width: 157"]Start Date[/TD]
[TD="class: xl79, width: 98"]End Date[/TD]
[TD="class: xl79, width: 99"]Total[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl77"]1/1/2018[/TD]
[TD="class: xl77"]3/8/2018[/TD]
[TD="class: xl76"]28[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl76"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl76"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl76"][/TD]
</tbody>
I have this sheet called Main
A B C
<colgroup><col style="mso-width-source:userset;mso-width-alt:1308;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:4522;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:3896;width:82pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:3555;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:3128;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2787;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:4551;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:3498;width:74pt" width="98"> </colgroup><tbody>
[TD="class: xl67, width: 37"] [/TD]
[TD="class: xl78, width: 127"]Part Number[/TD]
[TD="class: xl71, width: 110"]Cast Date[/TD]
[TD="class: xl72, width: 100"]Imp[/TD]
[TD="class: xl71, width: 88"]Heat[/TD]
[TD="class: xl71, width: 78"]Line[/TD]
[TD="class: xl71, width: 128"]Reason[/TD]
[TD="class: xl71, width: 98"]Stamp[/TD]
[TD="class: xl67"]1[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/3/2016[/TD]
[TD="class: xl73"]4[/TD]
[TD="class: xl67"]8[/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl76"]Shrink[/TD]
[TD="class: xl70"]Random[/TD]
[TD="class: xl67"]2[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/16/2016[/TD]
[TD="class: xl73"]4[/TD]
[TD="class: xl67"]9[/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl76"]Shrink[/TD]
[TD="class: xl69"]Random[/TD]
[TD="class: xl67"]3[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/21/2016[/TD]
[TD="class: xl73"]3[/TD]
[TD="class: xl67"]10[/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl76"]Shrink[/TD]
[TD="class: xl80"]00[/TD]
[TD="class: xl67"]4[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/21/2016[/TD]
[TD="class: xl73"]2[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl77"]Slag[/TD]
[TD="class: xl80"]00[/TD]
[TD="class: xl67"]5[/TD]
[TD="class: xl75"]1139395[/TD]
[TD="class: xl68"]9/6/2016[/TD]
[TD="class: xl73"]1[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]Hunter[/TD]
[TD="class: xl77"]Slag[/TD]
[TD="class: xl69"]Random
[/TD]
</tbody>
It has 700 rows and charts below that
What I am looking to do is copy entire row between dates to sheet 2018 and be able to keep all data from Main sheet
A B C
<colgroup><col style="mso-width-source:userset;mso-width-alt:1308;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:4522;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:3896;width:82pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:3555;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:3128;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2787;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:4551;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:3498;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:5575;width:118pt" width="157"> <col style="mso-width-source:userset;mso-width-alt:3470;width:73pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:3527;width:74pt" width="99"> </colgroup><tbody>
[TD="class: xl67, width: 37"]
[/TD]
[TD="class: xl74, width: 127"]Part Number[/TD]
[TD="class: xl69, width: 110"]Cast Date[/TD]
[TD="class: xl70, width: 100"]Imp[/TD]
[TD="class: xl69, width: 88"]Heat[/TD]
[TD="class: xl69, width: 78"]Line[/TD]
[TD="class: xl69, width: 128"]Reason[/TD]
[TD="class: xl69, width: 98"]Stamp[/TD]
[TD="class: xl78, width: 157"]Start Date[/TD]
[TD="class: xl79, width: 98"]End Date[/TD]
[TD="class: xl79, width: 99"]Total[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl77"]1/1/2018[/TD]
[TD="class: xl77"]3/8/2018[/TD]
[TD="class: xl76"]28[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl76"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl76"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl76"][/TD]
</tbody>