Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically add another row when then one above contains data
I am trying to automate an excel spreadsheet so that when any value is entered in any cell it will then create another row below with the same format as the row above. For example, I enter a value in cell A1 which is formatted with a surrounded border. This then automatically creates another row below with the same format for that row. I've tried conditional formatting but only offers minimal formatting of a thin border. Can anyone suggest a VB solution please ? *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically add another row when then one above contains data
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from one tab to other tab automatically | Excel Worksheet Functions | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
Add or Less data automatically. | Excel Programming | |||
Compare data and automatically enter data. | Excel Discussion (Misc queries) | |||
automatically expand chart data series as data is added | Charts and Charting in Excel |