Sorting cells that are referenced in different sheet

[elduru]

Sorting cells that are referenced in different sheet <hr style="color: rgb(209, 209, 225); background-color: rgb(209, 209, 225);" size="1"> <!-- / icon and title --> <!-- message --> <!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --> <!-- END TEMPLATE: ad_showthread_firstpost_start --> 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
<!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --> <!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

​

 

[Yard]

AFAIK you'll need to change the way Sheet2 is picking up the data from Sheet1. Sorting changes the values in the cells rather than "dragging and dropping" the cells into a different order.

Tell us what data you want to pick up and maybe we can get a solution.

Welcome to the Board, BTW!

 

[elduru]

Thank you.

I would rather not use lookup function. The rest in the office are not that good with it. It needs to be as simple as possible

I will post a file but i need to learn how first.

 

[Yard]

Doesn't have to be complicated, and once you've set it up you could protect it from being corrupted.

Up to you.