I have a worksheet similar to below, but with many more rows. What I would like to do is to take the information only from the columns ID, Name, and Due Date to the second worksheet when the due date is between 6 months (+190 days) and 2 months (+70 days) from today's date.
[TABLE="class: s90z9tc-19 iDFCDm"]
<thead>[TR="class: s90z9tc-20 eCOxQD"]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:2084;width:43pt" width="57"> <col style="mso-width-source:userset;mso-width-alt:2925;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:6912;width:142pt" width="189"> <col style="mso-width-source:userset;mso-width-alt:2084;width:43pt" width="57"> <col style="mso-width-source:userset;mso-width-alt:1901;width:39pt" width="52"> <col style="mso-width-source:userset;mso-width-alt:6912;width:142pt" width="189"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> </colgroup><tbody>
[TD="class: xl71, width: 57"] #[/TD]
[TD="class: xl73, width: 80"]ID[/TD]
[TD="class: xl72, width: 189"]Name[/TD]
[TD="class: xl72, width: 57"]Flags [/TD]
[TD="class: xl72, width: 52"]Code[/TD]
[TD="class: xl72, width: 189"]Classification[/TD]
[TD="class: xl72, width: 87"]Item Date[/TD]
[TD="class: xl76, width: 68"]Due Date[/TD]
[TD="class: xl66, align: right"]101[/TD]
[TD="class: xl66, align: right"]5563[/TD]
[TD="class: xl67"]J. Smith[/TD]
[TD="class: xl67"]A[/TD]
[TD="class: xl67"]Y[/TD]
[TD="class: xl67"]Office 13[/TD]
[TD="class: xl70, align: right"]11/15/2018[/TD]
[TD="class: xl74"]2/7/2019[/TD]
[TD="class: xl68, align: right"]102[/TD]
[TD="class: xl68, align: right"]1257[/TD]
[TD="class: xl65"]B. Wallace[/TD]
[TD="class: xl65"]V[/TD]
[TD="class: xl65"]Y[/TD]
[TD="class: xl65"]Cube 7[/TD]
[TD="class: xl69, align: right"]8/1/2018[/TD]
[TD="class: xl75"]9/15/2019[/TD]
[TD="class: xl68, align: right"]201[/TD]
[TD="class: xl68, align: right"]259[/TD]
[TD="class: xl65"]M. Salinas[/TD]
[TD="class: xl65"]NF[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]Cube 8[/TD]
[TD="class: xl69, align: right"]1/4/2016[/TD]
[TD="class: xl75"]1/7/2019
[/TD]
[TD="class: xl68, align: right"]202[/TD]
[TD="class: xl68, align: right"]3002[/TD]
[TD="class: xl65"]K. Shea[/TD]
[TD="class: xl65"]AV[/TD]
[TD="class: xl65"]Y[/TD]
[TD="class: xl65"]Cube 11[/TD]
[TD="class: xl69, align: right"]1/6/2019[/TD]
[TD="class: xl75"]6/28/2021
[/TD]
</tbody>[/TH]
[/TR]
</thead><tbody>[TR="class: s90z9tc-20 eCOxQD"]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[/TR]
[TR="class: s90z9tc-20 eCOxQD"]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[/TR]
</tbody>[/TABLE]
In the second worksheet (sample below) I would have to add further information in each row. I would like these rows to stay intact when updated, if possible. This is because I have other information to add to the reports that are due within 190 days. As I get the steps completed I could add the dates in.
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> <col style="mso-width-source:userset;mso-width-alt:2962;width:61pt" width="81"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3254;width:67pt" width="89"> </colgroup><tbody>
[TD="class: xl69, width: 64"]ID[/TD]
[TD="class: xl70, width: 71"]Name[/TD]
[TD="class: xl71, width: 79"]Due Date[/TD]
[TD="class: xl70, width: 75"]Progress[/TD]
[TD="class: xl72, width: 72"]Referral[/TD]
[TD="class: xl72, width: 81"]Template[/TD]
[TD="class: xl70, width: 64"]Score[/TD]
[TD="class: xl70, width: 64"]RRG[/TD]
[TD="class: xl73, width: 89"]Comments[/TD]
[TD="class: xl67, align: right"]5563[/TD]
[TD="class: xl68"]J. Smith[/TD]
[TD="class: xl74"]5/17/2019
[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl66"]
[/TD]
[TD="class: xl67, align: right"]259[/TD]
[TD="class: xl68"]M. Salinas[/TD]
[TD="class: xl74"]6/3/2019
[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl66"] [/TD]
</tbody>
Also, the same information needs to be gathered into a third sheet if it is within 2 months (+70 days) but no longer on the second sheet. With further information gathered there as well.
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:3072;width:63pt" width="84"> </colgroup><tbody>
[TD="class: xl69, width: 64"]ID[/TD]
[TD="class: xl70, width: 71"]Name[/TD]
[TD="class: xl71, width: 79"]Due Date[/TD]
[TD="class: xl70, width: 75"]Placement[/TD]
[TD="class: xl72, width: 84"]Assessment[/TD]
[TD="class: xl66, align: right"]5563[/TD]
[TD="class: xl67"]J. Smith[/TD]
[TD="class: xl68"]4/13/2019[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl66, align: right"]259[/TD]
[TD="class: xl67"]M. Salinas[/TD]
[TD="class: xl68"]5/15/2019[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]
[/TD]
</tbody>
I have looked into VBAs and such and can not figure them out for the life of me. I can't figure out how to have this data entered without screwing with the rows I already have entered in sheet 2 and 3. This is a worksheet that I use daily. So I would like for the data to be updated each time I view the worksheet. I have tried advanced filters to no avail. Many thanks to those who attempt to help and know much more than I do.
[TABLE="class: s90z9tc-19 iDFCDm"]
<thead>[TR="class: s90z9tc-20 eCOxQD"]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"][/TH]
[TH="class: s90z9tc-25 cmsMXn"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:2084;width:43pt" width="57"> <col style="mso-width-source:userset;mso-width-alt:2925;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:6912;width:142pt" width="189"> <col style="mso-width-source:userset;mso-width-alt:2084;width:43pt" width="57"> <col style="mso-width-source:userset;mso-width-alt:1901;width:39pt" width="52"> <col style="mso-width-source:userset;mso-width-alt:6912;width:142pt" width="189"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> </colgroup><tbody>
[TD="class: xl71, width: 57"] #[/TD]
[TD="class: xl73, width: 80"]ID[/TD]
[TD="class: xl72, width: 189"]Name[/TD]
[TD="class: xl72, width: 57"]Flags [/TD]
[TD="class: xl72, width: 52"]Code[/TD]
[TD="class: xl72, width: 189"]Classification[/TD]
[TD="class: xl72, width: 87"]Item Date[/TD]
[TD="class: xl76, width: 68"]Due Date[/TD]
[TD="class: xl66, align: right"]101[/TD]
[TD="class: xl66, align: right"]5563[/TD]
[TD="class: xl67"]J. Smith[/TD]
[TD="class: xl67"]A[/TD]
[TD="class: xl67"]Y[/TD]
[TD="class: xl67"]Office 13[/TD]
[TD="class: xl70, align: right"]11/15/2018[/TD]
[TD="class: xl74"]2/7/2019[/TD]
[TD="class: xl68, align: right"]102[/TD]
[TD="class: xl68, align: right"]1257[/TD]
[TD="class: xl65"]B. Wallace[/TD]
[TD="class: xl65"]V[/TD]
[TD="class: xl65"]Y[/TD]
[TD="class: xl65"]Cube 7[/TD]
[TD="class: xl69, align: right"]8/1/2018[/TD]
[TD="class: xl75"]9/15/2019[/TD]
[TD="class: xl68, align: right"]201[/TD]
[TD="class: xl68, align: right"]259[/TD]
[TD="class: xl65"]M. Salinas[/TD]
[TD="class: xl65"]NF[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]Cube 8[/TD]
[TD="class: xl69, align: right"]1/4/2016[/TD]
[TD="class: xl75"]1/7/2019
[/TD]
[TD="class: xl68, align: right"]202[/TD]
[TD="class: xl68, align: right"]3002[/TD]
[TD="class: xl65"]K. Shea[/TD]
[TD="class: xl65"]AV[/TD]
[TD="class: xl65"]Y[/TD]
[TD="class: xl65"]Cube 11[/TD]
[TD="class: xl69, align: right"]1/6/2019[/TD]
[TD="class: xl75"]6/28/2021
[/TD]
</tbody>
[/TR]
</thead><tbody>[TR="class: s90z9tc-20 eCOxQD"]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[/TR]
[TR="class: s90z9tc-20 eCOxQD"]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[TD="class: s90z9tc-21 jruhvq"][/TD]
[/TR]
</tbody>[/TABLE]
In the second worksheet (sample below) I would have to add further information in each row. I would like these rows to stay intact when updated, if possible. This is because I have other information to add to the reports that are due within 190 days. As I get the steps completed I could add the dates in.
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> <col style="mso-width-source:userset;mso-width-alt:2962;width:61pt" width="81"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3254;width:67pt" width="89"> </colgroup><tbody>
[TD="class: xl69, width: 64"]ID[/TD]
[TD="class: xl70, width: 71"]Name[/TD]
[TD="class: xl71, width: 79"]Due Date[/TD]
[TD="class: xl70, width: 75"]Progress[/TD]
[TD="class: xl72, width: 72"]Referral[/TD]
[TD="class: xl72, width: 81"]Template[/TD]
[TD="class: xl70, width: 64"]Score[/TD]
[TD="class: xl70, width: 64"]RRG[/TD]
[TD="class: xl73, width: 89"]Comments[/TD]
[TD="class: xl67, align: right"]5563[/TD]
[TD="class: xl68"]J. Smith[/TD]
[TD="class: xl74"]5/17/2019
[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl66"]
[/TD]
[TD="class: xl67, align: right"]259[/TD]
[TD="class: xl68"]M. Salinas[/TD]
[TD="class: xl74"]6/3/2019
[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl66"] [/TD]
</tbody>
Also, the same information needs to be gathered into a third sheet if it is within 2 months (+70 days) but no longer on the second sheet. With further information gathered there as well.
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:3072;width:63pt" width="84"> </colgroup><tbody>
[TD="class: xl69, width: 64"]ID[/TD]
[TD="class: xl70, width: 71"]Name[/TD]
[TD="class: xl71, width: 79"]Due Date[/TD]
[TD="class: xl70, width: 75"]Placement[/TD]
[TD="class: xl72, width: 84"]Assessment[/TD]
[TD="class: xl66, align: right"]5563[/TD]
[TD="class: xl67"]J. Smith[/TD]
[TD="class: xl68"]4/13/2019[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl66, align: right"]259[/TD]
[TD="class: xl67"]M. Salinas[/TD]
[TD="class: xl68"]5/15/2019[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]
[/TD]
</tbody>
I have looked into VBAs and such and can not figure them out for the life of me. I can't figure out how to have this data entered without screwing with the rows I already have entered in sheet 2 and 3. This is a worksheet that I use daily. So I would like for the data to be updated each time I view the worksheet. I have tried advanced filters to no avail. Many thanks to those who attempt to help and know much more than I do.