sanket.katkar
New Member
Actually i am trying out some thing challenging using macros.
There two workbook lets say Workbook1 and workbook2.
From workbook 1 i have to copy data from D5 to D52. and paste that data in workbook 2.
But the process should be ;
When i click on the button in Workbook2 it should ask me the source workbook from where the data
has to be copied and after selecting that work book it should ask from which line it should
paste the data in the sheet. Paste should be special value.
Thanks in advance....
There two workbook lets say Workbook1 and workbook2.
From workbook 1 i have to copy data from D5 to D52. and paste that data in workbook 2.
But the process should be ;
When i click on the button in Workbook2 it should ask me the source workbook from where the data
has to be copied and after selecting that work book it should ask from which line it should
paste the data in the sheet. Paste should be special value.
Thanks in advance....