Import data from closed workbook

[rizmomin]

Hello:

Please refer to attached sample files.
I have attached Master file and 2 data file.
In master file Sheet1 (open file), i will be choosing the file name (closed file) to export the data to sheet2 of Master file.
Below is what i need the VB Code for:
Will have weekly data file in C:\Test2\ directory and name of the file would be in cell Shee1 of Master file Cell A2.
I need the data from Book1, Sheet1 data in column AM,AN and AJ to be pasted in the next available row in Sheet2 of Master file in
column A,B and E.

Let me know if you have any questions.
Thanks.

Riz

[davesexcel]

Try this,
Make sure your file names match as they don't with the samples you attached.

Please Login or Register  to view this content.

[davesexcel]

My previous post does not register as being here.

[rizmomin]

Hi Daveexcel:

Works great without any problem.
However, I like to have your help in little tweaking.
1.
First if the file name in cell A2, does not exist then popup message saying "File does not exist..Continue to exist"

2.
I want to overwrite if the particular data already exist in Sheet2 of Master file.
I think it would be sufficient to check the first date of the source file and if that date exist in sheet2 of Master file then overwrite the whole data of the source at that position in Sheet2 of Master. The other option would be to see if the same 1st date is in Master (Sheet2), if it does then look for 1st date + 6 end of week date and clear that block before pasting.
For Example:
1st date in Source file is 1/11/2015
Look for 1/11/2015 in column A of Sheet2 Master file.
If it finds 1/11/2015 then clear the cell content until 1/18/2015 (which is 1/11/2015+6).

Please let me know if you have any questions.
Once again thanks a lot for all the expert help.

Riz