• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data validation?

U

Ufoo

Member
Hello excel gurus, I need your help please. The file is attached. Thanks in advance
 

Attachments

  • May be data validation.xlsx
    10.6 KB · Views: 7
What is the determinant for posting to Zone A or Zone B. This will require a VBA solution. Do you anticipate that data will be posted to a User Form? That seems to be the logical means for this to happen. Please clarify as you have not supplied enough information to create code. Do you already have a user input form created?
 
AlanSidman said:
What is the determinant for posting to Zone A or Zone B. This will require a VBA solution. Do you anticipate that data will be posted to a User Form? That seems to be the logical means for this to happen. Please clarify as you have not supplied enough information to create code. Do you already have a user input form created?
Click to expand...
Hello, thanks for your help. But I do not completely understand your questions please. Let me try to explain the best I can:
- If I enter data in cell A4 say to E4 (zone A) I want the formula to restrict entry of data in the following row after that in zone B (A5 say to E5), since ROW 4 has already been filled. That also means that if I enter data from say row 4 to 10 in zone A, I should be able to enter data starting from row 11 in zone B and not before that zone. And so on and on.
- On User Form, I do not quite understand what you mean. Let me try: this form will be used to enter row data, and for now the data that I will enter on my form will not be transferred into another form with a formula. Hoping that will help. Your questions are technical.

I was hoping that data validation might work. But I cannot figure out how. Thanks again.
 
Attached is your file with a user form embedded that you will enter your data into. Open the form by clicking on the command button shown. Enter your data into the form and click on the command button on the form. Data will be entered into the proper column based upon whether you have identified your region as either A or B. This is a Macro enabled file and is VBA driven.

FYI--based upon your requirements, I see no other alternative to meeting your needs.
 

Attachments

  • May be data validation.xlsm
    27.4 KB · Views: 5
Thanks a lot for your help. I think this wi
AlanSidman said:
Attached is your file with a user form embedded that you will enter your data into. Open the form by clicking on the command button shown. Enter your data into the form and click on the command button on the form. Data will be entered into the proper column based upon whether you have identified your region as either A or B. This is a Macro enabled file and is VBA driven.

FYI--based upon your requirements, I see no other alternative to meeting your needs.
Click to expand...
Thanks a lot for your help. I think this solution will work for me. I have a minor challenge though. I did not attach the actual excel sheet so that I learn from what you would post and use the knowledge on my sheet. Now I have to attach the actual sheet. Kindly please help me to address the following problems: 1) I cannot create/ custom-edit the user form in the sheet which you have sent to me. 2) The account column in the sheet has a drop down list which is different in the broker section and bank section. Is it possible to have options on the user form? You will understand my question when you see the drop down list. Again thanks a lot for your help
 

Attachments

  • Fx monitoring sheet.xlsx
    66.1 KB · Views: 1
Ufoo said:
Thanks a lot for your help. I think this wi
Thanks a lot for your help. I think this solution will work for me. I have a minor challenge though. I did not attach the actual excel sheet so that I learn from what you would post and use the knowledge on my sheet. Now I have to attach the actual sheet. Kindly please help me to address the following problems: 1) I cannot create/ custom-edit the user form in the sheet which you have sent to me. 2) The account column in the sheet has a drop down list which is different in the broker section and bank section. Is it possible to have options on the user form? You will understand my question when you see the drop down list. Again thanks a lot for your help
Click to expand...
I got a non VBA solution for this problem. =A3&B3&C3="" applied in data validation on either side. The link to the solution: https://www.excelforum.com/excel-formulas-and-functions/1284654-data-validation.html#post5166206
 
Attached is a file that you can review and determine if it meets your needs. You should start to learn the basics of VBA to make sure you understand what is happening and can edit given code.
 

Attachments

  • Fx monitoring sheet.xlsm
    78.6 KB · Views: 4
AlanSidman said:
Attached is a file that you can review and determine if it meets your needs. You should start to learn the basics of VBA to make sure you understand what is happening and can edit given code.
Click to expand...
Thanks a lot. If you have a link for VBA training for a complete begginer please share. The internet has a lot of stuff. Your directions will make it easy for me to spot a nice course
 
You must log in or register to reply here.
Back
Top