ACCESS/EXCEL CELL ADDRESS AUTOUPDATE
 

Hi all,

I am wondering how it is possible to write a macros that can help me
with the problem i am facing.

Currently, I have a ACCESS table containing unique field codes and
cells address of the relevant cells in a few tables located in a
separate EXCEL spreadsheet. The cells in excel table contain only the
values and not the field codes, while the fields in the ACCESS table
only contains the field codes of the excel table cells.

As there is new rows being added to the Excel tables, I need to auto-
update a ACCESS table ,after I have manually key in the new field
codes, all the new cell address of the cells in excel table. (cos when
i add the rows the older cells are now pushed down).

If it sounds complicated, it probably is. I really hope anyone can
help me start on this. Index match method doesnt work as the range
keeps changing since the

EXCEL:

Stock inventory First 7 days Over 7 days to 1 mth Over 1 mth to 3 mths
Over 3
Shoes 0 0 0 0 0
Belts 0 0 0 0 0
Shirt-classic 7459 0 0 0 0
Shirt-comtemp 7459 0 0 0 0
Utees 0 0 0 0 0


ACCESS:

desc value Excel_link
M1_BBB_SHOE7D 0 B48
M1_BBB_BELT7D 0 B49
M1_BBB_SHRT7D 0 B50
M1_BBB_SHRT27D 0 B51
M1_BBB_TSHRT7D 0 B52