Replacing Two Items Together-Urgent
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! |
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 |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com