Automatically insert rows in Excel

Closed
dvl2sum - 21 Mar 2009 à 20:58
epsiman Posts 306 Registration date Tuesday 18 November 2008 Status Member Last seen 2 February 2010 - 22 Mar 2009 à 11:24
Hello,

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
Related:

2 responses

myluv3 Posts 5 Registration date Tuesday 20 January 2009 Status Member Last seen 9 June 2009 3
22 Mar 2009 à 07:21
hi,
try this link to get all what you need to know about excel:
https://excel.tips.net/T002339_Inserting_Rows.html
epsiman Posts 306 Registration date Tuesday 18 November 2008 Status Member Last seen 2 February 2010 162
22 Mar 2009 à 11:24
I don't think it's possible but you can try the link he gave you...