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!!

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!!!

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 you
pos
Regarding your question. I did not quite understand what you want t
achieve with your master file and your dependent 'sub-files'. Maybe yo
can explain this in a little more detail

Fran


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 O
DATA, ESPECIALLY COLUMNS, I WOULD LIKE TO USE THIS FILE AS MY MASTE
FILE OR TABLE. I WANT TO CREATE SEVERAL OTHER FILES THAT WILL B
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 B
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 EXCE
FILE AS AN ACCESS TABLE. I CANNOT CHANGE, HOWEVER, THE PROPERTIES O
THE LINKED TABLE INCLUDING ADDING OR SUBTRACTING COLUMNS
COULD ACCESS BE MORE APPROPRIATE FOR COMPLETING THIS TASK? IF YE
HOW
YOUR HELP WOULD SAVE A LOT OF TIME!!! PLS HELP ME!!

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!!!