Excel macro to fill sheet

[nbeharry]

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

 

[Hui]

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