if formula
 

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

if formula
 

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

if formula
 

How about a relatively easy, fast, normal formulas set-up
which automates the exact functionalities that you seek
(based on my past response to similar queries)

Illustrated in this sample:
http://www.savefile.com/files/1945932
Parent to Child AutoCopy Model based on KeyCol Values.xls
(full construct details, nicely rendered, easy to understand n adapt)

Celebrate success, hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"nishkrish" wrote:
i have data in sheet 1 and if the column AG has agent code 1,2,3,4, and so on
i have created 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