Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
link worksheets
i am working with a worksheet in the following way
column A through F have been linked with the corresponding columns in another workbook. columns G through J contain data that i have to fill in manually. For example A1 contains the name of a client (link) and G1 contains transportation means. the problem is, however, that i trace errors whenever i sort records (data). rows containing data in columns A through F remain correct, but the same rows contain errors in columns G through J contain errors. data in the same row get mixed up. Am i doing something wrong or is it impossible to work with a <<partially linked worksheet please help me solve this problem!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
link worksheets
If you have relative addresses in your formulas, you can run into this
problem. -- Regards, Tom Ogilvy "angie" wrote in message ... i am working with a worksheet in the following way: column A through F have been linked with the corresponding columns in another workbook. columns G through J contain data that i have to fill in manually. For example A1 contains the name of a client (link) and G1 contains transportation means. the problem is, however, that i trace errors whenever i sort records (data). rows containing data in columns A through F remain correct, but the same rows contain errors in columns G through J contain errors. data in the same row get mixed up. Am i doing something wrong or is it impossible to work with a <<partially linked worksheet? please help me solve this problem!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to link the two worksheets | Excel Discussion (Misc queries) | |||
link to other worksheets | Excel Discussion (Misc queries) | |||
Link worksheets | Excel Discussion (Misc queries) | |||
link several worksheets | Excel Discussion (Misc queries) | |||
Link Worksheets | Excel Worksheet Functions |