| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with macros
Forgive me if this posting is in the wrong area of this forum. I would like
to create a macro that inserts a formula into each cell in column I where the column A is populated for that row. The formula I'd like to use is: =LOOKUP(B2,'06-2005'!B:B,'06-2005'!J:J) I want the formula to reflect the previous worksheet (month-1) rather than a fixed name ('06-2005') putting in a fixed sheet name. Is this possible? If so, how? Thanks in advance, Marina Garrison |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
| convert lotus 123w macros to excel macros | Excel Programming | |||
| Macro Size Limit / open macros with macros? | Excel Programming | |||
| Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
| Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
Threaded Mode
