razlevav
01-25-2017, 06:20 AM
hey guys. i need your help
i'm trying to save time by VBAing simple process,
I need to duplicate a specific Range as many time as another range have + i need to inseret additional field to the duplicated range.
i explain better:
i have a range of products and a range of shops numbers.
i want to duplicate the range of products as many times as the number of shops i have, but also for each paste of range i want it to add additional column with the shop number. so at the end i will have for example: if i have 6 shops, 1 till 6. than i will have the products range X6 times but will have 6 diffrent shops number.
1
A
1
B
1
C
2
A
2
B
2
C
3
A
3
B
3
C
4
A
4
B
4
C
5
A
5
B
5
C
6
A
6
B
6
C
thanks for all your help!!
Raz
i'm trying to save time by VBAing simple process,
I need to duplicate a specific Range as many time as another range have + i need to inseret additional field to the duplicated range.
i explain better:
i have a range of products and a range of shops numbers.
i want to duplicate the range of products as many times as the number of shops i have, but also for each paste of range i want it to add additional column with the shop number. so at the end i will have for example: if i have 6 shops, 1 till 6. than i will have the products range X6 times but will have 6 diffrent shops number.
1
A
1
B
1
C
2
A
2
B
2
C
3
A
3
B
3
C
4
A
4
B
4
C
5
A
5
B
5
C
6
A
6
B
6
C
thanks for all your help!!
Raz