Replacing Two Items Together-Urgent
Maybe you can make the references to the other worksheets shorter--open the
workbooks so that the paths are removed from the formulas. Change the worksheet
name to something shorter may help, too.
FARAZ QURESHI wrote:
I have copied a set of formulas from the last months' statement, referring to
two different sheets to a new workbook. The problem is that I cant replace
both links in the formulas by ctrl+h, and the results is that "The formula is
too long".
Any idea how to replace two different items together, with two different
items?
Thanx!
--
Dave Peterson
|