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

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.

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

hi,
Have you considered microsoft query?
on the menu bar click dataImport external datanew 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

"Preets" wrote:

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.