Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update function
Hi,
i have a workbook that contains a master sheet and about 7 other sheets by department. When the user "updates" I would like to look at project codes (Admin1, Admin2, etc) on the department sheets and ad any records that do not appear on the master. Is there an easy way to search the colunm in the department sheet and compare it to the "master", then ad any records that do not appear on the master. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update function
See Chip Pearson's page on working with Uniques and Duplicates. this should
get you started: http://www.cpearson.com/excel/duplicat.htm specific information is toward the bottom although you should read the whole page. -- Regards, Tom Ogilvy "JC" wrote in message ... Hi, i have a workbook that contains a master sheet and about 7 other sheets by department. When the user "updates" I would like to look at project codes (Admin1, Admin2, etc) on the department sheets and ad any records that do not appear on the master. Is there an easy way to search the colunm in the department sheet and compare it to the "master", then ad any records that do not appear on the master. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
now function not to update | Excel Discussion (Misc queries) | |||
now function not to update | Excel Discussion (Misc queries) | |||
Don't Update Function | Excel Discussion (Misc queries) | |||
function update | Excel Worksheet Functions | |||
How to get function to update itself with changes | Excel Programming |