Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DOUBLE POST--Sorry wrong category first--Convert to VB Pleaseeee
Can someone please write this in VB for me because when i drag this down 20, 000 rows and 10 columns across.....I get quite the file. Can you make it so that it says N/A for ones that it doesn't find. Id like to be a macro that i just run that does it for me "real quick". =IF(Code1=ifthen.xls!CODECOL,INDEX('[ifthen.xls]Final Merge Fields'!$1:$65536, MATCH(A47947,'[ifthen.xls]Final Merge Fields'!$A:$A,0),MATCH("Code",'[ifthen. xls]Final Merge Fields'!$1:$1,0)),"") Thank you sooo very much in advance. Derek -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200507/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DOUBLE POST--Sorry wrong category first--Convert to VB Pleaseeee
you people blow Derek Y wrote: Can someone please write this in VB for me because when i drag this down 20, 000 rows and 10 columns across.....I get quite the file. Can you make it so that it says N/A for ones that it doesn't find. Id like to be a macro that i just run that does it for me "real quick". =IF(Code1=ifthen.xls!CODECOL,INDEX('[ifthen.xls]Final Merge Fields'!$1:$65536, MATCH(A47947,'[ifthen.xls]Final Merge Fields'!$A:$A,0),MATCH("Code",'[ifthen. xls]Final Merge Fields'!$1:$1,0)),"") Thank you sooo very much in advance. Derek -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200507/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double category | Charts and Charting in Excel | |||
What have I done wrong. I now cannot double click on a file to ope | Excel Discussion (Misc queries) | |||
hate to double post but have not really got a good answer, more lo | Excel Worksheet Functions | |||
What is wrong with my Post? | Excel Worksheet Functions | |||
oops wrong place to post | Excel Worksheet Functions |