Extracting Single Cell Data from one Workbook to Another One

[rommelq]

Hi. I hope someone can help me. I have a workbook entitled "Daily Sales". This workbook is being overridden daily with a new figure but the workbook name stays the same.

I have another workbook wherein i want to link a cell to that workbook cell A1. But if "Daily Sales" is being overridden daily, i think link would be lost.

I tried playing with the Extract Other Sources feature of the Excel 2007 but i always get a column of data and i am not knowledgeable in using it. But i can see it's quite powerful.

For my case, I only need one single cell data and i want to refresh it whenever i want to.

Is there other feature in Excel 2007 which i can use?

 

[evnoort]

Hi Rommelq,

range: workbooks("Daily Sales").sheets("sheetname").range(a1).value

will stil work. Other option is to create a named range in vba workbook open on cell A1.

Regards

 

[rommelq]

thanks for the reply. im not good with vba. where would i put the code?

 

[evnoort]

You can use a formula:

http://office.microsoft.com/en-us/e...her-cell-workbook-or-program-HP005199514.aspx

 

[rommelq]

thanks for the link evnoort. regards, rommel