Time-Saving Metrics on Sorting By Color2109 (11/19/2009 4:47:56 PM) Hi,
I am trying to find out whether metrics have been captured related to
the time saved by sorting Excl text or background by color. Has
anyone come across these numbers, and if so, what are they, or whe... Henry
Get Access Data into Excel1147 (11/19/2009 4:22:37 PM) Hi All,
I am using excel macro to get data from access database.
My sql query gives me 5 records or more than that.
I am able to pull it different cells.
But I want all the 5 results in single cell.... fi
Assign macro to check box?1580 (11/19/2009 9:28:03 PM) Is it possible to make my macro turn on the auto filter when checked, and
turn it off when unchecked?
Using VBA with Pivot Table Report Filter01297 (11/19/2009 10:12:01 PM) I am trying create a pivot table in Excel 2007 that only contains the new
information since the last workbook-save for a non-excel-using co-worker, so
she won't have to touch the pivot table.
Can I manip... Utf
Copying and Adding Values1145 (11/19/2009 9:24:01 PM) I would like to create a macro to copy information from different worksheets
to one single worksheet, and add the values associated with them together. I
know this is a little vague, but it is pretty hard ... Utf
VBA Format for a Range Name Used in the Sum Function3223 (11/19/2009 7:28:08 PM) I am trying to run some VBA code that I would use Range names rather than a
specific range, ie Data!M3:M223.
MsgBox Evaluate("SUM( Data!M3:M223 )") will work, but when I change it to
include the Range ... Utf
Referenced Workbook Add-In Slow to Open in 20070211 (11/19/2009 8:27:01 PM) I have a workbook that is saved as an add-in (wbkAdd-In) and another workbook
(wbkQuoteGenerator) that I assigned a reference to that add-in, because
wbkAdd-In contains all the VBA code to manipulate data i... Utf
Getting all open files in Excel1134 (11/19/2009 7:47:02 PM) I am trying to get a list of all files that Excel currently has open. I say
files in that it can be a mixture of .xla and .xls files (talking Excel 2003
I can just loop through the workbooks coll... Utf
Book with 365 sheets??6121 (11/19/2009 1:57:34 AM) I thought I would create a workbook that contains 365 sheets
(one sheet for each day of the week) that will contain rows
of daily numerical data.
However, if my workbook has 365 tabs, wouldn't that seem