Automatically insert rows in Excel
Last answer on Mar 22, 2009 3:24:33 pm GMT dvl2sum, on Mar 22, 2009 12:58:32 am GMTHello,
I'm trying to set-up an automated macro that will cause a row to be inserted when a cell value is changed. I have a sheet formated in the following way:
a row of text,
then a blank row,
then a 2nd blank row.
What I want to do is have a row inserted above the 2nd blank row whenever the cell in column B of the row above it goes from empty to having any sort of text. which would produce the following outcome:
original row of text
row with text entered in cell B2
newly inserted blank row
2nd blank row.
I have never used macros before, but I thought I would see if I could find this answer here in an effort to automate this workbook a bit.
Thank you
Configuration: Mac OS X Safari 525.27.1
Hi,
|
"different rows" excel paste sort- Automated copy a excel file and rename it
- Delete duplicate rows in excel combine adjacent columns
- Excel 2003 automatically hide row when value is zero
- Excel automatically import data from another worksheet
- Excel blank rows end
- Excel insert rows activecell
- Excel multiple rows to single column
- Hide blank rows excel
- How do i insert rows in excel using a macro
- How to insert data in excel without the program change to date
- How to insert the number 1 to 100 in excel column
- How to match rows in excel
- Insert animated gif excel
- Insert rows using macro
- Transpose column with empty row into separate rows excel macro
- Using vba automatically update the module in one excel to another
- Vb.net excel read rows.count
