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