Hi,
I am trying to create a random list of text.
Created a list with text1 - text60 in colum B. From here populating column E, with a random list of text. Problem is:
1. I keep getting duplicated text. How can I solve this issue.
2. Need to do a daily history dump every time the text in column E is refreshed (once a day) - data in column E to be copied to worksheet history dump. But the data being volatile due to the random numbers in the formula, I need to capture the data and dump / copied to worksheet history dump worksheet with the date stamp.
Sample worksheet attached.
Hope someone can help...
Bookmarks