I recently landed an Internship in this big company working in the Supply and Chain Management where our job is to basically plan the whole demand and production for a whole year and update the SAP database every week.
My employer wanted me to create a VBA/Macro program in excel that basically copy the necessary datas of each week from their excel database and paste it on their SAP database, however each week the number of products changes(Hence the rows also changes) which got me confused in making a VBA program that deal with changing datasets in excel.
Ps. I just started using VBA/Macro and still an amateur. Any tips and tricks helps!! Let me know, Cheers!