• 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.

Excel macro to fill sheet

nbeharry

New Member
I have a simple file that will potentially get a lot less simple. For now, my file has two worksheets, namely:

1. Form

2. Schedule


I need to write a macro that will take the info from the Schedule and populate the necessary fields in the Form once in input the CODE field in the Form.


I have uploaded the file in dropbox.


https://www.dropbox.com/s/1rzo9zbie23lcyp/TEST.xlsx.


Can someone please help!! Thanks.


I will fill in the
 
NBEHarry


You don't need any code for this as it can all be done with formulas


Refer: https://www.dropbox.com/s/8b8ebt4ik278idf/NBEHARRY%20Test.xlsx


You can read more about the use of the Index/Match functions here: http://chandoo.org/forums/topic/what-are-the-common-usage-of-index-match-function


You will also see that I have used Named Formulas in the model


These allow the formulas to be read a lot easier and will expand /contract as you add/remove data from the Schedule worksheet
 
Back
Top