Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function referring to values on different Worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
referring to other worksheet | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Referring to Previous Worksheet - coding | Excel Worksheet Functions |