Quote Originally Posted by offthelip View Post
This is easy enough to do, but we need more detail:
1:where is the range to be duplicated specified, presumably the range of product
2: Where is the list of shps specified
3: where do you want the result
4: Do you want shops in the columns and porducts in the rows or the other way round, or do you want them in one long list, if so what order
hey.
i want to duplicate the range of products
i have a sheet of products list, another sheet of shops and i want to duplicate it all to new sheet.
i want it all the same. first column is the shops for example and the following is the products (like the example)
so that in the new sheet it will be shown like:
shop products product color
1 A Black
1 B black
1 C white
2 A Black
2 B black
2 C white
3 A Black
3 B black
3 C white
4 A Black
4 B black
4 C white
5 A Black
5 B black
5 C white
6 A Black
6 B black
6 C white