I would like to copy a range of rows from Book A (includes multiple formulas) to another workbook, Book B. I would continually be adding to Book B this way. In other words, there are multiple workbooks like Book A that I'd be pulling from and adding to Book B. Some of the formulas in Book A reference a certain cell F2. I want that reference to point to F2 from that Book A every time. I can't use absolute references b/c when I copy that range of rows to Book B, that absolute reference will now point to F2 at the very top of Book B, which is unrelated to the new range F2 that I want to refer to. I can't use relative references b/c when I try to copy that formula down the column of Book A, it wants to change my F2 reference to F3, F4, F5 and so on, as you go down the rows. Am I missing an obvious option, or is there some other method that would work for something like this?