referring a worksheet
 

Hi everybody,

I want to copy a worksheet to another file(or worksheet).
when i change something in the original worksheet every changes will
take place in the other one.
it is something to refer to a cell. but i want to refer to whole
worksheet.

I have more than a fifty workbooks. I want to copy all of them into a
new workbook in different sheets.this workbook will contain all my
excel documents in one workbook but in different sheets. however when i
change something in the original files every change should take place in
the new workbook.



how can i do this in excel?
many thanks in advance.....


--
lazmanyakPosted from http://www.pcreview.co.uk/ newsgroup access

do the first link in the new workbook then just copy and paste down until it
matches

"lazmanyak" wrote:


Hi everybody,

I want to copy a worksheet to another file(or worksheet).
when i change something in the original worksheet every changes will
take place in the other one.
it is something to refer to a cell. but i want to refer to whole
worksheet.

I have more than a fifty workbooks. I want to copy all of them into a
new workbook in different sheets.this workbook will contain all my
excel documents in one workbook but in different sheets. however when i
change something in the original files every change should take place in
the new workbook.



how can i do this in excel?
many thanks in advance.....


--
lazmanyakPosted from http://www.pcreview.co.uk/ newsgroup access