Copy & Paste Array Formula

The same way you would copy any formula from one sheet to another..
The fact that it's an array formula shouldn't make any difference.

I'm not sure I understand what the problem is..
What exactly happens when you TRY to copy it?
What method are you currently using to copy it?

I'm very sorry, I should have said from one workbook to another.
What I'm trying to do is copy the cell "B2" array formula from the "Products" tab in the workbook, "March 2013" to cell "B2", "Products" tab from "April 2003" workbook.
ANY help is greatly appreciate.
Karen

Still don't see a problem, the formula copies just fine and remains an array formula.

The only difference is the new formula in the April book now has links to ranges in the March book.

Is that what you're talking about?

If this is the case, what you have to do is
In the March book, go to B2 and press F2 to go into Edit mode
Highlight the formula and copy it.
Go to the cell in the April book
Press F2 to go into Edit mode
Then paste and press CTRL + SHIFT + ENTER

I'm sorry, I followed your directions and when I try and paste the array formula into the April 2013 workbook, it places a "0" into the B2 cell in the March 2013 workbook, Products tab and then the formula bar is: ='[April 2013.xls]Products'!$B$2.
What am I doing wrong?
Thank you for your help!
Karen

don't copy the cell...
Rather, copy the CONTENTS of the cell.

So enter the cell as if you were going to change the formula, and copy the actual formula from the formula bar.

then go to the other book and go to the cell you want to put the formula
Press F2, then paste the formula into the formula bar.
Then press CTRL + SHIFT + ENTER

I'm sorry, this is not working for me. It's clearly something I'm doing wrong.

Below are the steps I'm taking:
1. In the March book, go to B2 and press F2
2. Highlight the formula from the formula bar, press Ctrl + C
3. Go to the B2 cell in the April book (it places a marquee around B2 and the formula ='[April 2013.xls]Products'!$B$2 in the April book)
4. Then when I press F2, the cursor flashes at the end of the formula in the formula bar.
So far, is this wrong?

I think I may have skipped a step, you have to exit out of Edit mode from the original sheet...
And you also need to clear the contents of the destination sheet.

1. In the March book, go to B2 and press F2
2. Highlight the formula from the formula bar, press Ctrl + C
3. Press ESC to exit Edit Mode
4. Go to the B2 cell in the April book
5. Press F2
6. Clear the contents that is already in the formula bar
7. Press Ctrl + V
8. Press CTRL + SHIFT + ENTER

I'm so sorry for all this and I appreciate your time, but I followed the steps and below are the results
1. In the March book, go to B2 and press F2
2. Highlight the formula from the formula bar, press Ctrl + C
3. Press ESC to exit Edit Mode
4. Go to the B2 cell in the April book
5. Press F2
6. Clear the contents that is already in the formula bar (There wasn't a formula in the formula bar)
7. Press Ctrl + V
8. Press CTRL + SHIFT + ENTER (the entire formula displays as the content of cell b2 in the April book)

Again, I'm sorry, but it's not working for me

Format cell B2 in the April book as General between steps 4 and 5

EXCELLENT! It works! Thank you SO much for all your time & patience.
Have a great day!
Karen

Glad to help, thanks for the feedback