Help with macro VBA [Closed]

Report
-
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


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!