ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,832
- Office Version
- 2007
- Platform
- Windows
Hi,
I am sorting out my tables but i notice i have 3 entries of which are related & need some advice.
My worksheet has the following.
Columns range
AI2:AI236
AJ2:AJ236
AK2:AK236
The colums have headers
AI = COUNTRY
AJ = ITAS
AK = ISF
When i click any header then look top left of screen i see Table name =Table 21
In the Name Manager i see the following.
COUNTRYLIST = =INFO!$AI$2:$AI$236
ITALIST = =INFO!$AJ$2:$AJ$236
ISFLIST = =INFO!$AK$2:$AK$236
Im just clearing things up so its easier for me to understand so if all 3 on the worksheet relate to Table21 can i delete the 3 shown above & replace it with as follows.
ROYALMAIL = =Table21[POSTAGE SHEET]
I am sorting out my tables but i notice i have 3 entries of which are related & need some advice.
My worksheet has the following.
Columns range
AI2:AI236
AJ2:AJ236
AK2:AK236
The colums have headers
AI = COUNTRY
AJ = ITAS
AK = ISF
When i click any header then look top left of screen i see Table name =Table 21
In the Name Manager i see the following.
COUNTRYLIST = =INFO!$AI$2:$AI$236
ITALIST = =INFO!$AJ$2:$AJ$236
ISFLIST = =INFO!$AK$2:$AK$236
Im just clearing things up so its easier for me to understand so if all 3 on the worksheet relate to Table21 can i delete the 3 shown above & replace it with as follows.
ROYALMAIL = =Table21[POSTAGE SHEET]