Is it possible to cross reference multiple Excel Documents?

SMANNIN

New Member
Joined
Jan 11, 2012
Messages
1
Essentially, we have one master Excel sheet for forecasting. There are 6 account managers that fill in their incoming and projected work in their own spreadsheets, all in the same format/columns and information. We need the master spreadsheet to gather data from the other excel documents for totals. We're trying to find a way to do this other than, "everyone, fill in this one master document. If someone else is using it or left it open, too bad, you have to wait, try again later," or, "if someone accidentally deletes something and saves the master, oops."
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,118,875
Messages
5,574,762
Members
412,617
Latest member
mlharris
Top