Import another excel Paste data in Current open excel sheet

Hello,

What I am trying here is creating a user form in Sheet1 of excell with a text box in it, which would pull up the excel sheet saved in local desktop ( I would do not mind excel giving me a browse option), then past the content of that excel in my Sheet2 of open workbook.

Is this possible? I tired to find the codes but no luck as of now.

please assist
Thanks
Regards

Why do you need a macro? Open the workbook, right click on the sheet name and copy it to the open workbook.

Thanks Patel45, for the macro, let me give it a try.

Bongaan, The reason why i wanted it to be in macro is because I have created a userform with other option. One of the function would be creating, sorting data. Which would require input file saved in my local drive. Hope this answer to your query

Let me try Patel's coding, then I will have it "Resolved"

Thanks
Regards
Shiva

hey, that coding is working. But could you please help me to modify it as below

Please Login or Register  to view this content.

instead of this one, I need Input box, which ask this data for user to enter. Can this be done?

Regards,
Shiva

Hey,

I modified it to below

Please Login or Register  to view this content.

But I am getting "invalid procedure call or argument" with highlighted this in vb

Please Login or Register  to view this content.

Any help.

Regards
Shiva

---------- Post added at 07:17 PM ---------- Previous post was at 07:14 PM ----------

Got it fixed. It is working now.

Let me check few more then I will close this thread.

Thank You very much for your help!
Rep Added

Regards
Shiva