ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,738
- Office Version
- 2007
- Platform
- Windows
Good Morning,
Ive tidied up all my table etc in the Name Manager but stuck on one.
All my table are 1 column.
So examples of my tables.
Header Sold
Name manager i see under refers to =Table22[SOLD]
Range AK2:AK66
Header Bought
Name manager i see under refers to =Table9[BOUGHT]
Range T2:T100
My problem is the one
Range is Y2:AH100
Table25
How do i then write the part in the refers to field as i have more than 1 header name in the given range.
Thanks
Ive tidied up all my table etc in the Name Manager but stuck on one.
All my table are 1 column.
So examples of my tables.
Header Sold
Name manager i see under refers to =Table22[SOLD]
Range AK2:AK66
Header Bought
Name manager i see under refers to =Table9[BOUGHT]
Range T2:T100
My problem is the one
Range is Y2:AH100
Table25
How do i then write the part in the refers to field as i have more than 1 header name in the given range.
Thanks