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>