Ask for a help of Excel

  • Thread starter Thread starter jill_an
  • Start date Start date
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
 
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.
 
Back
Top