This akin to drawing teeth..... Okay I'll have yet another go.

1. Is it your intention to have two workbooks, one that is currently opened, and another one that needs to be opened?

2. Of the workbook you need opened, what triggers this event? For example, are you waiting for a click event or of a result from a worksheet change event in the initial workbook that is currently open?

3. Since we've worked out that you want a formula in cell C2 which works off cell B2 value and pastes a result in D2, ( by the way your version "Dragged" is redundant so let's use the term "Copied"), how far do you want C2 formula copied to? Options could be "down x number of cells", "down to the last row of data in column X", "to the last cell in Column C"? Three people have alluded to this particular point and you have not given us any indication is to your intent. This is important for us to know

4. Where does the value "56" come from? Do you obtain this from a particular cell, or is it simply a hard value, ( one that doesn't change)? If its a value that doesn't change then it can be written into the via formula and no one other than you will know any different. If however, its a soft value ( one that resides in a particular cell) where is this value obtained from?

I have asked you once before about a good think about what you are asking here and to try supplying the correct information, and as such I am asking you to do so yet again, before responding.

Now, while you are here, we need to discuss the issue of cross posting. What upsets people is that until someone else mentioned it, you did not indicate that you posted this issue on another forum. You need to do so in your very first post after you post the issue on another forum/s. Please show respect to those members of the forums which you ask help from. Okay?