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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Named Range when new data is added

Status
Not open for further replies.
debbiepy

debbiepy

MIS
Jan 19, 2005
43
US
I have data in one worksheet that I named. WHen I add more rows, I would like my named range to automatically get the additional data with me having to edit the named range each time. how can I do this.
 
Sort by date Sort by votes



Hi,

How can I rename a table as it changes size faq68-1331

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
649
N1GHTEYES
N1GHTEYES
N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
1K
SkipVought
S
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
722
Bijugate
Bijugate
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
552
EFFEY
EFFEY
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo

Part and Inventory Search

Sponsor

Back
Top