SQL in Excel dataHi all,
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.
A1 B1
Field1 Field2
Chuck 12,89
Mike 23,09
Jean 9,34
Chuck 30,00
Mike 3,80
Chuck 22,00
Mike 7,23
Jean 10,55
Jean 10,75
Jean 31,45
Chuck 19,99
Result
Field1 SumOfField2
Chuck 84,88
Jean 62,09
Mike 34,12
Advice would be appriciated.
Cheers,
Ludovic
Hi
You could use a formula like this ...
Excel 2003 extract repeating cellsI 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.
Nit Wit,
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
excel spreadsheet?
If this is a dumb question, I apologize. I didnt have any luck
searching for the answer here.
--
Kepf
------------------------------------------------------------------------
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...
Macros for worksheet copy & paste?I have 6 different excel files. How can I combine all 6
of them in one single excel file under individual
worksheets (E.g. Worksheet1 for File1, worksheet2 for
File2 ....etc)? I do not wish to copy & paste it
manually. Can I use a macro to take care of it? If so,
where can I find further info on how to go about it?
THANKS!!
Assuming (1) this is a one-time need, and (2) your workbooks have
only one sheet each, this would probably be faster done by hand:
1) With all the files open choose one of the files to be the
receiving file.
2) Select the sheet in the subsequent books, one at...
excel spreadsheetHow 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?
--
Regards,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"Ang" <Ang@discussions.microsoft.com> wrote in message
news:418A7E09-1E8E-41E1-9988-82460B633629@microsoft.com...
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 paOffice 07, Excel.
Print area is set, print preview displays selection, always on far left of
page.
I want to choose the position on the page, eg centered or right aligned etc.
Help please.
Hi,
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
Cheers,
Shane Devenshire
"Eve Al...
how to turn off automatic format in Excel?Hi
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Thanks
Ngoc
Hi
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
Andy.
"ngoc" <linh@chello.no> wrote in message
news:BOKNb.271$O41.819@amstwist00...
> Hi
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
> Thanks
> Ngoc
>
...
Error saving a Shared WorkbookI have a user using a shared workbook and gets an error
everytime she does this ONE specific change. She deletes
a line and then saves and gets a message that
says, "EXCEL.exe has generated errors and will be shutdown
by Windows... blah blah blah". If she makes anyother
type of changes it saves just fine. I also had another
user do the SAME change and that person also got that
error message. When the file is changed to "Not Shared"
then the line is deleted it saves fine also. The problem
is obviously with the file itself and that is shared out.
can anybody ...
Excel 2000 macro security LevelHi! 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 chartWhat 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 ButtonHi ,
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
The code:
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 MacroI 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
"ExternalData_6", etc.
Thanks,
Carroll Rinehart
You could refresh with differen...
Formatting Cells in Excel 97Hi Guys,
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" <daryl.ho@tnt.com> wrote:
>Hi Guys,
>
>Sorry if I sound real stupid b...
Backup Excel fileI 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
suggest. Thanks
Jan Karel Pieterse's has an addin called AutoSafe (note spelling).
http://www.jkp-ads.com/Download.htm
(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 100Even 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.
thanks
"=?Utf-8?B?a2luZ3M=?=" <kings@discussions.microsoft.com>
wrote in
news:48A39EFC-2D09-420F-B2DF-6EF5C0DB6109@microsoft.com:
> 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.
>
...
vba code to enable macrosHi,
Can we write a vba code to enable macros. In most of the sites it says
we cant do that . The only thing we can do is change the macro setting or
work around is hide the sheet which has macros. But none of them will work in
my case. Can we change an excel security setting to from macro on open so
that macros are enabled.
No. If we can do that with code, then so could a hacker with bad intentions.
Mike F
"varsha12" <varsha12@discussions.microsoft.com> wrote in message
news:DBEB1614-C956-491B-B351-02DD9F711891@microsoft.com...
> Hi,
> Can we w...
Excel Histogram -- Incorrect BinsI 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...
2,2,2,7,7,7
and bin range selected as 0,5,10
I am EXPECTING 3 items in bin 0 (between zero and five) and 3 items in =
bin=20
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 =
please=20
help?
Eric Anderson -
> I am using the Histogram tool in Excel 2004 for Mac -- I am...
Macro on a protected worksheet in a shared workbook.Hi,
I have a macro in protected worksheets that can't run once the Workbook is
Shared.
I have wrapped the Macro code so as the worksheet is unprotected for the
time the Macro runs, and unable the Autofilter.
The code is as follow at the moment:
Sub Newaction()
Sheets("Critical Path").Unprotect ("")
' Newaction Macro
' Macro recorded 17/11/2004 by Clifford
'
'
Selection.AutoFilter Field:=1, Criteria1:="="
Sheets("Critical Path").EnableAutoFilter = True
Sheets("Critical Path").Protect contents:=True, userInter...
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
them manually.
Are you familiar with the VLOOKUP function? I use it all the time for this type
of problem.
vlookup(Product cell in first sheet, Array...
Import excel named range into Access error 3011Hi, I've read a few posts on this topic, but none addresses my
particular problem.
I use Office 2003 on an XP SP3 machine.
I am using transferspreadsheet to import a named range in an excel file
into Access.
This has worked beautifully until suddenly it stopped working.
I find now that if I extract the address of the named range from within
the Access VBA code,
it looks like this:
=#REF!$A$1:$Z$166
rather than this, which is what it should be:
=Data!$A$1:$Z$166
When I open the spreadsheet and get the address of the named range in
the immediate window,
it also has the #REF error....
Excel AutoSave #2In 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"
<anonymous@discussions.microsoft.com> wrote:
>In Excel 2000 was this feature available?
>User is not seeing it.
...
auto hide toolbar in Excel won't workI have the toolbar at the bottom of the screen set to 'autohide' but when I'm
in Excel sometimes it does 'hide' until the cursor is moved over it, but
mostly it won't autohide so that I cannot see the Sheet names at the bottom
of the screen. I am running Windows XP Home and Microsoft Office Professional
2003. Can anyone help please?
--
teecee8
Hi
Every time you move your cursor too far into the bottom area, the toolbar
will pop up. Normally it disappears when you move your cursor up again. If
it does not, try clicking on you spreadsheet. If you right click o...
Excel comparative queryI'm respectfully requesting assistance with the correct formula
to use for the following query:
I'd searching all of column A on spreadsheet 1 to see if a
value in column A of spreadsheet 2 is there, and placing
a result X (or another) next to (adjacent cell) the confirmed
value on spreadsheet 2.
Please help if you can.
Chris
Hi Chris
see your answer in puclic.excel
--
Regards
Frank Kabel
Frankfurt, Germany
Chris wrote:
> I'm respectfully requesting assistance with the correct formula
> to use for the following query:
>
> I'd searching all of column A on ...
Opening Excel from AccessHello,
Wasn't sure where to drop this question.
I'm using Access 2003. After I dump a bunch of data to an Excel file, and
save it off, I'd like to give the user the prompt to open the Excel file the
app just created for them. I did a little digging, and found out that the
FileDialog object does not support the Open file dialog type in MS Access, or
as MSDN puts it:
msoFileDialogOpen Not supported in Microsoft Access.
So, anyone know of a workaround or a different approach to be able to prompt
the user to open an Excel file from within Access?
Thanks,
Scott
On Thu, 2 A...
In excel how do I delete an option button form already in worksht
Hi Va Run,
Try:
Activesheet.Shapes("Option Button 1").Delete
Change the name of the control to accord with your situation.
---
Regards,
Norman
"Va run" <Va run@discussions.microsoft.com> wrote in message
news:3F4F80A0-347F-4603-ABAB-25B635E96C84@microsoft.com...
>
...