Excel 2007 : Automatically insert a row when cells below are filled.

**garridosk** · 11-07-2011, 01:23 PM

Hello everyone. I am a novice Excel user - I know nothing about macros or VBA. I have a log for keeping track of company document changes. These are text entries so there are no formulas in this log. As the first cell is populated, I need a blank row to automatically appear above it so the entries are in descending chronological order. Is it possible to have Excel do this? I have attached the log to clarify my question.
Thank you so much!

**davegugg** · 11-07-2011, 01:49 PM

This code will shift the row down once you fill in the effective date cell in G3. This code needs to be added to the DCO Log Blank sheet's code page.

Please Login or Register  to view this content.

**garridosk** · 11-08-2011, 01:36 PM

Thanks Dave!

Wow, I've never worked with code before. It worked perfectly! Do you know of an easy reference book that I can buy to do other things with code?

Thanks again, Sandra

**davegugg** · 11-08-2011, 03:00 PM

Hold down Alt and press F11 to bring up the VBE. On the left you will see a pane titled Project - VBAProject. Under Microsoft Excel Objects, double click Sheet2 (DCO Log Blank) This will bring up Sheet2's code page, which should be empty. Paste the following code in it:

Please Login or Register  to view this content.

Close the VBE. You will have to save your workbook as a .xlsm file instead of a .xlsx.

**garridosk** · 11-08-2011, 03:40 PM

When I try to save, the options are not identified by extensions, just descriptive titles:

Excel Workbook
Macro-Enabled Workbook
Binary Workbook
Other Formats

Is *.xlsm one of these?

Thanks,
Sandra

**davegugg** · 11-08-2011, 03:56 PM

Yes, it is Macro Enabled Workbook

**garridosk** · 11-08-2011, 06:31 PM

Great, thanks so much!

Update: Help! See post above (#7).

**garridosk** · 11-09-2011, 11:42 AM

I'm not sure what happened to my workbook. I saved it as an xlsm file yesterday. I opened it this morning and it doesn't work. The code was not there anymore. I added it again but it's still not working. Any suggestions?