Hello everyone,

I need a help with VBA and hopefully someone can help me:

1. In the sheet Index I have a data validation list (Input range: $B$2:$B$608, Cell link: D1)
2. Based on the selection in the Index sheet, certain data is extracted to "Population Estimates Tables" sheet from "Index" sheet. Based on the extracted data, some other metrics is calculated in that sheet (Population Estimates Tables) in the cell AD19.
3. I would like to extract the result (in the AD19) from the sheet "Population Estimates Tables" to Sheet1 for each data in the list $B$2:$B$608 in the Index sheet.

Hope this makes sense.

I truly appreciate your help!

KR,
M