SQL in Excel data
Is there a possibility/way to run an SQL query in an excel data sheet?
I have quite some data like the sample below, now i would like to have the
sum of spending for each person. Like it is possible in Access.
Advice would be appriciated.
You could use a formula like this ...Excel 2003 extract repeating cells
I have successfully sorted my data to show repeating entries in
relation to two specific columns. I can't seem to figure out how to
select these repeating entries (without doing it manually, of course)
and putting them either into their own column(s) or an entirely
different spreadsheet altogether.
The goal is to save time in managing THOUSANDS of documents in this
manner so that my colleagues can easily pick up repeating entries and
take according action. Doing it manually is very time-inefficient.
You don't really describe enough of your layout or what you actually mean...Exporting file names to an excel spreadsheet.
I have a folder containing many many many .pdf files.
Is there a way to export the filenames of these .pdf files into an
If this is a dumb question, I apologize. I didnt have any luck
searching for the answer here.
Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611
View this thread: http://www.excelforum.com/showthread.php?threadid=547520
I use Jim Cone's fine Add-in called "ListFiles"for this sort of thing. It's
available free (a...office 2003 w/ windows 7 requires reacceptance ot T&C's each time
office 2003 w/ windows 7 requires reacceptance of T&C's each time i open work
or excell or any office program. How do I get rid of this?
Boot into Safe mode in Windows 7,open any Office app and then accept the terms
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"mouser830" <firstname.lastname@example.org> wrote in message
> office 2003 w/ windows 7 requires reacceptance of T&C's each time i op...excel spreadsheet
How do I delete columns from my spread sheet? When I right click the word
"delete" isn't highlighted, so it doesn't work.
Is the sheet protected or shared?
Please keep all correspondence within the Group, so all may benefit!
"Ang" <Ang@discussions.microsoft.com> wrote in message
How do I delete columns from my spread sheet? When I right click the word
"delete" is...excel, worksheet, set print area, position selection on printed pa
Office 07, Excel.
Print area is set, print preview displays selection, always on far left of
I want to choose the position on the page, eg centered or right aligned etc.
To get your printout to center on the page chose Page Layout, click the
Page Setup quick launch button (bottom right corner of the Page Setup group).
Choose the Margins tab, click Horizontal.
There is no command to right align a printout, but you can change the left
margin to force the printout to the left.
If this helps, please click the Yes button
"Eve Al...Keyboard shortcut for current date and time
Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me
Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.
Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?
Thanks in advance.
CTRL+; then SPACE then CTRL+SHIFT+;
Portland, Oregon USA
wrote in message
Ctrl+ ; inserts current dat...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <email@example.com> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...Excel 2000 macro security Level
Hi! I am running an ASP.NET application which ideally opens an Exce
spreadsheet with a macro included in it. When I try opening
spreadsheet without a macro, everything works fine, but with macros, i
hangs on the opening command. I tried to go to Excel 2000 and go t
Tools->Macros->Security Level->Low but it still hangs when I try t
open the macro spreadsheet. All works fine with the spreadsheet no
containing macros, so it really is a question of macro security. But
put it to low, so I don't understand how it is still not opening!! An
help would be greatly appreciated!
Thanks and...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Running an Excel Macro from an Access Command Button
Can anyone help me with this, I am trying to run an excel macro from an
access command button.
I want the macro to Bold the Headings on a excel spreadsheet.
The code runs without any errors but the macro doesnt seem to work, I think
I have got the line
ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong
Private Sub cmdRunMac_Click()
Dim ExcelApp As Excel.Application
Dim ExcelBook As Excel.Workbook
Set ExcelApp = Excel.Application
ExcelApp.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and
Settings\...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Formatting Cells in Excel 97
Sorry if I sound real stupid but is there anyway that we
can control the column formatting in Excel 97 like let's
say column A = GENERAL(6), column B = GENERAL(4), column C
= TEXT(18) etc?
Appreciate any form of advice, thanks!!
I replied in the programming group. Are you seeking a programming
answer? It's usually best to only post to one group, and include the
remark "Please tell me if I should ask this in another group."
On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <firstname.lastname@example.org> wrote:
>Sorry if I sound real stupid b...Backup Excel file
I want to take backup of a file every time. I am using - save as - tools -
general option - always create back up. The backup file is in the same
location but I want to put it in a different folder. What should I do, kindly
Jan Karel Pieterse's has an addin called AutoSafe (note spelling).
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them...Excel devides every number by 100
Even when I open a brand new file. I input a number (ie 5) and get 0.05 back.
I have tried doing everything in cell format etc.. anyone have an idea? it is
very annoying and adding loads of work to my project.
> Even when I open a brand new file. I input a number (ie 5)
> and get 0.05 back. I have tried doing everything in cell
> format etc.. anyone have an idea? it is very annoying and
> adding loads of work to my project.
I have set up a spreadsheet with time based on what our company truck
drivers work. We work under a DOT rule of 70 hours / 8 days. That
means that the driver can not work more than 70 hours in an 8 day
The sheets I have (one for each month) goes back 7 days plus the
current day and calculated how many hours a day the driver works and
subtracts it from 70, leaving how many hours they can work the next
day. If the calculation gets to 0 or above, the cell changes color to
alert me that the driver's 70 hours are up and he/she has to have 34
hours off before he/she can be on duty ...Delegates cannot add contacts?
I've created an OU for external email addresses, shared
across the company. Within that OU, I've created a nested OU for
specific delegation. I've delegated management of the OU to a
specific contract manager.
My dilemma? From what I've been able to determine, no one except
an Exchange admin can create new contacts.
I've installed the Exchange admin/management tools on the appropriate
Is the problem that you have delegated permissions within AD and are no
"Mike" <newsgroups@manco...Unable to add documents to My Recent Documents
Any suggestions as to how to fix "My Recent Documents"? No new documents add
to the folder and it remains persistently empty. I get an "Access denied"
message when attempting to go to customizing the Start menu advanced tab.
Are you Right-Clicking on the Start Button and then selecting Properties
from the list?
If you select Properties then You need to select Customize from Start
Menu Tab. Then from Advanced Tab you should ensure there is a TICK next
to "List my Most Recently Opened Documents".
Gary V wrote:
&g...Compare 2 different workbooks with the result in a 3rd
I have two workbooks (2005 Sales, 2004 Sales), which track daily results in
half hour intervals. I want to be able to show the increase in 2005 in a 3rd
workbooks. The first two workbooks are identically formatted. How can I do
this? Many thanks to all in the forum who have helped in the past.
If the data is in exactly the same position in the two worksheets you could
copy/paste one's data to a new worksheet and then copy the second's, doing
an Edit, Paste Special, Subtract on top of the first's data. This is
admittedly crude but it is easy to do.
&q...Excel Histogram -- Incorrect Bins
I am using the Histogram tool in Excel 2004 for Mac -- I am finding that =
Excel is shifting all my data one bin to the right. =20
For example, with data...
and bin range selected as 0,5,10
I am EXPECTING 3 items in bin 0 (between zero and five) and 3 items in =
5 (between five and ten).
Excel is RETURNING a histogram with nothing in the zero bin, and 3 items =
each in the 5 bin and the 10 bin.
This is driving my bonkers! I can't find a solution...can somebody =
Eric Anderson -
> I am using the Histogram tool in Excel 2004 for Mac -- I am...why I see times new roman?
I have several html email messages composed in outlook express 6,
I'm sure I highlited all text and set it to Arial 10.
Then I drag the file to desktop, move it to vista windows mail draggin
into inbox or other folder. The result is some parts of text shows arial 10
some others Times new roman 10 or 12 what is annoying, because I use
all arial 10, so I have to manually forward the email, highligh it again and
set arial 10
and then, yes, I can see it properly.
I checked the compose default font and everything is fine.
Why is that? Is there any work around
, helo...Times Subtraction Whith Access
I need to know how to subtract between two times variants and to get a
time result (With Access).
Access really isn't intended to do things like that, but
?Format(#18:05:50# - #08:00:10#, "hh:nn:ss")
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
<email@example.com> wrote in message
> I need to know how to subtract between two times variants and to get a
> time res...Combining Lists within excel.
I'm hoping someone can help here. I'll try to explain the
problem I have.
I have 2 worksheets both containing a product list. I have
entries on one worksheet which I need on the other, so
basically my question is... might there be a way of
combining these two lists so one updates the other with
the missing entries.
Help on this would be great, as they are very large lists
which I dont much fancy the thought of looking through
Are you familiar with the VLOOKUP function? I use it all the time for this type
vlookup(Product cell in first sheet, Array...add GENDERCODE to leads
We implemented MS CRM some time ago, and now we come across some minor
issues... one of them is: why can't we add the GENDERCODE to a lead??
is there a way to do it (easily) or can we better forget about it???
...Excel AutoSave #2
In Excel 2000 was this feature available?
User is not seeing it.
Excel 2000 had the AUTOSAVE.XLA Add-in
Should be in Tools>Add-ins.
If not available there, do a file search on your computer.
If not there, install from the CD.
Gord Dibben Excel MVP
On Thu, 6 May 2004 13:26:16 -0700, "Ssolano"
>In Excel 2000 was this feature available?
>User is not seeing it.