Referencing a Cell in another Excel File

[Bokya]

Hi all. I'm trying to look for a shortcut that some people in my office can use to pull information from a different excel sheet. For example, they have two sheets named sender and receiver. They need the information of Sender's 'Sheet1'!A1 to display in the Receiver's A1. I know there's a way to do this using VBA, but I was wondering if there was an easier way to give them access to that information without them having to click a button to grab the data.

Thanks.

[Winon]

Hello Bokya,

Welcome to the Forum.

Assuming the Receiver's sheet is Sheet2, you can simply use in the Receiver's A1:

Please Login or Register  to view this content.