Name a Range

[amerifax]

That probably sounds like a game if that is old technology.

Several years ago I use the product called Symphony. To navigate. You could name a range that you use frequently. So if I used A2:S75433 I could give it a name, invoice, and that would be my database range pertaining to the invoice.

Is that a feature offered in Excel 2007 and is that practice used today. If yes is that method up to snuff in these more technical times?

 

[sissajones]

Yes, it does exist in 2007 - on the Formulas ribbon there is a section called Defined Names

 

[Ron Coderre]

I was an expert Symphony user "back in the day". It was an extremely powerful product that really transcended most users' vision of what spreadsheets could do. One of the Symphony features, that I wish Excel had, was the ability to cycle through a data list automatically, creating and printing completed forms. In fact, I wrote an entire payroll system, in Lotus Symphony, that managed all aspects of payroll: adding employees, tracking all deductions, printing paychecks, and creating year-end W-2's.

So...in answer to your questions:
1) You *can* assign names to ranges in Excel...they're called Named Ranges. Try searching Excel Help for "named range". Then post back with any specific questions.

2) As I mentioned above, Excel cannot automatically cycle through each record in that named range to create customized forms. However, you can accomplish form creations using VBA or Microsoft Access...which does creates the forms easily.

I hope that helps.

 

[amerifax]

I was an expert Symphony user "back in the day".

So...in answer to your questions:
1) You *can* assign names to ranges in Excel...they're called Named Ranges. Try searching Excel Help for "named range". Then post back with any specific questions.

2) As I mentioned above, Excel cannot automatically cycle through each record in that named range to create customized forms. However, you can accomplish form creations using VBA or Microsoft Access...which does creates the forms easily.

I hope that helps.

I'm finally getting serious about Excel. And I agree it was a great program. Withe the help of forums I was able to create macro programs that made my day easy.

One thing I remember was a line of headers, titles, and values directly under them. Must have been a range. All I had to do was query a value and bingo I had my results. Know it's all about Pivot.

Any how I'm setting up my named range.

Bob