Hi There,
I'm trying to copy the value of a cell to another cell in another worksheet, using the address of the destination cell, which is itself nested as the value of another cell (this is an important part of the logic as the address is a variable):
The value I want to copy is located:
Sheets("Data Entry")
Range("C19").Select
The destination address is:
Sheets("Source Ingredients")
Range("$DH$12")
The above destination address DH18, is the value inside another cell:
The value DH18 is variable
Any help would be greatly appreciated.