Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Table function

I have created a table and I have 4 columns, A-D, I am trying to alphabetize
column A & B using custom sort A=A-Z & B=A-Z but column D is hyperlinks and
does not stay with the data when alphabetized. My entire column D is messed
up. Isn't column D supposed to stay with the rest of the data when it sorts?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 489
Default Table function

Select Columns A thru D by click the column headers. Then sort by Col. A
values A-Z, then Col. B values A-Z and Col. D (with hyperlinks) will follow
the correct rows.
--
Cheers,
Ryan


"LeisaA" wrote:

I have created a table and I have 4 columns, A-D, I am trying to alphabetize
column A & B using custom sort A=A-Z & B=A-Z but column D is hyperlinks and
does not stay with the data when alphabetized. My entire column D is messed
up. Isn't column D supposed to stay with the rest of the data when it sorts?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function that meets table requirement then multiplies by table fac goonie Excel Worksheet Functions 2 December 3rd 09 06:49 PM
Table function Fernando Lopes Jr Excel Worksheet Functions 4 October 16th 09 08:54 PM
=TABLE function Excel User 123456 Excel Discussion (Misc queries) 2 May 19th 08 03:52 PM
What does this function do? {=table(D19,D21)} [email protected] Excel Worksheet Functions 6 June 3rd 07 07:45 AM
When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel Niek Otten Excel Programming 2 September 18th 03 03:55 AM


All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"