Hi all,
Is this possible in excel,
i have a w/book with 2 sheets.if a saleperson on figures sheet number changes then his data on totals sheet changes to suit. example if salesperson john(V2) on figures sheet changes his number in W2 from 3 to 4 then on totals sheet should now display data from column P2:P11 and not his current data (k2:k11) .
I hope this is clear enough for someone to understand.
Bookmarks