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>
</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>
</tbody>
I have this sheet called Main
A B C
Part Number | Cast Date | Imp | Heat | Line | Reason | Stamp | |
1 | 1139395 | 9/3/2016 | 4 | 8 | Hunter | Shrink | Random |
2 | 1139395 | 9/16/2016 | 4 | 9 | Hunter | Shrink | Random |
3 | 1139395 | 9/21/2016 | 3 | 10 | Hunter | Shrink | 00 |
4 | 1139395 | 9/21/2016 | 2 | Hunter | Slag | 00 | |
5 | 1139395 | 9/6/2016 | 1 | Hunter | Slag | Random |
<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>
</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
| Part Number | Cast Date | Imp | Heat | Line | Reason | Stamp | Start Date | End Date | Total |
1/1/2018 | 3/8/2018 | 28 | ||||||||
<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>
</tbody>