Hi I am new to this forum and need help for pasting some data from sheet 1 to sheet 2 in the form of transpose.
Let me explain in clear. I have a excel sheet as given below image
From the above image I need to copy the Image 1, 2,3 as a Transpose into other excel file. Th file is given as below
So the table 1 data should come into table 2 and paste them in Image link1, Image link 2 and image link 3.
Can any one please help me to create a VB for macros as I am new to this and cant do 20K manually. Please help me friends.
Let me explain in clear. I have a excel sheet as given below image
From the above image I need to copy the Image 1, 2,3 as a Transpose into other excel file. Th file is given as below
So the table 1 data should come into table 2 and paste them in Image link1, Image link 2 and image link 3.
Can any one please help me to create a VB for macros as I am new to this and cant do 20K manually. Please help me friends.