Mike "Wuzzy121". Rest in peace, brother

Go Back   Tacoma World Forums > Off-Topic > Technology

Notices

Excel VBA Help

Reply
 
Thread Tools Search this Thread
Old 10-06-2012, 06:33 PM   #1
Vivid Illumination
memario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shedmemario1214 is one of the sharper tools in the shed
 
memario1214's Avatar
Name: Colton
Joined: Oct 2009, #23628
Location: MT recently relocated to Willmar, MN
Age: 24
Gender: Male
Posts: 12,828
memario1214's Tacoma Gallery
Excel VBA Help

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
File Type: xls The Company Store2.xls (37.0 KB, 34 views)
  Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Help! bulhas Technology 3 06-07-2012 11:03 PM
Excel Pros! I need your help! Blasphemous Technology 23 06-05-2012 12:08 PM
Excel Experts out there? memario1214 Technology 25 11-08-2011 10:39 AM
iPad and Excel Mitch Technology 6 08-22-2011 11:24 AM
Help With Excel jdkeller Technology 8 01-10-2011 06:57 AM


Copyright © 2014 Tacoma Forum. Tacoma World is not owned by, or affiliated with Toyota Motor Corporation.