View Single Post
  #1   Report Post  
Xcel_Gurl
 
Posts: n/a
Default Transfer Info From Worksheets


Ok hello,

I have a worksheet up and running, info is always being added to it
continuously.

What I need is for the info from Worksheet1:Column A to be transferred
over to Worksheet3:Column B but I cant figure out how to do this
because the information is Text not numeric. So basically I would have
2 of the same sets of data in 2 different worksheets so I can do what
needs to be done to the info. And when new data is entered into
worksheet1:Column A I need Worksheet3:Column B to automatically update
itself with the newly entered information. Finally, Worksheet3:Column
B needs to be in alphabetical order, preferably if it could update
itself automatically and put itself in alpha order rite away without
having to push the alphabetize button all the time.

Any help would be great,

Thanks!!!,

Xcel_Gurl


--
Xcel_Gurl
------------------------------------------------------------------------
Xcel_Gurl's Profile: http://www.excelforum.com/member.php...o&userid=25920
View this thread: http://www.excelforum.com/showthread...hreadid=392920