Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
This is a bit of a re-post, but it seems to have fallen off the radar a bit. I have a macro that populates the username in a cell, that works fine. But I dont want to have to Run the macro (or use Ctrl+Shift+U, as i have assigned) for this to populate. The username is needed to populate in M, based on the value of column K being V For example: K M ----------- v username v username v username v username K can only be "v" due to Data Validation. But it can be on any row. Basically to put it in formula terms. =IF($K1="v", Run Macro in M1) Is this do-able? Ive seen suggestions with absolute cell references, but this isnt absolute. If anybody can help, or tell me if its even possible, it would be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating an advanced Macro | Excel Discussion (Misc queries) | |||
Help with fairly advanced list/print macro. | Excel Discussion (Misc queries) | |||
Advanced macro | Excel Discussion (Misc queries) | |||
HELLLP!!!! This should be fairly simple I would think! | Excel Discussion (Misc queries) | |||
Fairly Complex IF Statement | Excel Worksheet Functions |