| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input formula into a column via macro
Hi
How can I input this formula into col P via a macro =INDEX([FXAppl.xls]Sheet1!$C$1:$C$100,MATCH(LEFT(Sheet3!A1,4)&"*",[FXAppl.xls]Sheet1!$B$1:$B$100,0)) thanks regards, francis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with formula for last input in column | Excel Worksheet Functions | |||
| inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
| A formula or macro that will place the date in an adjacent column Bany time something is typed in column A | Excel Programming | |||
| run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
| Macro with input box to Select a column on active sheet | Excel Programming | |||
Threaded Mode
