Random Sample

Hi,

I've coded a macro that can randomly sample out rows of data from a sheet.

This macro is used to sample out certain rows from a master sheet full of data (which has 48 columns) based on user names (a column titled LAST_UPDATE_NAME)

For Example (ref. wkb attached), if for 5 users named Alastor, Catherine, Emma, Julie and Victor for whom i've to choose data from the Dump sheet.

I need help to design a module in which if i input the no. of samples to be chosen against each name, then that many number of rows has to be chosen for that particular name and copied to a new sheet (probably such sheets can be renamed with the usernames). Also i want to consolidate the copied data from the multiple sheets and consolidate them to one sheet.

How can this be done? Can someone help me??

Ranga

Hi,
I've also coded a filtering module that can filter and extract records to a new sheet. The filters can be upto any level, meaning that more filters can be applied to any no. of fields (columns).
Hope this might be useful.

Ranga

Hi,
Had been trying out coding for this.. Here's what i've come up with:

Please Login or Register  to view this content.

I'll already have some worksheets in the whole macro that i'm trying to integrate and i'll generate worksheets separately for each user for whom i'll need to choose samples.

The line indicated above in red needs to be tweaked accordingly in such a way that i'll collate all samples chosen for these users to one master sheet. Simply to say, I don't want to export from all worksheets in the workbook. How can this be done? Can anybody help??

Ranga

Hi Mr. Jaslake,

Refer our discussion. Please find attached the required document.

Ranga

Hi Ranga
I've reviewed your attachment this weekend (you provided the password via personal message). I was somewhat surprised the attachment is password protected. The principle reason I suggested you take this to the Forum was the input you would (could) receive from the wonderful resources available here.
Alright, I have reviewed your project. You're building what I would call an "Enterprise Solution" that will help you manage your business. I've directed many of these projects during my working career so I'm aware of your daunting challenge. However, in those projects, I defined, and therefore understood, the parameters. Also, I had a team of programmers who understood what I was attempting to accomplish. As I explained, I'm a retired "bean counter". You give me a numbers related issue, I will probably be able to figure it out because I understand the issue.
I don't know your process. If you had the time, I could be educated. I'm a kinetic learner; you show me (maybe once, maybe 50 times) and I'll figure it out. We don't have the time nor the proximity to do that.
Your issues are well beyond my knowledge and experience. I would strongly recommend you figure out a way to share your attachment with the Forum. I'm confident the Paul's and shg's and Leith's and many others on this forum will be able to give direction on your issues. However, what you are trying to do is well beyond my knowledge and experience.
Good hunting. J