[mso] Assigning to different tabs in Excel?

From: "Scott, Tiffani D." <TScott@xxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Date: Wed, 10 Aug 2005 07:53:50 -0600

-EXPLANATION OF THE DOCUMENT-
 

 

I have multiple worksheets in one excel document.

Each sheet is exactly the same; it has information that goes across the
rows such as; title, date received and date sent which is (column A
through column F).

Each tab/worksheet has a person's name on it and their name is also in
(cell A1).

 

 

 

-WHAT I WANT ACCOMPLISHED IF POSSIBLE-

 

 

I would like to treat the "WILSON" worksheet/tab a little differently
then the others.

            I would like to add a column G to the "WILSON"
worksheet/tab.

 

            In this column I need help figuring out how the following is
possible:

After I fill in the row of information on the "WILSON" worksheet/tab
(column A through column F) I may need to assign that same information
to a different person/tab/worksheet. If I select or type that persons
name in (column G) I would like the corresponding row of information of
"WILSON" (column A through D) to be copied and put in the next blank row
in this assigned persons worksheet and the contents of "WILSON" (column
F) to be placed in the new worksheet's (column E).

 

 

 

Thank you for all of the great work you do, 

Scott

 


*************************************************************
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).
//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
*************************************************************

[mso] Assigning to different tabs in Excel?

Other related posts: