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

    memario1214 [OP] Vivid Illumination Vendor

    Oct 1, 2009
    First Name:
    Gillette, WY
    05 Dub Cab TRD Sport 4x4
    Yeah, I gots boost
    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