Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task to be conducted on weekly basis. Consider following example.
I would like to have a drop down list with options No.1 to No.10 but once a number has been used, it is removed from the drop down list.
I have found one way to do it but I'm hoping there's a better way.
Drop down lists go in cells D180:D260.
Currently my data validation list is...
Hi, I want to generate a list of non-repeating random numbers between 0001 and 9999, but I only need a total of 2051 of the 9999 I want to have 5 separate / individual columns, each with one set of non-repeating numbers. Any suggestions, comments, ideas welcome. Thanks