ThatNewGuy
New member
- Joined
- Nov 27, 2020
- Messages
- 6
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 13
I hope everyone had a wonderful Thanksgiving and spent quality time with your loved ones.
I'm hoping someone has some spare code laying around for this scenario. I'm very new to Excel VBA having done some work with Access before.
Scenario is update changes in dates from Sheet2 to Sheet1 and appending any new records in Sheet2 to Sheet1. Sheet1 will have approximately 3,000 rows maximum before it is archived.
Sheet2 will have approximately 600 records with maybe 50 new dates to update and 100 records to append. Not tied to any particular method of accomplishing this.
Hopefully this graphic will clarify my question:
Thanks for any help you can give! Happy Holidays!
I'm hoping someone has some spare code laying around for this scenario. I'm very new to Excel VBA having done some work with Access before.
Scenario is update changes in dates from Sheet2 to Sheet1 and appending any new records in Sheet2 to Sheet1. Sheet1 will have approximately 3,000 rows maximum before it is archived.
Sheet2 will have approximately 600 records with maybe 50 new dates to update and 100 records to append. Not tied to any particular method of accomplishing this.
Hopefully this graphic will clarify my question:
Thanks for any help you can give! Happy Holidays!