LinkBack URL
About LinkBacks
How do I read data in another opened excel document (in a certain sheet) without activating it.
Reading data in onther Excel document
How do I read data in another opened excel document (in a certain sheet) without activating it.
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
By "read" do you mean link it into the active workbook? Use a link formula:
='[Other Book.xls]Sheet1'!$A$1
"Ernest" wrote:
>
> How do I read data in another opened excel document (in a certain sheet)
> without activating it.
>
>
> --
> Ernest
> ------------------------------------------------------------------------
> Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
> View this thread: http://www.excelforum.com/showthread...hreadid=398547
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks