+ Reply to Thread
Results 1 to 2 of 2

Button for staff to add a new blank row into table

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    london, England
    MS-Off Ver
    Excel 2010
    Posts
    49

    Thumbs up Button for staff to add a new blank row into table

    Hi,

    I have a table that will have a drop down list in all of the cells in column F that are in the table. (I think I have the drop down list figured out, as someone has managed to help me with that!)

    I want to create a button that makes it so every time a new row is needed for new stock entries etc, the user just has to press the button and it should just create a new row within the table. Simples .

    Is this achievable? And if it is, what is the best way to go about it?

    Table width is from Column C - Column J.

    Best,

    Antligen

  2. #2
    Registered User
    Join Date
    01-20-2014
    Location
    london, England
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Button for staff to add a new blank row into table

    Fixed problem!

    I recorded a macro that inserted a new cell in the row and applied it to a button. Good times :D

+ 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. Replies: 1
    Last Post: 01-29-2014, 12:57 AM
  2. Providing how many times staff members have been late by staff ID
    By SG56001235 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2013, 10:47 PM
  3. Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet
    By Marie Snell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 11:04 PM
  4. Cut & paste selected cells, by pressing button, to first blank row in table
    By Ejb123erok in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-30-2013, 08:11 AM
  5. [SOLVED] Trying to create table/chart to show where staff is located along
    By Soraiya in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-07-2005, 10:05 AM

Tags for this Thread

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