View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Holly Holly is offline
external usenet poster
 
Posts: 94
Default Want to link a cell of numbers with a cell of text & can sort

I have a column of #s and a column of text. The column of text describes
the column of numbers. I don't want to have to retype either column. Is it
possible to LINK/CONNECT the two columns so that they will act as one unitl?
If I try to merge the cells in the same row of the two different columns I
lose the text.
This is important because I must monthly import data and the data in the
columns could either increase or decrease.
Please advise.
Thank YOul