I have a document containing some filed, if the customer name is same then mail merge document would be in the single document.
Please help me with this.
I am attaching both the sheets please go through this.
I Want to change the location of cell like A3 to B2 (hall no | stall no should be in front of company name.)
Company
A. DAMIANO & COMPANY
Hall No. HALL 9 | Stall No. H9B1
A. EBERLE SYSTEMS PVT. LTD.
Hall No. HALL 14 | Stall No. H14D6
AADI LOCKS PRIVATE LIMITED
Hall No. HALL 16...
NAMES
AANCHAL
RUPAL
RAHUL
RAM
SHYAM
RUPAL
RAHUL
AANCHAL
Here i want unique values in drop down like non repeated values in dropdown.
For eg. if AANCHAL is coming two times then it would show only one time in my dropdown
Cars
TYPE
MODEL
Hyundai
h1
I20
Hyundai
h1
I10
Hyundai
h2
I30
Hyundai
h2
I40
Suzuki
S1
WHITE
Suzuki
S2
black
Suzuki
S3
PINK
If I select Cars then it should show a unique identity like Hyundai and Suzuki.
And if i select Hyundai Then it should show Unique Type Like h1,h2 ...
Your solution is very interesting thankyou.
Now i need some changes like if i select A4 dropdown For 2.5 then insulation should also be change like D14 Pvc 13 and XLPE 8 from the dropdown and if i select A4 dropdown For 1.5 then insulation D4 PVC 8 and XLPE 6 from the drop down
If i select from A4 dropdown like if i select For 1.5 then it should show 1.5 contents A4 to J4 and if i select For 2.5 from A4 dropdown then it should show 2.5 data A14 to J14.
How can i open contents like if i select option button 1 then it should open the range from C4:G6
and if i select option button 2 then it should open the range from C9:G11