I am trying to share files with other users within my (school) building.  I
have set several settings like print area, page setup (i.e. scaling) and view
(i.e. print preview).  Is there a way to share those settings too.  I am
working in Excel 2007 but saving the file in 98-2003 ...

Hello    I'm reposting a question a little different.  Here we go  this is my
simple formula  
=VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this
works  now I want to add if is error equal 0  

I have a snippet of a code shown below, when
c.value=3 and c1.value= "Cluster 3", i is still showing zero. I can't
figut=re out what is going on here. The only thing I noticed is that c.values
are double and c1.values are strings. I don't know if that makes any

I am currently using Excel 2003.  
My budget worksheets consist of 10 workbooks which all have cells linked to
each other.  (exa:  Salaries links to Employees which links to Resource which
links to Summary).  I start with a file folder for 07_08 in which I create a

I'm trying to paste grouped information that has been collapsed and I just
want to see the collapsed data. However it is expanding all the data. Is
there any way of just seeing the collapsed data only? I have tried all the
paste special options too.

Hi!
Is it possible?
For example, lets say in A2 of sheet #1 the data entered in
the cell is "ABC Computer Supplies, 123 Main Street, Akron

Let's Suppose i gave some date 01-01-2007 in cell A1 and 01-05-2010 in cell b1
if i Subtract Cell B1 from A1 so the Answer will be 1100 Days BUT
i want these days as date like 6 days 1 months and 3 Years
OR

I'm getting a very annoying Unprotect Sheet box everytime I save a workbook
that has a saved sheet. So if I have 5 sheets with protection I get 5
different boxes to cancel. Is there a way to disable this message or let me
know what is causing the unprotect sheet box to appear.

I am trying to set up a gift certificate program for the company I work for.  
Using Excel, I have one sheet called payment info. and one sheet called gift
certificate.  I want the user to be able to simply type in the information on
"payment info." and have the gift certificate ...

I am having a strange problem with one of my users. We use a personal
workbook in my company and by default it's stored in:
C:\Documents and Settings\%Username%\Application Data\Microsoft\Excel\XLSTART
I have one of our users where Excel stopped opening the workbook. If I

I have Office XP. In one excel file I went to find to find a certain entry
and found about 301 cells. How can I copy all these cells and paste in a new
file?
Sol

I have a workbook that has nearly a hundred different sheets.  I would like
to create a userform and module that will search each cell in each worksheet
for specific text.

I have a database that is filled out by our staff, and the line of infor
(a1-r1) is in black, when the DA's office takes the case, and fills in a date
in cell (w1) , I want the entire line a1-w1 to turn blue, so we can glance at
the spreadsheet to see what is still open in our ...

Good Afternoon,
I have a Macro I use to send an email to a group after a spreadsheet has
been completed.  I’m looking to incorporate another send piece to the
existing routine and was wondering if someone could offer some advice.

Currently I am attempting to pull a number from another tab in my workbook
that is a compilation of sub-grouped items.  The coding that I was attempting
was:
=SUMIF(Smithfield!A:A,Combined!A14:A23,Smithfield!I:I)