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.
Name
Devices
code
A
Desktop
234
B
Laptop
2345
C
Television
3456
D
Smartphone
7654
E
Printer
NA
F
Desktop
098
G
Scanner
NA...
Hi there,
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.