Hi there,
I am new to this forum I would very much appreciate it if you could help me on the following task. I have a spreadsheet of approximately 35,000 rows and I try to copy dates from columns B and C to columns D and F if they meet the following criteria:
Thank you in advance!
<tbody>
</tbody>
I am new to this forum I would very much appreciate it if you could help me on the following task. I have a spreadsheet of approximately 35,000 rows and I try to copy dates from columns B and C to columns D and F if they meet the following criteria:
1. Date criteria: If a date falls between a date range (e.g. 12/1/2017 to 01/31/2018) then the existing data from Columns B and C need to be pasted to columns D and F.
2. Column A criteria: Copy dates from columns B and C to columns D and F only if there is a number in column A and the date range criteria is met.
Thank you in advance!
| Initial spreadsheet | Columns D and F should have these dates after macro is run | |||||||||
| A | B | C | D | F | A | B | C | D | F | |
| 12345 | 6/30/2007 | 12/26/2017 | 6/30/2007 | 12/26/2017 | ||||||
| 12/27/2017 | ||||||||||
| 11/27/2017 | 1/28/2018 | |||||||||
| 6789 | 1/3/2018 | 11/12/2003 | 1/3/2018 | 11/12/2003 | ||||||
| 12/26/2017 | 1/31/2018 | |||||||||
| 12/26/2017 | 3/31/2012 | |||||||||
| 101112 | 1/20/2018 | 1/20/2018 | ||||||||
| 5/27/2004 | 1/31/2018 | |||||||||
| 11/1/2005 | 1/31/2007 | |||||||||
| 131415 | 4/1/2012 | 12/31/2010 | ||||||||
| 12/26/2017 | 3/31/2012 | |||||||||
| 12/26/2010 | 1/31/2018 | |||||||||
| 161718 | 1/3/2018 | 1/3/2018 | ||||||||
| 9/10/1998 | 1/2/2018 | |||||||||
| 11/1/2005 | 11/2/2007 |
<tbody>
</tbody>
