Add Value to Cell with lookup

[thegamemike]

Hi, good day!

Just need help in getting VBA code for this:

I want to add value to a certain cell hard coded in another sheet. To determine that particular cell need to check data on D5 and data on D10.

 

[thegamemike]

i have a file wherein the B20 referred above needs to be added to a particular cell in another sheet.

the data that needs to be looked up is D5 (row in the other sheet) and D10 (column in the other sheet).

hope you could help.. thanks!