Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
need a macro or vba code written for excel
Name: DJEN Date: June 25, 2009 at 13:20:27 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
I am attempting to create a spreadsheet that tracks attendance and does two things. the first thing is to assign a point value to reasons why a person has missed work and total that for the entire year (that part I have worked out) the second part would be to track vacation time, sick time, and 2 other paid days off then when it reaches the anniversary date reset the balance on what they have used for the entire year without changing the balance of the items being tracked for the entire year. any help is appreciated
Summary: Thanks. This means that in your macros you create new filenames such as 10058.XLS. This is done manually. After the template (INVSALE.XLS) with new invoice number and details have been populated, I ...
Summary: Depending on what your data looks like, you may not need a macro. Assuming your dates are all 6 digits, then the "code" you want to search for is: =LEFT(A1, LEN(A1)-7) 7 is used to get rid of the spac...
Summary: I need to write a macro that will Match data in ColumnC Sheet1 with ColumnA Sheet2, follow same row over in Sheet2 to ColmnG and copy that data to ColumnO Sheet1 corresponding with ColumnC Sheet1, usi...
