$$Excel-Macros$$ Random Sampling

2009-10-25 Thread Sarang84
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

$$Excel-Macros$$ Re: Random Sampling

2009-10-25 Thread Hemant Hegde
Hi sarang I created a worksheet (attached) which with necessary modifications should meet your sampling requirements. I have not used any VB code in that. But for further manipulation and management of data, I think you already have required code 2009/10/25 Sarang84 sarangaraja...@gmail.com

$$Excel-Macros$$ Excel Help

2009-10-25 Thread karthikeyan
HI, How can i fillter the colored cells in excel. Except 2007 Txs karthik --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ Need Urgent Help (While Statement)

2009-10-25 Thread Anish Shrivastava
Hello Experts.. I m using While and Wend statement in my code and it has got more than 100 if conditions. when I run the macro it says WEND WITHOUT WHILE, it's buggin my head...and I don know wht's wrong. Could anyone of you please help me... Sample code... Sub dept() i = 1 z =