Copy strings according to predefined markers (numbers)

[smide]

Hello.

In Sheet2, Column B (B3:B50) I have a strings which I need to copy in Sheet1 , Row 3 in cells B3,D3,F3, ... V3 and X3 (12 in total).

In Sheet2, Column G is so called "markers" Column because it contains markers/numbers for each product and those markers define copy position for each cell (copy position in Sheet1, row3).

So, if (in Sheet2) cell G3=1 than string from cell B3 (Sheet2) should be copied in B3 (Sheet1) and so on...

Example.

Sheet2

	B	G
3	home	3
4	shop
5	excel	1
6	pattern	6
7	question	2
8	product
9	best	5
10	forward	4
11	...	...

Sheet1 (after macro run)

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

2

3

excel

question

home

forward

best

pattern

...

[karedog]

Maybe :

Please Login or Register  to view this content.

[smide]

Yes, I just changed Offset function to Offset(, 5)...
Works perfectly. Thank you.

[karedog]

You are welcome.
Don't forget to mark this thread as solved :
please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.