| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert cell from an if statement
I have a worksheet that I want an if statement that says if one cell =
another, then do nothing, otherwise insert a blank cell. Is there a way to do this??? -- Many Thanks, Paula |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert cell from an if statement
Not without VBA if you want to "insert" a cell - do you mean insert as in
'add a cell'? "Billing Goddess" wrote: I have a worksheet that I want an if statement that says if one cell = another, then do nothing, otherwise insert a blank cell. Is there a way to do this??? -- Many Thanks, Paula |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert cell from an if statement
If you mean physically insert a new cell, as in use the menu to Incert | Cell
and then choose Shift Right/Down, then the answer is that it can be done, but would have to be done with a macro. "Billing Goddess" wrote: I have a worksheet that I want an if statement that says if one cell = another, then do nothing, otherwise insert a blank cell. Is there a way to do this??? -- Many Thanks, Paula |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert cell from an if statement
Yes, insert a cell as in Insert/cells/shift cells down
-- Many Thanks, Paula "Toppers" wrote: Not without VBA if you want to "insert" a cell - do you mean insert as in 'add a cell'? "Billing Goddess" wrote: I have a worksheet that I want an if statement that says if one cell = another, then do nothing, otherwise insert a blank cell. Is there a way to do this??? -- Many Thanks, Paula |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert cell from an if statement
I'm not sure how it would work with a macro. I am comparing two cells and if
they match then nothing happens, if they don't match, then the statement would force a new cell to be entered, thus shifting the cells below down. -- Many Thanks, Paula "JLatham" wrote: If you mean physically insert a new cell, as in use the menu to Incert | Cell and then choose Shift Right/Down, then the answer is that it can be done, but would have to be done with a macro. "Billing Goddess" wrote: I have a worksheet that I want an if statement that says if one cell = another, then do nothing, otherwise insert a blank cell. Is there a way to do this??? -- Many Thanks, Paula |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert cell from an if statement
Sub foo()
With ActiveSheet If Range("A2").Value < Range("A1").Value Then Range("A2").Offset(1, 0).Insert Shift:=xlDown End If End With End Sub Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 08:38:15 -0700, Billing Goddess wrote: I'm not sure how it would work with a macro. I am comparing two cells and if they match then nothing happens, if they don't match, then the statement would force a new cell to be entered, thus shifting the cells below down. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to insert a special character (arrow) in IF statement | Excel Worksheet Functions | |||
| Can an IF statement insert an picture? | Excel Discussion (Misc queries) | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| how can I insert a macro into a boolean statement | Excel Worksheet Functions | |||
| How do you insert an "or" operator in an "IF" statement. | Excel Worksheet Functions | |||
Linear Mode
