Hi

-Navigate to the cell in the sheet that needs to update automatically
-Press the equals (=) key
-Navigate to and click on the cell that contains the value required
-Press Enter



--
Steve

"nishkrish" wrote in message
...
i have data in sheet 1 and if the column AG has agent code 1,2,3,4, and so
on
i have creatred different sheets for the agents i want when the data is
inputed in sheet 1 and when column AG is updated the information should
be
copied to respective sheet.
--
Nisha P