Get data from another workbook to a summary workbook.

[TIERNAN]

In the summary sheet I want to get data from the intercompany. I have been using copy and paste to do this. I am sure there is more efficient way of doing this. I can no idea where to start. I have attached two files for you to have a review.

Thank you

[arlu1201]

So you just want the data from the respective columns to be copied to the summary file?

You want this action to be performed on only file or do you have a list of files in a folder?

[TIERNAN]

So you just want the data from the respective columns to be copied to the summary file?

You want this action to be performed on only file or do you have a list of files in a folder?

Yes I want the data from the respective columns to be copied to the summary file.

Yes I have list of files in a folder.

[Kynthia Melissa]

Hi Friends,

1. Why don't you include a VBA Commandbutton in the workbook that will allow the transfer of data, regardless of the date so u are not constrained by the date factor at all

2. Emailing workbooks is never a good idea, create a shortcut and email the shortcut link to your bosses, so if they need to make any change / modification it can be contained in the same file. Hope you get the idea here

3. Moreover, having numerous sheets added is not a good idea again, use the command button to do it all from you transfer data, refresh data, perhaps you may even create an auto email generating method.

Thanks and Regards
Kynthia Melissa

[TIERNAN]

Hello,

I have no idea what a VBA Commandbutton is. Do you think you will be able to help?

[arlu1201]

Kynthia is talking about a macro assigned to a button. Thats the same thing i am working on for you.

[TIERNAN]

Thanks for letting me know what the VBA commandbutton was. I looking forward to hearing from you. Thanks for your help.

[jindon]

Which line from Data_Car goes to which line in Summary_Assets and what is the condition?

[TIERNAN]

The reporting company would be D. So line 9 from Data would go to line 36 in the summary. I think the conditions would be based on Intracompany, Code and Invoicing currency.

Thanks for your help.

[TIERNAN]

Hello, how are things going with trying to solve the problem? Again thanks for the help.

[jindon]

No idea why it should be that row.

Can you explain it in logically understandable format?

[event21]

Hi -

I think you need to have some field or even on the file name of your intercompany file to reflect the reporting company.

So if if saw the reporting company code somewhere on the intercompany files, the script will look for this term in column A of the summary file then validate if the other 4 columns are the same then get the values.

Regards,
event