1. Welcome to Tacoma World!

    You are currently viewing as a guest! To get full-access, you need to register for a FREE account.

    As a registered member, you’ll be able to:
    • Participate in all Tacoma discussion topics
    • Communicate privately with other Tacoma owners from around the world
    • Post your own photos in our Members Gallery
    • Access all special features of the site

Excel VBA Help

Discussion in 'Technology' started by memario1214, Oct 6, 2012.

  1. Oct 6, 2012 at 5:33 PM
    #1
    memario1214

    memario1214 [OP] Vivid Illumination Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    13,025
    Gender:
    Male
    First Name:
    Colton
    MT recently relocated to Willmar, MN
    Vehicle:
    05 Dub Cab TRD Sport 4x4
    TRD Cold Air Intake, rear cat delete with Aero Turbine 2525, Maglite mount mod, white LED's all around, white gauges w/blue needles, Tinted Tails, Morimoto 32" XBAR LED Bar, Truxedo Lo-Pro QT Tonneau, Pioneer AVIC X-920 BT touchscreen, FX-R Retrofit, LR UCAs, OME 3" Lift w/ Dakar leafs, DTLT Headers, Walbro 255 fuel pump, TRD S/C, Hankook Dynapro ATM tires
    I have built a very simple inventory and profit workbook to help with our little company store and I am trying to set it up so that each week is a new sheet. I need some VBA code that takes and copies the current sheet, clears Items on Hand and Items Sold columns, makes the new sheet name today's date, and then calculates the profits Year to date by adding the profit totals from each sheet up to this point. I pretty much wrote it I think, but was having some issues clearing the tables and repopulating the button to run the macro for some reason? Any help is much appreciated

    The original format is xlsm, but TW won't allow macros nor will it allow the new file formats. My final format will be xlsm... As I know this will need macros
     

    Attached Files:

To Top