+ Reply to Thread
Results 1 to 2 of 2

Modifying the code in an existing workbook to add extra Category fields

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Modifying the code in an existing workbook to add extra Category fields

    Hi first time on here and I’d like a little help modifying the code in an existing workbook to increase the number of categories available for input, I don’t have much of a clue when it comes to code and all the comments in the code are in Japanese.
    The attached the workbook (In01)ED.xls this is used to input, store and summarise employee hours against different categories daily through an input sheet, the DB sheet in the same workbook stores all the data. Along with the above there is a (In00)Setting.xls which allow changing of category names and date parameters within the (In01)ED.xls work book, to make things more complicated in the folder that the file sits in is another folder called DataBase and within it is a (11)ED.dat file which I believe somehow plays a part in moving/storing the data, from what I can see they all work together.
    Basically I would like to increase the number of available categories fields across the top of the input sheet to include more items, I need an addition 15 categories (columns). Any help of making any sense of this would be greatly appreciated.

    Note: that (11)ED.dat file is zipped as it seems that .dat is not a Valid file extension to upload here..


    thanks in advance for any assistance.
    Attached Files Attached Files
    Last edited by adriantainsh; 06-05-2014 at 09:03 AM.

  2. #2
    Registered User
    Join Date
    06-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Modifying the code in an existing workbook to add extra Category fields

    I've no replies ... just wondering ...Is this to difficult to modify? and am I just better off starting from scratch ... or have I failed to clearly explain what the struggle was?

+ 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. [SOLVED] Modifying VBA code so calender populates on certain columns and not whole workbook
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2013, 10:19 AM
  2. [SOLVED] Add two more columns, modifying an existing VBA code help.
    By Anka in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 02-17-2013, 01:24 PM
  3. Modifying Existing Code to Check if the entry exists
    By jason_kelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2010, 10:39 AM
  4. Modifying existing VBA code to find different file name
    By PittsburghEng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2010, 03:24 PM
  5. Help modifying existing VBA code
    By camcafe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2008, 11:02 AM

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