building data model

Please explain what you mean by Unique IDs for sheets 2 and 3.

Hi Mehmetcik,

Thanks for the reply! Although when I run the codes, an error occurred, saying "1004, application-defined or object-defined error". Can you help me solve it?

As for my second and third point, in the original input file, the records under "Tech Manager" dimension and "Contract Party" dimension are not unique, meaning that one tech manager might be in charge of multiple contracts and therefore his/her name would appear multiple times. What I would like to achieve is basically for each dimension, find and keep all unique values, keep them in a separate sheet, and give each value an ID (starting from 1), and finally in the Contract_Fact sheet, do a v-lookup to indicate for each record, the IDs of its tech manager and contract party. (e.g. the column "Tech Manager" in the current input file will be replaced by "Tech_Manager_ID")

I hope this clarifies the requirement a bit more. My apologies for using unique value for each field in the sample file.

Look forward to your reply!

Regards,