Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.access
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autoupdate a reference to a cell on another worksheet | Excel Worksheet Functions | |||
How do I access Outlook Express email address book using Excel | Excel Discussion (Misc queries) | |||
autoupdate ppt embedded in excel file to which it is also linked | Excel Programming | |||
How would you access an email address in Outlook from excel? | Excel Programming | |||
In Excel how can I access the Name Box value (address) in a formu. | Excel Worksheet Functions |