Random row export to new sheet on date criteria

[aldea187]

Hey guys,

Not sure if this is possible or worth even trying..but after searching this forum, the internet, and everyone i know..i turn to you.

I am looking to get a random pull of rows from a sheet. The random pull will be 10 for AM and 10 for PM. It will need to be only business days and for the entire month. My sheet has created on date which is what i want to use for the lookup. I would like these exported to a different sheet once it makes its pull. The main data sheet will only have the current months data for the pull.

Main sheet: dataUser
Date to do search off of: Table2[Created]
Sheet to export to: MonthlyReview (starting in G1 is the title and G2 is data but that changes once i put filter in effect)


There are thousands of rows of data, but here is an example of data:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD="class: xl214, width: 94"]Issue Type[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 89"]
<tbody>[TR]
[TD="class: xl216, width: 89"]Key[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl216, width: 168"]Affected Enduser[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl216, width: 86"]Priority[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 269"]
<tbody>[TR]
[TD="class: xl216, width: 269"]Configuration Item[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 324"]
<tbody>[TR]
[TD="class: xl216, width: 324"]Assigned Group[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl216, width: 123"]Created[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 121"]
<tbody>[TR]
[TD="class: xl216, width: 121"]Updated[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl216, width: 123"]Resolved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl216, width: 158"]Affected Helpdesk[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD="class: xl215, width: 94"]Request[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[TD]john[/TD]
[TD]planning[/TD]
[TD]desktop[/TD]
[TD]helpdesk[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl216, width: 123"]1/3/2015 5:52[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 121"]
<tbody>[TR]
[TD="class: xl216, width: 121"]1/5/2015 6:15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl216, width: 123"]1/3/2015 5:58[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]north america[/TD]
[/TR]
[TR]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD="class: xl215, width: 94"]Request[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2[/TD]
[TD]james[/TD]
[TD]low[/TD]
[TD]server[/TD]
[TD]sap[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl216, width: 123"]1/2/2015 23:07[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 121"]
<tbody>[TR]
[TD="class: xl216, width: 121"]1/5/2015 22:15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl216, width: 123"]1/3/2015 21:47[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]north america[/TD]
[/TR]
[TR]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD="class: xl215, width: 94"]Request[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]3[/TD]
[TD]justin[/TD]
[TD]crtical[/TD]
[TD]server[/TD]
[TD]local[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl216, width: 123"]1/2/2015 20:06[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 121"]
<tbody>[TR]
[TD="class: xl216, width: 121"]1/4/2015 23:15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl216, width: 123"]1/2/2015 22:38[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]north america[/TD]
[/TR]
</tbody>[/TABLE]