Dynamic range macro required

[AparnaWangu]

Hi Team,

My requirement is like I require an macro where I need inputboxes to enter the location of file where it will be stored on my local computer,when that file will be opened then it should ask to input the range which needs to be copied and the sheet name and range where the data needs to be pasted.

In short I want the copy and paste operation criteria wise and for criteria entering through be through inputboxes which makes it dynamic.

Regards,
Aparna