Terminé

Excel VBA script to clear specific cells when contents of other cells change

Background:

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.

Notes:

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.

Compétences : Excel, Visual Basic

en voir plus : excel macro clear cell contents, excel vba delete cell contents if, excel vba clear contents if cell contains, excel reset cells to default, vba clear cell contents not formatting, how to clear cells in excel vba, excel clear cell contents if another cell changes, how to clear cells in excel with button, excel vba lock sheet user script, start vba script excel, excel vba paste csv cells, run vba script excel, excel vba script modify existing vba, excel vba copy cell contents paste internet explorer, vba script excel xml, excel vba lookup script, script install excel vba, simple excel vba script, excel vba script find text, excel vba perform action specific times

Concernant l'employeur :
( 0 commentaires ) Fleet, United Kingdom

Nº du projet : #18204425

Décerné à:

mcfarhat

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% GBP en 1 jour
(1 Évaluation)
1.3

25 freelance font une offre moyenne de £20 pour ce travail

jaylancer43

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(644 Commentaires)
8.3
MohsanEijaz

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(70 Commentaires)
6.0
macroPOL

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(66 Commentaires)
5.7
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(55 Commentaires)
5.6
beltran0404

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(97 Commentaires)
5.2
citijayamala

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(57 Commentaires)
5.4
aubrey03

I am a VBA expert and I have done a similar project before so I am confident that I am the best freelancer for this project. You may check some of my projects here: [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(54 Commentaires)
5.1
vsprybhanu

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(63 Commentaires)
5.2
sloker18

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(50 Commentaires)
5.1
Simplesolz

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(27 Commentaires)
4.1
webanis

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(18 Commentaires)
4.1
paulodayto08

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(16 Commentaires)
3.5
dataexplorer

"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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(15 Commentaires)
3.4
dalsaniyasonu123

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(14 Commentaires)
3.6
mnazmih1985

Hello there i can do that fast and easy lets discuss about the details and how the file must look like my best regards

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(11 Commentaires)
3.2
rubal45

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(2 Commentaires)
1.0
nzamirbekov

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
shivachandra05

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
Imdadulhaqu

I am confidence

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
arash18k

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0