|
Validation for multiple sheets?
Is there a way to use validation over multiple sheets? When I select
several sheets in a workbook validation isn't offered under Data. I was
hoping it would work like formatting over multiple sheets.
John...
|
6 |
16.07.2006 16:03:52 |
|
|
is this possible?
I already do this using a macro but thought it might be possible with
just a cell function.
Column B has either 1,2,3, or 4 in it. These are service codes. Column C
has hours in it. I want total hours per service in another place on the
sheet. So... it's find a all the 1's say, multiply each by the hours in
the same row in C and add that prduct to another cell. Do that until
there is ...
|
5 |
16.07.2006 16:02:15 |
|
|
2 questions - one about inserting the date, other about adding lines.
hey,
im making a timeline plan for school, and when i enter the date such as
3/2/06 it autocorrects it and changes it to 03/02/2006 which i dont have
enough room for. is there a way so it doesnt automatically change it?
and the other is ive already typed up my table, disregarding the fact
that the grey lines between each cell dont get printed. so how do i add
these lines so when i print it ...
|
8 |
16.07.2006 11:52:29 |
|
|
how do i open zipped files
Hello,
I am having a problem trying to open a file in excel. This file is ending
in xls. When i go into windows to open the file i get a message saying to
either select a program from the list or use the web service. Please help....
|
3 |
16.07.2006 04:07:46 |
|
|
How do I make editable PDF forms using Excel?
First off let me say I apologize for not keeping my Microsoft Office skills
up to par. I just spent a few hours making a very nice-looking, printable
member registration form using Excel. Unfortunately, I now want to be able to
convert it to PDF, and make it so that the answer fields are editable in the
PDF. ...but don't see how. Is there a way to do that using Excel? (I suppose
my first...
|
6 |
15.07.2006 23:09:01 |
|
|
Sorting Possible avoiding cell Formulas?
Just wanted to know if it is Possible to sort omitting any formula
activity?
I know, sounds crazy and doesn't make much since, but when I attempt to
sort, the data resorts back to the original position based on some
formulas I am using.
So I guess the main question would be, Is it possible to freeze formula
activity to allow general sorting? If Not, I can surely understand Why
...Thanks In...
|
4 |
15.07.2006 21:58:39 |
|
|
killing empty spaces in unusall fashion ..
I am trying to create a sheet that will read 2 columns of another sheet
that has empty spaces between the data (Rows) and I want to re-create
the data in a new sheet that will re-fill the columns without the
spaces.. Thanks
e.g. :
_COL_A_______COL_B_
apples 50
grapes 70
bannanas 40
peaches 80
TO:
_COL_A_______COL_B_
apples 50
g...
|
11 |
15.07.2006 21:50:53 |
|
|
How do I get a data analysis add-in for excel?
I am new to excel and need to install the "data analysis" add-ins found under
"Tools" for an assignment for a statistics class. I do not have the original
CD used to install Office 2003 and hope there is a way to access and install
these add-ins from the web....
|
2 |
15.07.2006 20:33:06 |
|
|
copying multiple cells
When I try to copy multiple cells that are not in sequence I highlight the
first cell then I use the Ctrl key to highlight the second and after I have
highlighted several cells it wants to jump off the first cell and only
highlight the last cell. Can someone tell me why?
--
Jim
...
|
4 |
15.07.2006 16:38:20 |
|
|
copy column and header names from existing spreadsheet to new spre
I need help coping all column and header info brought over from one
spreadsheet to another with out copying and pasting everything. Is this
possible and how do you do it?...
|
3 |
15.07.2006 15:31:01 |
|
|
Hyperlinks Not Instant In 2007 ??
HI, I am using the new 2007 Beta 2 from Microsoft Excel, the problem I
am having is that the Hyperlinks I used under 2003 were instant when
you clicked on them, Using the same files in 2007 I have to hold down
the Mouse button for a few seconds in order to activate the link
(Hyperlink).
Is there some type of setting to make the links instant like in 2003?
thanks In Advance... And VERY H...
|
12 |
15.07.2006 02:44:19 |
|
|
Upgrade to Excel 2003 -Will not print!
I have upgraded to excel 2003 from works 7.0. It will not print. The "save"
file window occurs. Even after saving, it will not print! ...
|
2 |
14.07.2006 20:28:46 |
|
|
Summary function
When I summarize by every change in column A and sum the other columns it
works. But I to have the data in Column B as well. It just populates a '0'
because I am summing the totals of Columns C - D. I don't want to sum Column
B I just want the data to be brought down to the summary totals. ...
|
2 |
14.07.2006 17:09:31 |
|
|
if functions
I have the following formula in colmun Q
=IF(ISNA(Q12(T8,CPT!$B$64:$B$89,FALSE)),"",VLOOKUP(T8,CPT!$B$64:$D$89,3,FALSE))
I also want to add the condition that if in column I the age is less than 50
then return a value of blank.
Please help-
dlvv...
|
2 |
14.07.2006 16:43:45 |
|
|
Summary Sheet For Identified Dupes
I not long ago had Great Info Provided By Max similar to what I'm
requesting here, but hopefully a bit simpler.
Now that I have a way to ID duplicate Phone numbers accross multiple
sheets, I want only the name and number of these dupes applied to a
summary or dupe sheet... I am flaging the dupes with counts, I need a
formula to find any counts (Specifying a Duplicate), and in return print
th...
|
7 |
14.07.2006 11:07:03 |
|
|
ISBLANK() function
Hi.
I need some help.
I have two columns in a sheet, A1:A100 and B1:B100, in which it is:
The first column A1:A100, have some data (numbers). In the second column
apply B1=A1, B2=A2,……..B100=A100. In the B101 i am trying to apply the
SUM(B1:B100), but only if the cells A1:A100 are not empty (the zero value
must be considered as number, not empty cell). In the case, which the cells ...
|
2 |
14.07.2006 07:40:01 |
|
|
Please See If This Is a Bug for 2007 Beta 2...
Ok, besides the other complaints I have come across with 2007 beta2, I
just noticed that if you try to copy a sheet from the tab area, The
Program Crashes! (Send Error Report to Microsoft Pops Up), I tried it
on two different computers and even used a blank template without
formulas, it still crashed.
If anyone else is using the 2007 beta2 version, please check this out
and make sure it's n...
|
1 |
14.07.2006 03:09:49 |
|
|
Sorting in Excel 2003
When I sort columns that contain blank cells, Excel throws them down to
the bottom. Is there any way to get them to appear at the top of the
sort?
...
|
3 |
13.07.2006 21:33:01 |
|
|
calculating commision on sales
hi,how do we calculate?...i have 2 methods,
1) amount of sales * 5% , say if the decided commision is 5%
2) (amount of sales - expenses of the month) * 5%
any other method will be highly appreciated,but a simple one.
please help someone.
...
|
5 |
13.07.2006 19:44:01 |
|
|
Another multiple criteria/column question
Ok, first post and pretty much a new user to Excel. I have two sheets
that I am working with, trying to recall data from one to the other
that meets criteria. In a nutshell:
Sheet 1 contains a column of unique values (col A), cols C,D, and E are
where I want to insert the formula to find data on Sheet 2.
Sheet 2 contains 4 columns, A contains multiple occurrences of each
value (from Sheet...
|
4 |
13.07.2006 19:29:54 |
|
|
Excel Format Cells
How do I format a cell so that it blinks ...
|
4 |
13.07.2006 19:20:01 |
|
|
Greater Than / Less Than Problem
Don't want to sound silly here, but I am actually having a problem with
a formula that will allow me to count only values greater than 0 but
less than 11. Is this Possible in 1 unique formula? Heres the
situation:
Within Column B6:B35, I want a count of any number that is greater
than 0 but less than 11. I tried the following but it returns a 0:
countif(B6:B35,">0<11")
Thanks ...
|
12 |
13.07.2006 19:10:02 |
|
|
linking worksheets
How can i link to an entire worksheet in another workbook, so that
changes may be made to the worksheet ragerdless of which workbook
containing the sheet is opened?
Thanks
--
bails
------------------------------------------------------------------------
bails's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36159
View this thread: http://www.excelforum.com/showthread.php?...
|
4 |
13.07.2006 18:58:02 |
|
|
Conditional Format - Date
I have a question that I home y'all may be able to help me with: I am trying
to use Conditional Formating for some dates. What I want to do is have only
certain dates to be in bold and older ones not to be. ie., if I am entering
dates for June on a spreadsheet for the month of June, I just want the dates
for June of 2006 to be in bold and not the others. I have done value ranges
(equal t...
|
2 |
13.07.2006 17:50:25 |
|
|
normal.dot
Hi is there an equivalent to normal.dot in excel. Everytime I open a blank
excel spreadsheet I get a macro warning but I cannot find any macros.
Office/Excel 2003 and windows XP pro with SP2
Thanks Ron
...
|
5 |
13.07.2006 17:48:53 |