+ Reply to Thread
Results 1 to 2 of 2

Add data to bottom of table

  1. #1
    Registered User
    Join Date
    12-06-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    13

    Add data to bottom of table

    Hello,
    Could someone help me with a VBA code, I need to add data to a table on another sheet using a button.
    The button needs to insert a new row at the bottom of the table and and populate it with the details filled in in the first sheet.

    I have attached a sample of my data.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Add data to bottom of table

    Try:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. how to get the top three and the bottom three values from the data table?
    By sumesh56 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2016, 01:01 PM
  2. Show total at data table bottom (and hidden in stack)
    By ahearnden in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2015, 09:22 AM
  3. Help with VBA code to find bottom row in pivot table and fill table cell borders
    By Eric111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 07:15 PM
  4. Append Refreshed Data to the bottom of the table
    By MissLungen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-06-2014, 09:38 AM
  5. When saving, data from userform is stored at the bottom of table. Why?
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2010, 03:39 AM
  6. Lookup when values located in a row across bottom of table of data
    By Mark444 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2006, 03:39 PM
  7. Replies: 1
    Last Post: 01-24-2005, 09:06 PM

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