Help with macro VBA

Closed
bm106 - May 26, 2016 at 04:19 AM
Hello,
need to get a macro enabling to select a range of cells from one row and tranpose them into fixed position + get value from one cell and return this value back to my selected range...than repeat the same action but with another range of cells placed one row down...again transpose them into same fixed postion - get value - return the value back to the selected range

row will always go with 4 cells

e.g.

row a b c d
row d r t s


select a range and copy into another sheet - one column - fixed position

a
b
c
d

after inserting you get a value like

c5 = 5

copy this value back to my row range like

row a b c d 5

then

select a range from one row down and copy on the same fixed position

d
r
t
s

get a value

c5= 10

then

row a b c d 5
row d r t s 10

thanks for help