Hi Angie

so you only want to do changes in your master table. The 'copied
sheets' are 'read only'. The the easiest solution would be:
1. Open your master table (assuming you data is in the worksheet
'Master')
2. Create a new workbook (your first copy) and save this (e.g. as
"Copy_1.xls")
3. In cell A1 of the new workboo enter =[Copy_1.xls]Master!A1
For ease of use just enter the '=' and then go to the master table
and select the cell A1 in this workbook.
4. Copy this formula for your 4 columns and as many rows as you want

One comment: Excel is restricted regarding the maximum number of rows
(65535). So if you really have that many entries you should switch to a
database (e.g. Access). In your case i would not link the Excel table
but import the Excel data into a database table

Frank



angie wrote:
first of all thank you for your interest!

basically what i want is a "copy" of my file (just the first four
columns). what i would like to achieve is that this "copy" is a link
to the original file, just as it happens when we link an excel table
in access. but access allows me neither to delete unnecessary columns
nor to add new columns of my choice to the table because it is a
link. is there a way to create an excel file that the columns of my
choice (not the entire file) are a link to the original file?
what i mean by a link is that whenever i change data or add a row to
the original file, the link is updated automatically without having
to repeat the changes or the insertion of new data for example.

i hope that my problem is more clear now!!!




----- Frank Kabel Î*γÏ�αψε: -----

Hi Angie,

first please turn off your CAPS lock. It's quite difficult to
read your post
Regarding your question. I did not quite understand what you
want to achieve with your master file and your dependent
'sub-files'. Maybe you can explain this in a little more detail.

Frank


ANGIE wrote:
I AM WORKING WITH AN EXCEL FILE THAT CONSISTS OF SEVERAL
CLIENTS' DATA. SINCE IT IS QUITE DIFFICULT TO MANAGE AN
INDEFINITE NUMBER OF DATA, ESPECIALLY COLUMNS, I WOULD LIKE TO
USE THIS FILE AS MY MASTER FILE OR TABLE. I WANT TO CREATE
SEVERAL OTHER FILES THAT WILL BE DIRECTLY DEPENDENT ON MY
MASTER FILE. e.g. MY MASTER FILE CONTAINS THE FOLLOWING
COLUMNS: A=client code, B=tomn, C=region, D=client name.
I WANT TO CREATE ANOTHER FILE(S) WHERE THE FIRST FOUR COLUMNS
WILL BE AUTOMATICALLY FILLED IN AND UPDATED, DEPENDING ON MY
MASTER FILE. IS THAT POSSIBLE WITH EXCEL? IF YES HOW?
I HAVE TRIED TO DO THAT THROUGH ACCESS BY LINKING MY MASTER
EXCEL FILE AS AN ACCESS TABLE. I CANNOT CHANGE, HOWEVER, THE
PROPERTIES OF THE LINKED TABLE INCLUDING ADDING OR SUBTRACTING
COLUMNS. COULD ACCESS BE MORE APPROPRIATE FOR COMPLETING THIS
TASK? IF YES HOW?
YOUR HELP WOULD SAVE A LOT OF TIME!!! PLS HELP ME!!!