hi need vba code to do the following
step-1--->Will prompt to input column names and rows range and then
Step-2---->will copy values from cells falling in those range from the given sheet and then
Step-3---->will paste in another sheet as values starting with cell A2.
e,g If column input are give as column b,k,s and row input given as 2-636 then it will copy value in all those cells and will paste as value in another sheet.
Thank you
step-1--->Will prompt to input column names and rows range and then
Step-2---->will copy values from cells falling in those range from the given sheet and then
Step-3---->will paste in another sheet as values starting with cell A2.
e,g If column input are give as column b,k,s and row input given as 2-636 then it will copy value in all those cells and will paste as value in another sheet.
Thank you