Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need macro that would enter certain text value in specified cells if
certain value is entered in another cell. For example i have following worksheet A B C D 1 Biz xxx yyy zzz 2 3 I need macro that would enter "-" in column B and C if value "Priv" is entered in column A (I select values from dropdown that is specified for column A). Macro should trigger when i select value "Priv" from column A cell. In this case if i would select cell A2 and then choose value "Priv" then value "-"should automaticaly be inserted in cell B2 and cell C2 and cursor should stop on cell D2 (the active cell after macro runs should be D column cell) This should be applied for all cells in columns A,B,C,D Any ideas ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can insert digital ink into Excel cell or a cell comment? | Excel Discussion (Misc queries) | |||
'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
How do i insert a image to a single cell then click on the cell & | Setting up and Configuration of Excel |