1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Is this Task too Hard for Solution?

Discussion in 'Ask an Excel Question' started by MEGGAABLE, Nov 6, 2018.

  1. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    Hello Guru in the House,
    I am a basic excel user aspiring to go advance, but I am facing a kind of big issue(since I have little knowledge now) over this particular excel template for School Report Card. The thing is, the Project was made free to download and I found it suitable for my Project but the Subject lists cannot go more than twelve. I have tried as much as I could to increase the List but all to no avail. I will be very glad and Appreciate if I can be assisted with this task. I have the file Uploaded. Thanks.

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    4,299
    MEGGAABLE
    +38 rows,
    never tested this kind of before ...
    You could check Yourself ...

    Attached Files:

    Thomas Kuriakose and MEGGAABLE like this.
  3. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    Dear vletm, I am very glad for your kind gesture, also thank you for your time taking to solve my problem,I really appreciate it. The Subject list is now increased but it has affected some value in some cells. If you check very well and compare with the original file I sent, you will see that the next line after the first twelfth subject is not generating value as expected,instead it throw up "#VALUE". Kindly observe the following sheet...Class_view, Subject_view, Student_view ... I know you did not notice. Please help look into it, I have attached the file. Thanks in anticipation.

    Attached Files:

  4. sureshsonti

    sureshsonti Member

    Messages:
    87
    MEGGAABLE,
    Looks like there is a hidden sheet named Help.
  5. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    Yes, There is...What do you suggest I do about the particular sheet bro? Could #VALUE problem be from there?
  6. vletm

    vletm Excel Ninja

    Messages:
    4,299
    MEGGAABLE
    As I wrote:
    never tested this kind of before ...
    ... and I won't ever test!
    Someone has had a lot of time to copy&paste 'some formulas' everywhere.
    I cannot figure why ...
    I won't have time to dig that ... should I write 'sorry'?
  7. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    Okay thank you very much...But if i may ask can you build a good one for me? That is flexible and user friendly. Let me know what it will take. If not mind we can chat on whatsapps Thanks.
  8. vletm

    vletm Excel Ninja

    Messages:
    4,299
    Let me know what it will take. ...
    I have not made any plans ...
    but if I write eg
    You would need to write exact Your needs ... exact means exact!
    ... after that ...
    It would take about 48hrs (or more) with coding,
    plus 3-4 times more testing for You...
  9. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    Okay, I am glad to hear that it reliefs my depressions..So can we have some chat via whatsapp?
  10. vletm

    vletm Excel Ninja

    Messages:
    4,299
    MEGGAABLE
    Did You read my previous reply?
    > fourth line?
    have You written those already?​
    > last two lines?
    just now, I won't have time to work with this kind of case over 48hrs​
    > I don't have/use whatsapp.​
  11. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    I thought you said it will tak you 48 hours to complete the work. So not what should I be expecting?
  12. vletm

    vletm Excel Ninja

    Messages:
    4,299
    MEGGAABLE
    I reread third time my #8 reply:
    below copy of it ...
    You would need to write exact Your needs ... exact means exact!
    ... after that ...
    It would take about 48hrs (or more) with coding,
    plus 3-4 times more testing for You...

    1) Have You ever worked with or without breaks 48hrs?
    Have You?
    2) As I've written twice...
    Have You written exact Your needs?
    3) Would You be ready to test 'it' ~150-200hrs?

    ... also #10 reply has line
    as below

    I won't have time to work with this kind of case over 48hrs

    Expecting:
    You should ... read others replies ...
    and at least to be ready for Your part of this.

    Next:You could try to ask more information from that place You downloaded Your file.
  13. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    You my needs is to make the Report card function the original way it's except for the Subject list to get increased with and that's all. I understand that you couldn't debug the problem further, you have tried up to your level of knowledge..i really appreciate you.
  14. vletm

    vletm Excel Ninja

    Messages:
    4,299
    MEGGAABLE ...
    Sorry, but You missed some of my questions ...

    There is none 'problem' ...
    Sometime there are challenges to dig others functions or code.

    You could also solve that Your challenge Yourself, but it would take more time ...
    All matter is time ... time ... time ...
    How to use those 24/7 the best way.

    Did You try that 'Next'-hint?
  15. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    Which Hint? You mean the forum where the project was downloaded from?
  16. vletm

    vletm Excel Ninja

    Messages:
    4,299
    Yes.
    As I wrote in the end of #12.
    Someone should know 'at once' answer.
  17. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    Well, I have search to the best of my ability seems none have same issue ...That's why I had to look in this forum, then you show up....I was glad my problem is solved.;)
  18. vletm

    vletm Excel Ninja

    Messages:
    4,299
    Someone has done that file ...
    then that someone would could give an answer for You.
  19. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    Nobody has done the file...You did the increment on the Subject list and it got some sheet affected on their Value being giving #VALUE. I thought you will be able to fix it out.
  20. vletm

    vletm Excel Ninja

    Messages:
    4,299
    ReCheck Your the 1st writing ...
    You uploaded file here ... Didn't You?
    You have downloaded it somewhere ... haven't You?
    Somewhere there should be someone who has done that file.
  21. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    The author who Uploaded the file said he is too busy that he cannot edit the Project for now. But wait if I may ask...Can you design a something similar to this Project?
  22. vletm

    vletm Excel Ninja

    Messages:
    4,299
    ... yes ... I notice that You haven't read my replies!
    You could reread those from #8,
    continue with same kind of replies: #10,#12 & # 14.
  23. MEGGAABLE

    MEGGAABLE New Member

    Messages:
    12
    I have read everything.
  24. vletm

    vletm Excel Ninja

    Messages:
    4,299
    You wrote: But wait if I may ask...Can you design a something similar to this Project?
    .... then You've had already an answer to Your previous question.
    Take care.

Share This Page