Text from another workbook

A

Anto111

Hi all,

I need to use a formula to pick up text from another workbook.

I did use the conventional = but this just seems to return '#value' in my
desired cell.

I trust I need to do something slightly more complicated but am at a loss as
to what.

Any help would be greatly appreciated.

Many thanks in advance.

Ant
 
D

Dave Peterson

Open both workbooks in the same instance of excel.
Go to the "sending" cell
Edit|Copy
Go to the "receiving" cell
Edit|Paste special|click Paste link

When you close the sending cell's workbook, excel will adjust the formula to
include the path.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to push data to another workbook 0
Returning info from another workbook 1
How to create absolue path link to another workbook (Excel 2003) 1
Copy and Past Values AND Formatting AND Text 1
summarizing data from various workbooks 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Maintaining Hyperlinks on a pen Drive 1
Use Macro to Copy Formula from one Workbook to another 4

Top