Excel MACRO - Help me automate data from one spreadsheet to another!

I am looking for an Excel VBA expert to perform multiple pieces of excel automation.

Our use case is as follows - We deliver fruit boxes to offices every week. We need to print name labels for each box based on whether we deliver a customer for a particular week.

So in the excel file :

In the source_data sheet the user will fill the following information,
1. The number value in a particular cell (no. of boxes) AND
2. Whether we deliver in a particular week or not (Delivery this week = Y)

We want the user to click a macro button which says populate lables (should exist in sheet which should then automatically populate
Sheet by

3. taking information from point 1 and 2 from above and
4. Deleting any previous data except the header row
5. If Delivery this week is set to Y then
6. Create new rows based on the no. of boxes and
6. Populate the rows taking information from Sheet
7. The information should be from the fields:
Client Label
Contact Person
Address
Postcode
About the recuiter
Member since Nov 11, 2022
Rohan Dandavate
from Oost-Vlaanderen, Belgium

---

---

Offer to work on this project closes in 21 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions