Copying contents of an activesheet to another worksheet

Hi,
I am very new to macros but need to implement them on a project. Have been trying to work on my own and learnt a lot but due to time constraint, need help now.
I am trying to do the following -

1. Open an excel file (with some formatting macros)
2. As soon as this file opens, a dialogue box opens asking for the source excel file. (The source excel file is extracted from the internet and the name is variable with dates).
3. On entering the location, the source filer opens up (simultaneously with our destination file opened up) and the data from the only available sheet from the source file gets copied to the first sheet on our destination file)

I am able to have the dialogue box and have the source file open up but I am not able to select the source file as active sheet and copy the data on the destination file (which wee know the name and path for)

This is the file with the dialogue box macro:
https://www.dropbox.com/s/bzapyxqjxx...Worksheet.xlsm

Thanks in advance,
Raunaq

Hi,

Is this the sort of thing you are looking for?

I have commented in your VBA code to help you understand the changes that I made. Let me know how you go

That works perfectly, thanks a lot!
There's another thing I needed help with, probably the last for this project.

The data copied has some empty cells in it. What I am looking to do is incorporate a macro to find empty cells (row wise) and then shift the cells next to the empty cells towards the left. Please suggest code to do that.

Thanks in advance,
Raunaq

Hi Raunaq,

You're welcome, I'm glad I could help.

Could you please mark this thread as solved and click on the * next to my post to say thanks, and then start a new thread for your next question as it is a new question.

Thanks