Sorry if this is a basic question.
In my workbook I have 1 sheet that call Database. Where the info is there.
Then I have 9 sheet that contain 10 form in each sheet.
What I want to do is:
1. I fill in all the info in Database sheet. (not a problem)
2. I want to retrieve the data from the Database into the form in the other sheet for example into sheet GA.
3. To do this I just want to enter the Series Number and then all the data will fill automatic in the appropriate column. (All column at the top of the said form)
May I know what are the formula that i have to use?
In the attachment I just use '=' formula but that will be high risk because the data quite a lot.
Thank you....
Bookmarks