mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
Hi,
I need to write a code to output the unique value of current range which contains repeating value and text but no space to a new sheet called "MyNewSheet".
Then I need another set of code, same as above, but if the system found "MyNewSheet" is already there, output it to sheet "MyNewSheet1",
"MyNewSheet2","MyNewSheet3" etc.
Thanks
I need to write a code to output the unique value of current range which contains repeating value and text but no space to a new sheet called "MyNewSheet".
Then I need another set of code, same as above, but if the system found "MyNewSheet" is already there, output it to sheet "MyNewSheet1",
"MyNewSheet2","MyNewSheet3" etc.
Thanks