Ask for a help of Excel

J

jill_an

Dear experts,

I have several excel files(E1), and one is for summary(S1). I want t
link the sheets in E1 into S1, then when I open S1, I can see th
sheets(only the sheets I linked) data in the S1, also when I update th
E1, the S1 will update too.

Please, thanks
 
J

Joe V

Jill,

In S1, create sheets with formulas referencing the sheets
in E1. Also in S1, insert a new sheet and use Data->
Consolidate to create a summary of the other S1 sheets.
All sheets, including the consolidation, should refresh
upon opening S1.

Regards,
Joe V.
 

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

vLookup and Line Breaking 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
Copy data from multiple columns and populate it in another sheet in one column,, 1
Ask for help of Excel 2
Import external data link disappears 1
Update several ppt documents from a single excel file 0
Excel --> Word 4

Top