+ Reply to Thread
Results 1 to 3 of 3

VBA Code Button that runs through Date list Table and Copies onto another table

  1. #1
    Registered User
    Join Date
    02-28-2018
    Location
    Edinburgh
    MS-Off Ver
    2016
    Posts
    12

    VBA Code Button that runs through Date list Table and Copies onto another table

    Hi All,

    I am a VBA novice and thus is why I am on here looking for help.

    My issue is that I am looking for a piece of code that can be activated by a button and it runs through the data list sheet and identifies which sections fulfill the criteria for each months table. The most difficult part that I am looking for help with is how the code can identify if there is more cell rows required that it adds onto the end of the existing table and if there is less required(empty rows) then it removes these. I have included an example to refer to.

    Any help would be hugely appreciated and thanks in advance :)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,047

    Re: VBA Code Button that runs through Date list Table and Copies onto another table

    like :
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-28-2018
    Location
    Edinburgh
    MS-Off Ver
    2016
    Posts
    12

    Re: VBA Code Button that runs through Date list Table and Copies onto another table

    Thanks for the response ranman,

    However this doesn't solve my issue of identifying what date to stop at and move onto the next month data whilst controlling the overall formatting of the sheet.

+ 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. Button to add or remove table filters and button to refresh table
    By cmorten82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2015, 11:26 AM
  2. Replies: 1
    Last Post: 12-19-2014, 02:08 PM
  3. [SOLVED] Code to move data from an entry table to a historical table by date.
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2014, 11:04 AM
  4. Code runs with F8 but not from button
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2014, 02:09 AM
  5. How to get table just clicking a list down button
    By Mahadev87 in forum Excel General
    Replies: 0
    Last Post: 03-01-2013, 10:30 AM
  6. Ok button runs code 17 times w/o loop.... Why?
    By contaminated in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2012, 05:19 AM
  7. [SOLVED] code behind the command button that runs another macro
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2012, 06:04 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