I have an excel sheet for my work with all the items we sell and every day we do something called a 10 line count and I would like the excel sheet to update on it’s own picking 10 random products to be counted and each day they are different.

Id like it so at a set time of day the VBA kicks in and changes what needs to be counted.

The items what need to be counted are on a different sheet to the 10 line count so the full list of items are on a page called “Specimens Back Office Feed” and the 10 line (where the 10 items need to be pasted) are on a page called “Today’s 10 Line”

The rows what need to be copied are from A2:G2 and go down all the way down to G500.

If someone could help me create a VBA what does this for me I’d be so greatful.

I have tired creating this myself over the last week but there seems to be faults all the time.