(Sheet Attached for clear view)..
I have sheet1 having 4 columns which stores large data about tasks we perform.
First column stores id (number) of the task, 2nd column stores TITLE, 3rd- Completed work, 4th- Remaining work.
In sheet2 There are same 4 columns but only one row.
Assume that row is changing after every two minutes. The id, title, completed work and Remaining work is changing.
What i want is, whenever any change happens in this row. i.e. cells A2, B2, C2 and D2 in sheet2,
The task only with the same id in Sheet1 Should also change its other information. i.e. Title, completed work and Remaining work in sheet1 with same id only should change.
So we have to first search for the same id in Sheet1, Column A which was changed in cell A2 in Sheet2 And then make other changes in row.
Please give me some idea how do i do it...
Bookmarks