I need to know if there is a way in Excel or a macro I can get that will allow a field in one spreadsheet to be updated with data from another excel file. For example, Spread sheet A has a field that needs information that is input in a different file. I am really just trying to reduce the need to duplicate work in multiple files. Thanks.