Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

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
How do i transfer spreedsheet info in excel to MS Word make label water New Users to Excel 1 June 24th 05 08:37 PM
Is it possible to transfer info between worksheets Boenerge Excel Discussion (Misc queries) 0 May 20th 05 07:19 PM
Transferring info between worksheets Boenerge Excel Worksheet Functions 0 May 18th 05 09:00 PM
Can a formula operate between worksheets, ie collating info from . Andy Excel Worksheet Functions 1 March 8th 05 05:30 AM
Adding rows of different info from separate worksheets into summar Barry P New Users to Excel 1 February 8th 05 02:47 PM


All times are GMT +1. The time now is 11:59 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"