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?
thanks.....
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?
thanks.....
Last edited: