Kindly help me to arrive at a code to solve this prob
A B C D
1 Day Andrew Benjamin Rose
2 Sun Fitting Reading Security
3 Audit
4 Mon Grinding Leading Teaching
5 Meding Guiding
6 Cleaning
From the above example i need a vba code to chk wether the day or time is same and add both the text to one cell(B1&","&B3) like that others also
(B4&","&B5) and (D4&","&D5&","D6).
The code should find the table size and try to merge the text values.
A B C D
1 Day Andrew Benjamin Rose
2 Sun Fitting Reading Security
3 Audit
4 Mon Grinding Leading Teaching
5 Meding Guiding
6 Cleaning
From the above example i need a vba code to chk wether the day or time is same and add both the text to one cell(B1&","&B3) like that others also
(B4&","&B5) and (D4&","&D5&","D6).
The code should find the table size and try to merge the text values.