Hi
I wanted to copy a column from one sheet and transpose it to another in merged cells but could not get the code to work.
So, I thought instead I would get the destination row to take the cell value twice.
I.e.
Source Data
abc1
abc2
abc3
Destination Data
abc1 abc1 abc2 abc2 abc3 abc3
Can...
Hey guys,
I'm trying to copy data from multiple sheets into the main "Mastersheet". Assume Name is at Cells.A1.
Mastersheet
<tbody>
Name
1A
1B
1C
2A
2B
2C
3A
3B
3C
A1
ABC1
y1
x1/z1
ABC2
y2
x2/z2
ABC3
y3
x3/z3
A2
A3
A4
</tbody>
Worksheet name "A1"
<tbody>...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.