|
Calculating, filtering, and sorting 5 year anniversaries?
If I have an employee database with hire dates, and a company longevity award
program that gives an award for each 5th year anniversary, ie. 5, 10, 15,
etc. years of service, what formula could I use to flag every record/row
where an employee is entitled to an award, or not, in the coming 12 months?
tia
...
|
7 |
27.09.2006 15:23:01 |
|
|
Publishing excel to web with embedded functions
I have a spreadsheet with embedded drop-down menus. When publishing to
the web I loose the drop-down buttons. Anyone know how to fix this?
Thanks.
...
|
1 |
27.09.2006 15:17:10 |
|
|
Change directory
Hi,
I was using the ChDir = "C:\Temp" to change the directory
Is there anyway to specify the directory, and then save the path as a
string. I was trying.
myFileName = Application.GetOpenFilename("Excel Files, *.xls")
y = Dir(myFileName, vbDirectory)
but y was just set to the filename, I wanted the path like "C:\Temp"
Thanks for your help!...
|
7 |
27.09.2006 15:08:20 |
|
|
Deleted the pivot table - continue to get the "overlap" error message
When working with a spreadsheet, I had created a pivot table below my
data in columns Q and R. I then decided the grouped data was
irrelevant, selected the cells the report was located in, and hit
delete (shifting cells up).
Now, I have another pivot table I'd like to create and want to put it
below the data in columns Q and R for presentation reasons (so the
sheet doesn't seems disorgani...
|
1 |
27.09.2006 15:07:05 |
|
|
Lock Excel ToolBars
Is there a way to lock excel 2003 toolbars. I can position them to the
location i want and they always move when I relaunch the program....
|
1 |
27.09.2006 15:06:02 |
|
|
how to remove print area when grayed out?
i can see print area dotted lines, they are shown in document
properties/contents as "named ranges" and Acrobat can recognise them when I
want to create a .PDF - but all the clear print area possibilities are
grayed-out so i cannot emove them.
The documents/worksheets are not protected in any way.
Any ideas?...
|
2 |
27.09.2006 14:35:02 |
|
|
Calling function from a userform
Hi,
I was calling a function "Sub testmacro()" from a userform and was having a
problem
Private Sub CommandButtonUpdateIInforce_Click()
total_path2 = Application.GetOpenFilename("Excel Files, *.xls")
Call chg_file_location(total_path2, "H7", "Main")
End Sub
give the error = "by refarg type mismatch"
Is there any way to fix this.
Thanks for all your help!
...
|
1 |
27.09.2006 14:27:02 |
|
|
In Excel 2007 Unable to view or print text box
Hi! all,
In Excel 2007, I'm unable to view or print a text box. I can create the
text box within the Excel sheet just fine, but unable to see it in the
Print preview and unable to print it to a printer. Any ideas?
Help the perplexed.
Thanx.
...
|
3 |
27.09.2006 13:55:59 |
|
|
When I try to open a document, it is not there.
I was working with several Excel workbooks open and started to type into one
workbook. The cursor jumped as though I had tabbed through several columns at
once and then I realized that the worksheet I was typing in was not there
anymore. When I went to reopen the worksheet, it would not open. No error
message, just a grey window.
I have never seen this before!!! I have tried to open thi...
|
1 |
27.09.2006 13:52:01 |
|
|
macro
How do you keep a macro in all your workbooks, I notice when I create a macro
in one workbook and then create a new workbook, my macro is gone. Thanks,...
|
3 |
27.09.2006 13:49:02 |
|
|
navigation keys in protected sheet
I have two workbooks with three sheets in both. Each sheet is protected. In
one workbook, the second and third sheet do not allow any navigational
keys--such as ENTER or Down arrow--to work vertically. The TAB will move
horizontally from cell to cell but will not go to next line. In the second
workbook, all navigational keys work fine when sheets are protected. The
workbooks were cr...
|
2 |
27.09.2006 13:44:02 |
|
|
Copy/Paste Special (Date Format)
When I copy data such as 5/6 or 10-4, how do I prevent Excel from
formatting it to a date when I paste it? I still have this problem,
even though I pre-format the cells to text....
|
1 |
27.09.2006 13:43:36 |
|
|
Date-Time Stamp
I am having to break down a date and time format into separate date
column & time column...
The data comes in this format: 9/25/06 16:59
But when I do text to columns and then re-format etc...this original
data comes out this way:
9/25/2006 and 4:59 AM. It should be 9/25/2006 and 4:59 PM.
How do I force this to accept the correct time. This only happens with
PM time.
Thanks,
Hans
...
|
2 |
27.09.2006 13:37:01 |
|
|
=IF(C7=0,"",AVERAGE(H7:H11)) - doesn't work
=IF(C7=0,"",AVERAGE(H7:H11))
This formula is not working and I am not sure what I am doing wrong. I
want the cell to remain blank and not show an error message when the
related cells are blank. It is blank when the other cells are empty but
it stays blank even when I enter values into the other cells.
Probably a simple fix but I can't get it to work.
All help is appreciated. Thank you....
|
4 |
27.09.2006 13:36:08 |
|
|
all data begins with a quotation or apostrohe mark
All the data in a spread sheet has either a quotation mark or an apostrohe at
the beginning of the cell. It seems that the marks are half a space tighter
than normal
This only began after I cut and paste info from another data sheet that I
had did not notice had the same thing going on. When I print these fields
they don't print out.
Any advice would be helpful. Thanks
--
GlennO...
|
1 |
27.09.2006 13:34:01 |
|
|
How do I search without wildcards?
Hi, I'm trying to perform a search in a worksheet containing wildcard
characters (? and *) and I need to be able to find cells with the wildcard
characters themselves, e.g.
A1: What is your name?
A2: Your rating is *****
A3: This cell contains no wildcards.
If I press Ctrl+F (Find) and search for "?", it matches any single character
(rather than the ? character in cell A1). If I searc...
|
9 |
27.09.2006 13:32:47 |
|
|
How can I remove multiple 'errors' in Excel error checking, at the same time???
So, I have a worksheet with data pasted in from a Database. I have, for
instance, a column that is all numbers stored as text. I'd like to
convert all the cells at the same time. OR, I would like excel to
ignore the error for all of them.
Forget telling me to format the column as a number. It doesn't work.
Thanks,
Rob
...
|
2 |
27.09.2006 13:26:54 |
|
|
ADD TO COLUMN (inventory)
I have a column of inventory numbers and I have to dated total columns. In
the two dated columns I am using a (VLOOKUP) combination formula. The table
array is on another sheet with weekly totals. My question is I want to have
the inventory column on my comparison sheet to add any new inventory numbers
from week to week.
note: Preferably I would like to do this when I update my (VLOOKU...
|
1 |
27.09.2006 13:23:02 |
|
|
Excel '07 Close
I'm using the Beta release of Excel '07. When I try close the program using
the close button (red x at top right), it simply closes the current workbook
and not the program. To shut down it down completely, I have to close all
workbooks and then finally close the program. Is there a way around this so
that I can close Excel in one step? ...
|
2 |
27.09.2006 13:01:02 |
|
|
minutes seconds days weeks years
I have a spreadsheet that in column A= seconds. I want to take the
seconds in col a and convert to minutes in col B, then in col C convert to
hours and in col D convert to days - this is the formula that was given to me
yesterday.
=a1/60 (in B1) would contain minutes
=b1/60 (in C1) would contain hours
=c1/24 (in D1) would contain days
Question now in col E I need to convert the days i...
|
3 |
27.09.2006 12:51:57 |
|
|
Paste from word to excel, into one cell.
Trying to paste a few lines of text from Word into a single cell in Excel and
it pastes onto several rows.
How do I make it paste into a single cell ?
thanks...
|
8 |
27.09.2006 12:39:25 |
|
|
I want 2 columns to follow when I go to the right
i have a long page with date and i want the first 2 columns to follow if i go
to the right, so i still know what's opposite that cell.
Do yopu understand my question :-)...
|
4 |
27.09.2006 12:30:10 |
|
|
Data types when importing Excel data to SQLServer
Hello,
I'm trying to import data from an Excel datasheet to Microsoft SQL
server 2003 using the import wizard, but I'm having trouble with one
data column. When a cell has a value of, for example,
E4/E20, the slash character seems to pose a problem. I have tried
importing as both varchar, nvarchar, and several other data types, but
I can't get it to work - the entries with "/" characters are...
|
2 |
27.09.2006 11:48:59 |
|
|
Populate, Depending on Criteria
I have got golf scoring spreadsheet. (gross, net and stableford)
I've got it nicely sorted out for overall scoring, but now want to have 4
seperate result tables, depending on what grade the player is in - so
therefore, i want the spreadsheet to automaticaaly enter all the grade 1's in
the grade 1 result table, all the grade 2's in the grade 2 result table and
so on!
it would be nic...
|
2 |
27.09.2006 11:37:35 |
|
|
Statistics in Excel
In the Data Analysis add in there's two t-tests: one for samples with equal
variance and one with unequal variance- how do you test to see if the
variances are equal or unequal using excel and therefore choose the right
t-test?
Thanks for your help.
--
rakbhat...
|
2 |
27.09.2006 11:23:02 |