Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a row depending on cell value
It would seem I wasnt thorough enough with my question, my apologies.
What I need is this. I have 6 Rows numbered 1-6 and in the adjacent cells (b1:b6) i enter a value. It may be a number or it may be text. I need to add a row underneath (numbered 7,8 & 9 as required) if anything but a numeric value is entered in b1:b6. I hope this example will help. A B 1 1 3 2 2 22 3 3 ab 4 4 2 5 5 65 6 6 mon 7 7 << row added awaiting data 8 8 << row added awaiting data Sorry for not being thorough with it first time TIA Esra |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
colour of a row depending on cell value | Excel Discussion (Misc queries) | |||
Round one cell depending on value of another | Excel Worksheet Functions | |||
Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
How do I modify a row depending upon what a cell value is? | Excel Worksheet Functions |