Hi i want to develop test data sheet using macros in the first sheet i have data like this

column1 column2 column3 ........ column8
 A Blue India 1
 B yellow Australia 2
 C Red WI 3
         Green
         Red

In the first i have a button when i click on the button the in second sheet data should appear with all possible combinations like this 3*5*3*3 =135 combinations

Column1 Column2 Column3 ........ Column8
 A Blue India 1
 A Blue India 2
 . ... ... 3
 A Blue India
 A

 Can any body help me doing this

Thanks in advance..

msuneel

Suneel,

You can break down your task into several stages as follows :

1. Create three arrays, one to hold the list of numbers , a second to hold the list of alphabetical letters, a third array to store the list of colours and a fourth array to store the list of countries.

2. Get the values from sheet 1 and place/ save them to their respective arrays.

3. Step through the arrays using nested loops to generate all possible combinations.

The code will look something like this:

I hope this sets you back on track to solving your problem.

Regards,

Jake

Courtesy of

http://www.Excel-Expert.co.uk
http://www.MacroExpert.co.uk
http://www.Officesoftworks.co.uk