+ Reply to Thread
Results 1 to 7 of 7

Modfication of Existing Code for additional additional cells

  1. #1
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Modfication of Existing Code for additional additional cells

    Hello Friends

    Please refer the attached file and the below link.

    http://www.excelforum.com/excel-prog...ml#post4278247.

    I added the extra columns (C1:L1) in `outputs' sheet and try to modify the existing code and getting error.
    - - - - - - - - - - - - - - - - - - - - - - - -
    My requirement is as follows :
    Please find the 2 sheets `Inputs' and `Outputs' in attached file
    I had a very huge excel file and here made a simple excel file for example.
    I need to input the various dates in (`inputs' sheet cell B1 from `inputs' sheet cell B4:B103) one by one.
    And I need to take the ouputs (from `outputs' sheet cell C1 and L1 and copy paste to `outputs' sheet cell table C4:L103) one by one.
    - - - - - - - - - - - - - - - - - - - - - - - -
    Kindly help me to correct the code.

    thanks in advance

    thilag.

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Modfication of Existing Code for additional additional cells

    Try this modification
    Please Login or Register  to view this content.
    Credits go to nilem for the original answer.
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  3. #3
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Modfication of Existing Code for additional additional cells

    thanks to both Bogdan and nilem.

    thanks again

  4. #4
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Modfication of Existing Code for additional additional cells

    Glad I could help. Thanks for the rep!
    Have fun!

  5. #5
    Registered User
    Join Date
    03-14-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Modfication of Existing Code for additional additional cells

    Hello experts,

    I need a quick support from this group.
    I am in need to create a simple Excel Tool that should have the following:
    1) Questions with Answer Options
    2) Set of Questions would be under some categories which will have some weightages
    3) Each Answer Options will have some specific scores
    4) After completion of filling the questionnaire, the result should reflect in an overall score (may be out of 100)

    Can someone help me on this? I think a re-usable macro enabled sheet (in the similar line) should work with some editing/customization that I will do.

    Thank you in advance!

    Cheers.

  6. #6
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Modfication of Existing Code for additional additional cells

    Hello abu0022 !
    Please open a new thread for your question. This one has a different thematic.
    For that go to Excel Programming / VBA / Macros and click on +Post New Thread button.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Modfication of Existing Code for additional additional cells

    abu0022 welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Including additional worksheets to my existing code (OFFSET, IF)
    By Gillani13 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2015, 02:56 PM
  2. [SOLVED] Add new (additional range) to existing code
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-22-2015, 11:43 AM
  3. Replies: 1
    Last Post: 02-06-2014, 03:00 PM
  4. Returning additional data from existing code
    By gss in forum Excel General
    Replies: 1
    Last Post: 04-05-2011, 09:11 AM
  5. Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. Replies: 2
    Last Post: 06-20-2005, 09:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1