[mso] Re: Drop box to assign a row to a different excel worksheet

This can be done by selecting or inserting a list item.  Can u please
provide this in EXCEL format so that it can be done easily.

Thanks & Regards, 
Rajesh V




-----Original Message-----
From: Scott, Tiffani D. [mailto:TScott@xxxxxxxxxxx]
Sent: Thursday, October 20, 2005 10:17 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Drop box to assign a row to a different excel worksheet


ALL WORKSHEETS ARE FORMATTED EXACTLY THE SAME, ONLY DIFFERENCE IS THE
TAB NAME WHICH IS THE SAME AS THE NAME IN THE FIRST ROW.
 

*This is what my worksheet looks like*

Each of the 17 worksheets have a name on the tab which are:

Allgier

Anderson

Brundage

Dickson

Golightly

Gonzales

L. Hansen

Heffron

K. Hansen

RB. Mitchell

Other

Parrish

K. Robinson

Slater

Stewart

Stiefel

Wilson

-------------------           ------------------------------
----------------------------

*~The same name is written in the first row and the rest of the document
looks like this~*:

A1 to F1= the person's name

A2 to F1= blank/nothing in this row

A3= date of training package

B3= soi/sop number

C3= soi/sop title

D3=person who made comments

E3= date sent out

F3=date received

_____would like to add G column that has the drop box of names

Row 4 is where the actual information is starting to be typed.

 

 

--------------------------------   -----------------
-----------------------------          -------------------

*~What I want to do~*

I would like to add a column G that would have a drop down box that
would contain each of these 17 names.

If I select a persons name in this box I want the contents of the row (A
# of row, to D # of the row) to be copied/not cut, to the first blank
row in that person tab.

It would be ideal if I could also copy the contents of that rows F to
the new persons tab E.

 

THANK YOU SO MUCH FOR YOUR HELP, this will save me so much time!!!! :-)

 

 


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************


___________________________________________________________________________

'Visit us at www.sundaramfinance.in'

___________________________________________________________________________

 "This E-mail may contain privileged information and is intended solely for
the addressee, and any disclosure of this information is strictly
prohibited, and may be unlawful.  If you have received this mail by mistake,
please inform us immediately and delete this mail.  Any information
expressed in this mail does not necessarily reflect the views of SUNDARAM
FINANCE LIMITED.  As per SUNDARAM FINANCE LIMITED's policy, unencrypted mail
via Internet is not considered secure".

___________________________________________________________________________


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: