Linking Data from different workbooks

[Lball]

Hi. I'm looking for some advice on how to get started on a project.

I need to reformat an existing workbook/project. There must be a better way to do what i'm trying to do. Ultimately what i'm looking to do is set up one file with different pages of data that are downloaded from external sources everyday, sometimes twice a day. Each page of data comes from a different source.

From there I want to make a company ratesheet in a different workbook that uses the downloaded pages. I want to be able to send out the company ratesheet to everyone without them seeing calculations to most of the cells. Here's the problem/question. I want the company ratesheet to pull from a new excel doc each time because i want to save each days download as a different name to be able reference the previous days data. I don't want previous days ratesheets to get updated to the new downloaded pages because of the links.

I'm not looking for someone to program it entirely, just a direction or thought for me to get started.

ANYONE????

 

[Ron Walker]

I have been trying to do the same type of function and can't find the answer either. I am able to update changes in other worksheets of a workbook with links as you are doing or by using code to do it and leaving the data in the proper cell and not the formula of a link. (links cost memory!) I am still trying to do the same across workbooks with only code, yet to figure it out.(CountSrc and CountDest works for worksheets in same workbook).Both of my workbooks are in the same Excel folder, and I hope we both can get an answer to this soon........