Help Required: Pulling data from a workbook into a worksheet.

[Preets]

Hello Experts,

I am trying to call a workbook with a single worksheet into another
workbook's detail_data worksheet.

I have 2 workbooks: Workbook A and Workbook B.
Workbook A has only 1 worksheet (Sheet1) and Workbook B has 7
worksheets.
In Workbook B, the is a worksheet called "Detail_data" where all info
is stored. All the other worksheets in Workbook B , contain pivot
tables that must change as per data in the Detail_data worksheet.
Also, Workbook A is refreshed everyday with fresh data.
So, every time, I open Workbook B, and click on a button(may be a
refresh button), I must get the data from Workbook A (sheet1) into
Workbook B (Detail_data).

I did try using the "Indirect" reference method, but somehow, I'm not
able to solve this.
Could you please help me resolve this issue.

Thanks a lot in advance.
Regards,
Preethi.

 

[Guest]

hi,
Have you considered microsoft query?
on the menu bar click data>Import external data>new database query.
follow the wizard. data type would be xl files.
You will have to set up your data in workbook A as a named range so that
microsoft query will recognize it as a table.
if you have never use microsoft query, read up on it in xl help. just type
microsoft query.

hope this helps
regards
FSt1