I am trying to make a workbook to make it easier when sending confirmations to my clients, I talk to many people during the day, and I always send an e-mail to both parties of what we talked about. I want to make it automated in order to save time, so here goes:
I have a sheet called 'List' this is where the message will be, and data will be taken from other sheets, buyer and seller.
Both Buyer and Seller sheets contains three columns: A is company name, B is Name and C is e-mail address.
On the List sheet, I have four dropdown validation lists:
- Buyer Company name
- Buyer from company name
- Seller Company name
- Seller from company name
I speak to many people from different companies, and I don't want to show repeated company names - so I made a new sheet where I place the pivot table for both buyer and seller, but I am stuck here, tried reading on OFFSET, but I just couldn't figure it out since I don't have much knowledge in VBA.
I have attached a sheet to show more or less what I want.
I appreciate it if anyone can help me :D