Multiple Excel files

Log Out | Lost Password? | Topics | Search Contact | Register | My Profile | SO home | MOL home

Thread Originator Last Poster Posts Pages Last Post   Closed: New threads not accepted on this page

Author Message   tabby Citizen Username: Tabby Post Number: 236 Registered: 8-2001 Posted on Monday, January 23, 2006 - 4:03 pm:        Is there any way to link or merge several excel files so information can be input once? I work with several excel files and have to input the same information to each file. Any way to merge or link them so I can input into a "master file" that will populate into the rest of the files? Thank you, Tabby   wnb Citizen Username: Wnb Post Number: 314 Registered: 8-2001 Posted on Monday, January 23, 2006 - 4:35 pm:        Yes you can just use the "=" sign in a cell and reference a cell in the other document. The easiest way is to have both open and just put "=" into the cell, then go to the other spreadsheet and click on the cell. Hit enter and you're done.   tabby Citizen Username: Tabby Post Number: 237 Registered: 8-2001 Posted on Monday, January 23, 2006 - 5:27 pm:        Thank you wnb.