EXCEL OR ACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top