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.
Bookmarks