Hello
I could really use some help with my problem . I am trying to sort my data on Sheet1 using auto sort, and yes I am selecting the whole line when I am doing this.
The thing is that after the sort, I have cells in Sheet2, that reference the data from Sheet1 (and its a relative reference) but still Excell looks at it as an absolute reference, and the value will change after the sort.
I am using excel 2003.
Any suggestions?
thank you all
Bookmarks