excel_userss
New Member
- Joined
- Jun 4, 2019
- Messages
- 11
Hi All,
I want to paste Data from Main sheet to other sheets.
Let me first show you sample.
[TABLE="width: 768"]
<colgroup><col span="12"></colgroup><tbody>[TR]
[TD="colspan: 2"]Main sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Sheet name[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]SheetName[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Option [/TD]
[TD]Strike[/TD]
[TD]Expiry[/TD]
[TD][/TD]
[TD]ABC[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]XYZ[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abc[/TD]
[TD]P[/TD]
[TD="align: right"]11600[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD="colspan: 2"]Column C][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C][/TD]
[/TR]
[TR]
[TD]Xyx[/TD]
[TD]c[/TD]
[TD="align: right"]11500[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]c[/TD]
[TD="align: right"]11400[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: center"]########[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: center"]########[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]c[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]c[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to paste option strike and expiry columns data in respective sheets name mentioned on the left.
This is how the respective sheets looks like.
In sheet ABC So rather than adding data in different row the macro should first look if there is blank in Column B. If there is then paste data there and if there isnt then paste data in next possible row.
Its a mammoth task for me.
Please help.
Thanks
Excel_Userss
I want to paste Data from Main sheet to other sheets.
Let me first show you sample.
[TABLE="width: 768"]
<colgroup><col span="12"></colgroup><tbody>[TR]
[TD="colspan: 2"]Main sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Sheet name[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]SheetName[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Option [/TD]
[TD]Strike[/TD]
[TD]Expiry[/TD]
[TD][/TD]
[TD]ABC[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]XYZ[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abc[/TD]
[TD]P[/TD]
[TD="align: right"]11600[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD="colspan: 2"]Column C][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C][/TD]
[/TR]
[TR]
[TD]Xyx[/TD]
[TD]c[/TD]
[TD="align: right"]11500[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]c[/TD]
[TD="align: right"]11400[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: center"]########[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: center"]########[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]c[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]c[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to paste option strike and expiry columns data in respective sheets name mentioned on the left.
This is how the respective sheets looks like.
In sheet ABC So rather than adding data in different row the macro should first look if there is blank in Column B. If there is then paste data there and if there isnt then paste data in next possible row.
Its a mammoth task for me.
Please help.
Thanks
Excel_Userss