+ Reply to Thread
Results 1 to 3 of 3

Button to insert new row, clear data and keep formulas

  1. #1
    Registered User
    Join Date
    10-24-2013
    Location
    sdsada
    MS-Off Ver
    Excel 2007
    Posts
    9

    Button to insert new row, clear data and keep formulas

    Hi to everybody!

    I have a big database which is constantly updated. For now it has 1596 rows. I want to make a button which will insert a new row after the last one(when it is filled with data), and the new row to look just the same like the previous one(but with cleared information), to keep the formulas in columns P Q R and S and the First column A is a serial number - it must keep the next number after the previous one..

    i have this for now:
    Please Login or Register  to view this content.
    The button is placed 2 in the second row under the last row.
    It keeps the formulas and puts the next serial number, but it copies the last row and the new one is with the same information as the last, it is not cleared of information as i want to.. Can you help me? thanks in advance

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,659

    Re: Button to insert new row, clear data and keep formulas

    Try this...
    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 10-24-2013 at 05:55 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    10-24-2013
    Location
    sdsada
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Button to insert new row, clear data and keep formulas

    Thanks for the fast reply! it works perfect! i gave you + rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Command Button using VBA, to insert a row with formulas below
    By AlexKost in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2013, 11:50 PM
  2. Comand button to insert new row and copy formulas only
    By ir_eddie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2012, 06:14 AM
  3. [SOLVED] Clear button, add warning dialogue box that asks: Are you sure you want to clear?
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-21-2012, 02:41 PM
  4. Button to clear sheet and automatic clear rows
    By sandbach in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2010, 02:06 PM
  5. Insert rows and formulas above Button
    By alexandruc in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-17-2010, 02:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1