thespardian
Board Regular
- Joined
- Aug 31, 2012
- Messages
- 119
- Office Version
- 2016
- 2013
- Platform
- Windows
Hi there!
On Sheet6 (D Data), The range K3:K50 have an array formula for the extraction of unique Centre list. And I want to copy the only cells that contain text. (range K3:K9 in the given example)......... And
paste it at the end of column B on Sheet 7 (Compile D) by ignoring the names already available in the existing list at destination sheet (i.e Sheet 7 (Compile D))
I mean, duplicate names are not required and the order of list should not be disturbed on Sheet7(Compile D).
Any help on the matter would be highly appreciated. TIA
On Sheet6 (D Data), The range K3:K50 have an array formula for the extraction of unique Centre list. And I want to copy the only cells that contain text. (range K3:K9 in the given example)......... And
paste it at the end of column B on Sheet 7 (Compile D) by ignoring the names already available in the existing list at destination sheet (i.e Sheet 7 (Compile D))
I mean, duplicate names are not required and the order of list should not be disturbed on Sheet7(Compile D).
Any help on the matter would be highly appreciated. TIA