Muhammad Tanzeel Ur Rehma
New Member
- Joined
- Aug 14, 2022
- Messages
- 6
- Office Version
- 2019
- Platform
- Windows
Hello everyone,
Wish you will all be happy and healthy and wana thanks in advance to all the champions.
Problem:
i have an excel sheet which i prepared daily, weakly and monthly having column names Date, Reference, Customer/vender, and description. i also have a column name unique names.
what i want?
I want a VBA code that will take the name from unique name list and find the name in description. If name found in description then write this name in Customer/Vender column name otherwise write nothing/leave blank.
again very thanks to all of you!
Regards
Wish you will all be happy and healthy and wana thanks in advance to all the champions.
Problem:
i have an excel sheet which i prepared daily, weakly and monthly having column names Date, Reference, Customer/vender, and description. i also have a column name unique names.
what i want?
I want a VBA code that will take the name from unique name list and find the name in description. If name found in description then write this name in Customer/Vender column name otherwise write nothing/leave blank.
again very thanks to all of you!
Regards
Date for seperating customers.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Posed Date | Referenc | Customer/vender | Description | Amount | Unique name | ||||||
2 | 1-Jan-22 | AC-KHALIFA SONS-BANK DRAFT | 2500 | tanzeel | ||||||||
3 | 2-Jan-22 | PURCHASE FROM MALIK & SONS | 1200 | khalifa | ||||||||
4 | 4-Jan-22 | TRANSFER TO FARISHTA | 1500 | farishta | ||||||||
5 | 6-Jan-22 | JOHN MICK PENALITY PAID | 2500 | john mick | ||||||||
6 | 8-Jan-22 | SALE OF FUEL TO KASHIF | 2000 | suleman | ||||||||
7 | 12-Jan-22 | FEE RECEIVED FROM NAZIR AHMED | 2500 | lesco | ||||||||
8 | 23-Jun-22 | CLEANING FEE PAID TO TANZEEL | 1000 | |||||||||
9 | 28-Jun-22 | TUTION FEE PAID TO SULEMAN | 500 | |||||||||
10 | 31-Jul-22 | TRANSFER TO KAMAL | 200 | |||||||||
11 | 30-Jul-22 | ELECTRICITY PAID TO LESCO | 150 | |||||||||
12 | 18-Jul-22 | WATER CHARGES PAID TO HELMON | 89 | |||||||||
13 | 22-Mar-22 | money transfer to tanzeel | 12 | |||||||||
Sheet1 |