if formula

  • Thread starter Thread starter nishkrish
  • Start date Start date
N

nishkrish

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.
 
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
 
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
 
Back
Top