Enhance editing process within existing Excel VBA script
$30-250 USD
货到付款
This Excel VBA script is used to validate data that is being entered into cells. The validation is based on a FIELDS row that must be added to the spreadsheet that defines the attributes for the cells that subsequently appear in that column. The validations that are supported are length, alpha, numeric, amount, and required. For example, the attribute on a column might be 10R (ten characters and a value is required), 10N (up to ten characters numeric where the cell value is optional), or 10AR (up to ten characters as an amount field where the cell value is required),
This script is currently about 280 lines of VBA. Two changes must be made.
First is that the R (required) function is rejecting a field when it contains an embedded blank. For example, a cell value of "tom smith" should be accepted but it is being rejected with the required error, even though the cell is populated.
Second is that the errors are loaded in an adjacent (ERRORS) sheet, with multiple columns for each error type. A given cell might be identified more than once within the errors. We need this changed so that all errors appear in Column A and that a given cell is only reported with a single error message. Having all of the errors in Column A will make it easier to identify and resolve the problems. Having a field cell only reported once will also be a good improvement.
I will provide a sample XLSM with the VBA script once the project is assigned. The VBA script within that XLSM will need to be the starting point for this effort.
项目ID： #33174692
关于项目
授予：
有11名威客正在参与此工作的竞标，均价$124/小时
Greetings This is Umair. I can work with your project skills Excel, Visual Basic for Apps and Data Processing I am a Full Stack Developer and have been practicing this profession over the last 07 years. Your project 更多
Good Day I can do this project. Must see script, but I'm sure I can do this I have 15+ year experience with excel, excel VBA So you can trust to me. Result will be excellent Thanks
Hello, I have seen your requirements, and I am ready to help you update your VBA code. I am a Data Analyst with extensive experience in Excel and VBA/macros, and I can quickly and easily deliver the results you need. P 更多
I've been working as an Excel and VBA specialist for one of the Spanish top banks. I've done all kind of macros, from managing data to interactions with databases.
Hello there! This is asfakulla . I'm a reliable, trusted, determined Virtual Assistant and Social Media Manager with 2+ years of experience with many excellent skills including Data Entry, Lead Generation, Youtube SEO, 更多
