Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to replace one dynamic variable with another dynamic variable
I have a large file that contains long product descriptions in one workbook
file in say Column C. Within those descriptions, there are year ranges. for example, a description may say "fits years 1995-98". These descriptions change for every product I am listing. What I need to do is change the 1995-98 to read 1995, 1996, 1997, 1998 instead. On a second workbook, I have listed all of the possible shortened year ranges (1995-98) in column A. In Column B, I have the expanded year ranges (1995, 1996, 1997, 1998). My question is, how can I write a function statement that looks line by line through Column C on Worksheet 1 for the dynamic shortened year ranges, then looks for the same value from column A worksheet 2 and replaces with the expanded year ranges from column B on worksheet 2? I really dont want to have to do a replace individually line by line. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a dynamic list based on a minimum common variable. | Excel Worksheet Functions | |||
Dynamic scenarios - more than 2 variable using data tables in Exc | Excel Discussion (Misc queries) | |||
3 variable find and replace | Excel Discussion (Misc queries) | |||
dynamic summed range based on a variable | Excel Worksheet Functions | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |