I'm trying to build a macro (code) that can be used as an automated tool for a sampling module that is part of a data quality / assurance process. This sampling process needs to be done for various users. i.e. samples have to be chosen for a set of users according to certain pre-defined conditions. I'm trying to pick out sample rows from a sheet of data by constantly filtering the source data.
To understand more clearly of my requirement, read on... I've a big chunk of data in a sheet from where i need to pick out sample rows of data (at random) according to some pre-defined conditions (I may need to over-ride these conditions at times when any of the conditions do not apply). I'll use auto-filtering a lot which will export data to many worksheets created at runtime. But at the end, the sample rows need to be consolidated (few samples) together from all such sheets created. I've already coded few modules and I'm trying to build a master module where I can integrate everything together. But I'm currently engrossed with some shortfalls in the existing modules which i need to fix before the final integration of the entire working code which can be tested. If i come across any bugs i need to work around those too. I'm exploring for code across the web through forums / blogs / groups to accomplish the following: • Keep some track of data that needs to be exported (which can be done with one of the existing modules) and then creating (sort of) a recordset (like in a database) where i can store the samples. In other words, when I want to export data to new sheet(s), I only need to determine the filtered rows and not actually exporting the whole data at that point of time (when the code is in execution) which can be stored temporarily (in an array or a defined data structure). • Since i want to choose random samples for various users – at the end of an execution step for an user (say), i'll have to set some sort of flagging points (to identify the rows that have met the sampling conditions) and also need to randomly sample out these identified rows. Probably, these flags can be cleared out every time and reset but I also should take care of the overriding conditions This way I can have a control of the data being copied to many sheets from the master sheet (to avoid duplication) and also can consolidate the samples chosen for various users to a single sheet. If need be, i can post the modules i've created, but i don't know how. Can anyone help me with some coding / suggestions with which I can accomplish the above? --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
