Page 1 of 2 1 2 LastLast
Results 1 to 10 of 17

Thread: How to enter data conditionally ?

  1. #1

    Arrow How to enter data conditionally ?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello all,

    Good morning,

    I have Sheet1 where I have all expenses/payments, say Fuel, Food, Stores etc.

    I have other sheets named i.e. Labor, Food, Stores, Domestic, Health etc.

    The moment I enter some payment to hospital and select option1 (drop-down data validation), it should go to Health sheet and sit there. If I enter some payment to Fuel and select option2 (drop-down data validation), it should go to Fuel sheet and sit there. Till some extent I have it done good. But If I edit the options selected in the main sheet, concerned changes are not happening in the relevant sheets. The data behaves static, not changing. I used index/match, v-lookup, look-up functions, but in vain, its not working. Please help. Since I am a new user this forum not allows me to send the file link to show you the exact problem case.

    Thank you
    mrxlsx
    Last edited by mrxlsx; 2013-10-05 at 06:46 AM.

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    778
    Articles
    0
    Excel Version
    2010
    Hello, and welcome to the forum.
    It sounds like your control sheet (sheet1?) has form or button controls that have VBA code linked to them selecting the correct data sheet. If so, then the control sheet options can be amended, but how would depend on what changes you need to make. I think that we will need more information, and to see your spreadsheet in order to help you.

    I don't think you need many posts to become a regular user (5 or 6) I think.

    HTH

    Hercules

  3. #3
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    719
    Articles
    0
    Excel Version
    Excel 2010 64bit
    mrxlsx, you should read this.

    The OP supplied a link to problem file here, here and 4 months ago here.

    It would seem your request of assistance is pretty much being ignored, often the case with cross-posting, although you did wait 4 months before posting the same question to another forum, unfortunately it was posted to multiple forums.

    That being said, I hate to see people having trouble and not getting help.

    I can see you are trying to enter/edit data on sheet1 (Main) and have it written/updated to other sheets (Fuel, Food, etc.).
    "In words" can you tell us what you are trying to accomplish or what your end goal is, rather than how you are trying to accomplish it?
    Perhaps others can suggest better ways.

    I think it would also increase the chances of assistance it you were to reduce ALL the sheets in your file to about 10 rows with formulas instead of 1000s (this would substantially reduce the file size) then post it here using -->Reply to Thread --> Go Advanced --> Click the paper clip --> insert the file in the window that pops up.

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    778
    Articles
    0
    Excel Version
    2010
    mrxlsx - Excellent advice from NoS.
    Its not an easy task to explain some problems clearly, and if you don't manage this then no matter how many forums you post on, your unlikely to get the right help (if any).
    If you find the explaining difficult for some reason, ask a friend or business colleague to look at your submission + sample data and see if they understand the problem as you describe it.
    Also, don't forget that the recipient knows nothing about what your trying to do, or why!

    Hercules

  5. #5
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,504
    Articles
    0
    Excel Version
    2010 on Xubuntu

  6. #6

    How to enter data conditionally ?

    Firstly, Apologies to all. I am extremely sorry for the violation. What I assumed when you say "Avoid cross posting same question in different forums" is forums within the website i.e. with in "Excelguru" there might be many forums dedicated to Excel i.e. Excel General, Excel Formulas, Excel VBA, Excel consutling, Excel Charts etc etc. I do not know that it applies to other websites also which are in the same kind of help forums.

    So assuming that, I posted my question to various websites to get variety of solutions for the same problem, thinking that there's no violation of rules of the websites. My intention is not to violate any of the rules of anybody but to get various different solutions for a problem. So I hope you all understand this and forgive me. Thank you.

    Coming to the problem, My end goal is to maintain small accounting process where in I post a type of expense and it goes to a specific account with a date. Later I summarize all at the end of some period. It should get edited whenever I change it in the Main sheet.

    mrxlsx

  7. #7
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,504
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Read this about cross posting

  8. #8
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    719
    Articles
    0
    Excel Version
    Excel 2010 64bit
    mrxlsx, you could take a different approach rather than having a workbook full of formulas.

    Have a userform show whenever a cell in column A of the "Main" sheet is entered into or clicked on.
    The userforms initialization populate a combo box and text boxes with info from the row of the active cell.
    Add or edit the info on the userform.
    Write the info back to the "Main" sheet, filter "Main" and write info to the appropriate "type" sheet.


    Just a thought.

  9. #9
    Hi NoS,

    I am open to any solution which solves my task. It looks problematic going the formula way as it is throwing up duplicate entries for a single transaction.
    Can you show me what you are talking about?

    mrxlsx

  10. #10
    Good afternoon,

    I'm pretty sure you could go a pure formula route to solve this. What is the limitation on uploading files? A file would be very helpful . Or if you could provide some example entries.

    thanks,

Page 1 of 2 1 2 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •