Automatically insert rows in Excel

Closed
dvl2sum - Mar 21, 2009 at 08:58 PM
epsiman
Posts
307
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
- Mar 22, 2009 at 11:24 AM
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

2 replies

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