karl_learnvba
New Member
- Joined
- Oct 10, 2019
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
Hello, I started learning VBA yesterday,.. please bear with me if this is v basic,....
I have a set of data in a worksheet that will vary in size.
i would like to copy the value in cell P2 (10.10.2019) down to the bottom of the column,.. which is currently 4000 rows long.
<tbody>
</tbody>
Thank you all in advance
I have a set of data in a worksheet that will vary in size.
i would like to copy the value in cell P2 (10.10.2019) down to the bottom of the column,.. which is currently 4000 rows long.
Column P | |||
Row Number | Exp Close Date | Report runDate | |
1 | December 31, 2020 | 10.10.2019 | |
2 | February 28, 2020 | ||
3 | September 30, 2020 | ||
4 | December 21, 2019 | ||
5 | October 31, 2019 | ||
6 | November 30, 2019 | ||
7 | January 31, 2020 | ||
8 | March 31, 2020 | ||
9 | December 31, 2020 | ||
10 | March 31, 2020 | ||
… | July 31, 2020 | ||
… | December 15, 2019 | ||
… | June 26, 2020 | ||
… | June 01, 2020 | ||
… | September 30, 2020 | ||
… | March 31, 2020 | ||
… | June 30, 2020 | ||
Lastrow | December 02, 2019 |
<tbody>
</tbody>
Thank you all in advance