ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i link data from multiple standardized excel files (https://www.excelbanter.com/excel-discussion-misc-queries/21984-how-do-i-link-data-multiple-standardized-excel-files.html)

George

how do i link data from multiple standardized excel files
 
I have 10 excel files that have a standardized data entry. I want to link the
data together in one file and have the data automaticaly update itself in
that consolidated file while other people do data entry.

Is this possible???

Ron de Bruin

Hi George

Maybe this is useful to create the links
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"George" wrote in message ...
I have 10 excel files that have a standardized data entry. I want to link the
data together in one file and have the data automaticaly update itself in
that consolidated file while other people do data entry.

Is this possible???




George

That helps a lot. Thank you.

"Ron de Bruin" wrote:

Hi George

Maybe this is useful to create the links
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"George" wrote in message ...
I have 10 excel files that have a standardized data entry. I want to link the
data together in one file and have the data automaticaly update itself in
that consolidated file while other people do data entry.

Is this possible???






All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com