link worksheets

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

Guest

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!!!
 
If you have relative addresses in your formulas, you can run into this
problem.

--
Regards,
Tom Ogilvy

angie said:
i am working with a worksheet in the following way:

column A through F have been linked with the corresponding columns in
Click to expand...
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
 
what do you mean by relative addresses? can you give me a formula example of this kind

----- Tom Ogilvy έγÏαψε: ----

If you have relative addresses in your formulas, you can run into thi
problem

--
Regards
Tom Ogilv

angie said:
i am working with a worksheet in the following way
Click to expand...
another workbook. columns G through J contain data that i have to fill i
manually. For example A1 contains the name of a client (link) and G
contains transportation means. the problem is, however, that i trace error
whenever i sort records (data). rows containing data in columns A through
remain correct, but the same rows contain errors in columns G through
contain errors. data in the same row get mixed up. Am i doing somethin
 
=$B$1 is absolute

=B1 isn't

the first shouldn't be adjusted by excel, but the second can be.
 
relative formulas have solved the sorting problem only in the actual worksheet. when i sort the original (source) worksheet and the formulas become updated, only the columns containing links are sorted and the remaining ones are not. as a result data get mixed up. is there a way to solve this problem or do i have to avoid sorting the original worksheet? and if this is true is there a way to <<lock>> sorting? Sorting, however, is a very useful tool when working with data in excel

pls help me!

----- Tom Ogilvy έγÏαψε: ----

=$B$1 is absolut

=B1 isn'

the first shouldn't be adjusted by excel, but the second can be
 
Back
Top