How to create a master sheet of several (12 maybe more) worksheets

S

Saad

HI
How do i create a master sheet of several (12 maybe more) worksheets that
are in the same work book and in a manner that if i make changes in the
mastersheet, it also changes the other sheet.

I have to do this with several files in excel and than create a master file
of all the master files.(i.e. if i have with your help of course made 12
different excel files each having an master file and then i have to create a
single master file of all the mastersheets in the 12 workbooks)

About the data in the worksheets:

*Data has a header row
*Some entries might be repeated but i dont want to lose the repeated data.

"I have tried to use paste link from paste special but it takes to much time
and than microsoft excel 2003 hangs" Any idea's how i can achieve this.

I hope given information is enough, if not let me know.
Thanks in advance.
 

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

Excel-Adding rows to master sheet that will be inserted on following worksheets 1
I want to link sheets in excel to a master sheet in excel 1
Is it possible to create a master Worksheet 4
save information from several worksheets to a master worksheet 1
Tie additional cells to cell automatically updated 1
Stop linked cells from changing when insert new row? 1
Macro to create newsheets 3
Excel Chart - Too many data points in Series? 1

Top