Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Code??
"Jcraig713" wrote in message ... My spreadsheet data look like this: A B C D E F G H hlduniq Sclname StuLast Stufirst house# StrNam City Zip 99 BldgA Black John 100 Second Detroit 48330 100 BldgA Smith Jane 133 Main Detroit 48332 100 BldgB Smith John 133 Main Detroit 48332 101 BldgA Doe Jane 1001 First Detroit 48331 102 BldgB Doe John 1001 First Detroit 48332 What I would like the code to do is to return just the two rows (the Doe's on the bottom) that the house number and the first three digits of the street name are the same, but the household unique ID differs. In my system, this is a duplicate address that needs to be amended to one house unique. I just need a way to not have to manually look through 10,000 records by hand. Can this be done? Can you help? yes it can be done. look in the Excel VBA help system to learn how to write a VBA macro. use cell.value() and iterate through the cells that you mbneed to cover. AGP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Code?? | Excel Programming | |||
Help with creating code?? | Excel Programming | |||
Help Creating Code | Excel Programming | |||
Code that keeps creating a toolbar - where might that code be hidden? | Excel Programming |