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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Range in Excel

Status
Not open for further replies.
Mahathma

Mahathma

Technical User
May 13, 2002
17
0
0
AU
There are heaps of postings explaining how to make dynamic range as Pivot table source.
I discovered that Excel has this built in.
In Excel, Insert>Name>Dynamic Range Name... does this.
Good Day.
[hairpull3]

Guru
 
Please note - this only applies to 2003 (I guess - certainly isn't there in XP !)

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Question
Count range overlap cells
Replies
3
Views
135
N1GHTEYES
N1GHTEYES
N1GHTEYES
  • Question
Count areas within a range 1
Replies
14
Views
552
SkipVought
S
remeng
  • Locked
  • Question
TEXTSPLIT in Dynamic Table - Excel
Replies
6
Views
159
SkipVought
S
PSchubert
  • Locked
  • Question
Excel - SUMIFS() works with one range, but doesn't with another nearly identical range 2
Replies
6
Views
124
Andrzejek
Andrzejek
Bijugate
  • Question
Excel update question
Replies
0
Views
108
Bijugate
Bijugate

Part and Inventory Search

Sponsor

Back
Top