Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
advanced macro for find replace
Here is a sample file. Sheet1 is my main sheet. The highlighted gree cells are the names and the highlighted orange cells are the respectiv categories that needs to be changed from the default (expense) to a nam specific category. example. IF fedex is the name the category should be shipping not expense. Sheet2 contains my database of names/appropriate cateogries. Column was my attempt to change the category. As you can see it properl enters the name specific category when it sees a matching name. Th problem is I need to get that category back over the sheet1 to chang the proper cell (orange highlighted cells). There are other issues I have but this is the main first step. Hop this makes it clearer. Thanks Kausewa -- kausewa ----------------------------------------------------------------------- kauseway's Profile: http://www.excelforum.com/member.php...fo&userid=1512 View this thread: http://www.excelforum.com/showthread.php?threadid=26779 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced find and replace help | Excel Worksheet Functions | |||
Advanced Find and replace | Links and Linking in Excel | |||
Advanced Find and Replace Question | Excel Discussion (Misc queries) | |||
Advanced Find and Replace Question | Excel Worksheet Functions | |||
find and replace macro need help | Excel Programming |