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 worke...
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 :-)