Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to copy sheet with range names
This is what we want, I think. The absolute address should work, because we really don't care what sheet the range is on, the import just looks for the range name "Amt" for example on any sheet, takes the value in that range, and fills in the data in the apl system, along with the...- JFerry
- Post #6
- Forum: Office suites general discussion
-
How to copy sheet with range names
We have a budgeting application written in APL (of all things) which produces "blank" Excel spreadsheets used for distributed input. These are then brought back into the application once they have been filled out. The input is made into the specific ranges which the APL system uses...- JFerry
- Post #3
- Forum: Office suites general discussion
-
How to copy sheet with range names
When I make a copy of a sheet in the same workbook, I loose all of the named ranges. I am an Excel user normally, and this works fine in Excel. i.e. when I copy the sheet, all named ranges are brought over into the new sheet.- JFerry
- Thread
- Replies: 6
- Forum: Office suites general discussion
-
Recommend a book on OLAP for SQL Server 2000
I found this to be very helpful: SQL Server 2000 Analysis Services Step by Step Author: Reed Jacobson Publisher: Microsoft Press ISBNL0-7356-0904-7 -
OLAP documentation
There is a recently published book on Analysis services which is pretty good: Step by Step Microsoft SQL Server 2000 Analysis Services by OLAP Train, Reed Jacobson
