| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a new row based upon an if/then command
I would like to insert a new blank row when there is a value in a certain
colum of our spreadsheet. How can I insert the row automatically after the row where the condition is satisfied. for example.... =IF(a1=popcorn,yippie,"insert a blank row below a1...") How the heck do I do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'Insert' 'Object' command: I have 11 blank rows of objects at top | Excel Discussion (Misc queries) | |||
| Name command in Insert Menu | Excel Discussion (Misc queries) | |||
| can i insert a print command in a worksheet? | Excel Discussion (Misc queries) | |||
| Can I insert roundup command into different formulas in excel? | Excel Worksheet Functions | |||
| To set up a command that will insert a row, every fifth row? | New Users to Excel | |||
Threaded Mode
