I am trying to write some code that links some cells on different sheets in the same workbook. I also have an offset built in, so I need to keep that. Im not geting any error messages and it works fine, but the code is in a macro that runs BEFORE any data is typed into the cell. So its just copying over 0's, and I want to actually set the formula in those cells so when data does get typed in, it copies over.
This is what I am currently using
Range("D37").Value = Range("Requirements!H84").offset(0, i).value * Range("Tables!H3").Value
and I have tried the R1C1 method but couldnt figure out how to integrate the offset.
Bookmarks