|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 31st, 2009, 06:23 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
July 31st, 2009, 10:50 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
August 1st, 2009, 12:54 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
