Hi,

In my workbook I have several worksheets. In worksheet1 I can plot in new users, like
1100 Name1
1120 Name2
3319 Name3
1410 Name4
In worksheet2 I can fill in these users' working hours, and the two first columns are linking to the user list in worksheet1.

However, here's the problem: I want the users to be sortet by numbers, from lowest to highest - this isn't a problem. But when I sort the users in worksheet1, that also affects worksheet2, obviously, but only the user number and names. The working hours that I've insertet are not affected by sorting the users in worksheet1, but they definitely should.

I've been googling around trying to find an answer for linking the working hour cells to the name they belong to, but I haven't found an answer.

This should be possible, in my opinion, but I'm not sure how, therefore I'm asking you for help.

If something's unclear, please ask, and I will try to explain better.

I've uploaded a test sheet here.