Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically adding row when data is entered
I have a spreadsheet that I am needing to add 2 rows each time data is
entered into column "D". Example: A B C D 1 XX XX XX Data column 2 BLANK ROW 3 Here is where I want to have something that will automatically add three rows (3,4,5), Once data has been entered into "D1" 4 BLANK ROW 5 Same as #3 I want three more rows (6,7,8) when data is entered in "D3" and so on. 6 BLANK ROW 7 Again, same as #3&35 I want three more rows (8,9,10) when data is entered in "D5" and so on. Down to around a possibility of 30 rows. This spreasheet also have several different "heading" types..such as.. Topic (which will have the above data & rows under it) then... Topic 2 (and this will also have data and the need to insert a number of rows) Topic 3...and so on I hope someone can help me....And I don't follow Macros very well...may have to really spell it out for me....thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding rows once data is entered | Excel Discussion (Misc queries) | |||
data from one workbook automatically entered into another workboo. | Excel Discussion (Misc queries) | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
How do I get data automatically entered into a cell? | Excel Worksheet Functions | |||
How do I lock a cell automatically after it has data entered. | Excel Discussion (Misc queries) |