Hi

I've got worksheets 1 and 2. The cells in worksheet 2 have formulae in them containing their counterparts in worksheet 1, ie A1 in worksheet 2 depends on the value of A1 in worksheet 1, etc. I regularly add data to worksheet 1 and then sort it after I've added to it. How can I get worksheet 2 to update according to the new sorted order of worksheet 1?

Thanks