----- Original Message -----
From: Darlene Bost
Subject: [PCSOFT] Excel File Help
Here's the scenario. One workbook sent to two different organizations to be
filled in. I want to merge them into one sheet within a workbook when they are
returned to me. Can someone tell me how to easily accomplish this - i.e., Dept.
one (sheet one); Dept two (sheet two); combined Depts (sheet three).
Thanks in advance because I just know someone out there will have the answer!
Darlene
----------------
Darlene,
If you just want to display both on the same sheet, you could just copy and paste. Or, if the two
different orgs are going to be entering the same type of info, why not make a template (.xlt) first,
then send each a copy? When they come back, you could reference the cells to a third sheet - easy as
toast. I can help with referencing if you need it. hth
Alan Thompson
----------------
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
|