Array formula will not copy any further- Help ASAP!
I have an array function that brings in the margins for pricing from another
sheet in the workbook. Currently, it has about 13,000 part numbers on it.
When I copy the formula normall, I use the drag box on the cells. Right now,
I am stuck on row 11,000 because the formula will no longer copy any further-
it just leaves the cells blank and bounces back to where I started to copy.
How can I fix this? I've tried everything from adding new cells to checking
the formatting of the cells. Any help would be greatly appreciated!
|