Excel spreadsheet has two workbooks: One for data entry, one for controlling entered data.
Entry to a range of cells (A1:A10) on data entry sheet is LOV controlled by a table on the control sheet. The table controlling the LOV is exhaustive and the user cannot enter values outside the range.
A second range of cells (B1:B10) on data entry sheet are controlled by an LOV, which is dependant on the value selected in the first LOV. Again, the LOV is exhaustive and the user cannot enter values outside the range.
All of the above is designed and working as intended - it is for background only.
Spec of what is required:
Excel VBA script that automatically clears the contents of either cell when the value in its neighbouring cell changes.
Typical use case:
User picks on A1 LOV and selects "Fruit" as the entered value. When B1 cell is selected the LOV displays "Banana: Apple: Pear" as valid choices. User selects "Pear".
User then picks A1 LOV again and changes value to "Vegetable" - the value in B1 is automatically cleared without user input. When B1 cell is selected the LOV displays "Potato: Carrot: Turnip" as valid choices. User selects "Potato".
User then picks B1 cell again and clears the entry to NULL. At this point cell A1 contents is automatically cleared without user input.
The cells to be automatically cleared will be specified as a range of rows. It must be possible to tweak the code to match the final design of the spreadsheet, so the range of cells to be cleared must be configurable. Editing the VBA code directly to change the range will be sufficient.
Exact version of MS Excel is TBC.
Some additional assistance may be needed during the development of the spreadsheet - please indicate your hourly rate for this work separately from the delivery of the initial code.
Hey there, I am a highly experienced developer, with 14+ years of professional experience and excellent English communication skills. I can definitely help you with the required changes to your Excel spreadsheet Plus
25 freelance font une offre moyenne de £20 pour ce travail
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Plus
I have 4 years experience in Excel VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Excel. Thousands of different tasks has been fulfilled from a simple daily routines with formulas Plus
Hello, I am Excel and VBA expert. I can do this project (Excel VBA macro) today. (range of cells to be cleared can be configurable in selected sheet or in vba code). (hourly rate is £15) If you have any quest Plus
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can assist you with your Excel requirements. Please contact me by chat and then we could discuss better your project! Ki Plus
1. Expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. E Plus
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Plus
I am proficient with excel macro/VBA development, I can write the macro to perform data clearance as requested, if you are interested feel free to message me, I am available to start your project immediately, looking f Plus
Hello, I have worked on over 200+ projects in different freelancing websites over the past 10yrs. I have the ability to learn things quickly and solve problems efficiently. From small excel tasks like lookups, form Plus
Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;
Hi Good Day! A serious freelancer here! I can help you to complete this work in 1 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to com Plus
"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as Plus
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
Hello there i can do that fast and easy lets discuss about the details and how the file must look like my best regards
hii. am good handed in excel vba . i can do this fucntionality. thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks
Hi! I have a VBA experience with 4 years experience as Data Developer. Optimized number of processes and automized various Excel files to simplify life and minimize the errors.
Dear Hiring manager, Thank you for posting your job opening for Data Entry. I have five year of data entry experience and I have performed all of the duties listed in your job description. I have a excellent typing Plus
Hi, I misunderstand what you exactly want, do you want depended data validation list, or you want to clear some specified data in sheet when user select specific words? either way, I can do both cases for you in less t Plus