ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Updating information in 1 file when it is added to other files (https://www.excelbanter.com/excel-discussion-misc-queries/251386-updating-information-1-file-when-added-other-files.html)

Kyle

Updating information in 1 file when it is added to other files
 
I have 9 Spreadsheets consisting of contact information for publications in
different industries. 8 Industries and 1 Master List. I would like to link
the master list to all of the individual industry lists so that when I add or
update a new contact in an Industry list, it is reflected in the Master
Spreadsheet as well. Essentially, I want to cut down on duplicating my
efforts.

Jim Thomlinson

Updating information in 1 file when it is added to other files
 
Check out the copy paste merge examples...


http://www.rondebruin.nl/tips.htm
--
HTH...

Jim Thomlinson


"Kyle" wrote:

I have 9 Spreadsheets consisting of contact information for publications in
different industries. 8 Industries and 1 Master List. I would like to link
the master list to all of the individual industry lists so that when I add or
update a new contact in an Industry list, it is reflected in the Master
Spreadsheet as well. Essentially, I want to cut down on duplicating my
efforts.



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

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