Forum Discussion
Drag and drop values from a Workbook to another
When copying a value (as a result of a calculation) from one workbook to another and then drag and drop a series of results is not functioning, only the first value is copied to all cells. This worked before but now it only works if you do it from another worksheet in the same workbook. This worked before so how to solve?
2 Replies
Make sure that the reference to the cell in the other workbook does not contain $.
So for example ='[Other Workbook.xlsx]Sheet1'!A2 instead of ='[Other Workbook.xlsx]Sheet1'!$A$2
Thanks a lot ! This worked now perfectly well :-)
