Srijithkumar
New Member
I want to select 2 sheets in a workbook of users choice using inputbox.Once vba recognises the two sheet names it should copy a range of values from the first sheet selected to the second one.
For Example
In sheet 1 we have data from (B5:B12) I want to copy this range and paste to sheet 2 (D5:D12). I have attached the file for reference.
Note: The selection of two sheets needs to be of users choice not predefined.
Can someone help me in creating this macro
For Example
In sheet 1 we have data from (B5:B12) I want to copy this range and paste to sheet 2 (D5:D12). I have attached the file for reference.
Note: The selection of two sheets needs to be of users choice not predefined.
Can someone help me in creating this macro