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.
Duplicate Macro or Function
Name: VillageGirl Date: March 25, 2009 at 08:03:18 Pacific OS: Microsoft Windows XP Professional CPU/Ram: 2.666 GHz / 1013 MB Subcategory: General
Comment:
Hello Again,
I have created a worksheet in excel '03 for ticket logging. The worksheet consists of a header row and ten columns with the ticket number being the first column. I created a userform in VB that automatically opens and sorts by ticket number when the file is opened and once the information is entered and the command button clicked it populates the information in to the next empty row.
What I would to do it is write a code or a function that will restrict you from entering duplicate ticket numbers.
Summary: I have an Access 2007 database issue. I need to add the values from the laboratory results for two chemical compounds: m, p-Xylenes and o-Xylenes (example: 2.5 ug/L and 3.2 ug/L, respectively), then...
Summary: Can someone help me with either a macro or code? Both of which I have never done. I am trying to set something up where a row or rows will be copied into a new worksheet which is named a a specific st...
Summary: I have a large number of sheets (120) in a single Excel workbook file. I can import each sheet individually into an Access table using the import wizard from Access. However, the task is very time con...