Windows Secrets
Windows Secrets Lounge
transform date
Split Data
Duration in Months
Date range query
Protecting sheet and allow button macro to work
Multiple Hyperlink changes
Advanced Filter Challenged
Schedule Report
Paste Formula
Remove Excess Spaces
Sheet Copy and Formulas
Autofilter query
Symbol with if condition
Long IF
Knowing when rows are added in another sheet
Advanced Filter
getting YTD totals
Need Font Recommendations for use in Excel
embedding a formula ( worksheet name) in a VLOOKUP formula
VBA copy worksheets routine
Importing External Data
SumIf / SumProduct Help
Backup version opening
match data, plus or minus
Dynamic Bubble Charts: a challenge
loop in loop
Last entry in column
IF/THEN Statement
Attaching Macros to Spreadsheet (not to Application)
Macro Security
Copy data between workbooks
lock all elements of userform
Get Data from Saved Workbooks
VBA Listbox in Excel
Excel vb range box
Color formatting using a worksheet change event
Data Forms
Why does the SELECTION object not show in Immediate Window
lookup xls sheets
Tab Name
VALUE2 setting??
Complex lookup MidQuarter rate
Help with vba code
Addition by Name
Distribute value
vlookup in a macro
Plus sign?
Growth excel formula
Cancel argument in Before_DoubleClick event
Error on clicking Save
Excel Functions/Formulas
Comma Style Formatting
MID Function
Numbered Chart
How to change to upper case in Excel 2003
Changed Cell Reference in Returned Email Workbook - Excel 2007
Paste Options
Datedif returns Name error
is there an automated procedure for...
combobox with underline?????
VLOOKUP issues
Permission Denied
Copying values from a different workbook
COUNTIF type Formula Array
Pivot table problem (again)
Conditional Formatting
Kill Files With Spaces In Name
Worksheet Change Event
Formatting problem when sorting
Help with a formula
Conditional Format Formula
Search in Directory Twice
vba formula output
How can I read an xlsm file from xl2007 via xl 2003 by using external data
Excel userform to print document
Extrapolate Numbers
extra space in cell on autofit
runtime error 9
Create sequence of numbers
Search for corresponding cell
Change Sort Order after Entry of Data
Insert rows in protected sheet
hyperlink to mp4 file
Cannot copy/paste in file
percent exceedance
Split text
Time and date formula
U.S. Date in merge to outlook
Excel 2003 - Advanced Filter Problem
warning message This workbook contains queries to external data that refresh automatically.
Remove #DIV/0! errors
Opening a new document using a template
Printing from a macro
Excel 2007 - Fill-in field?
Traffic Light in Userform
Dynamic combo boxes (2003)
Similar to older post
UserForm Default Properties
Conditional Formatting
reading from a textfile
How can I best chart this data (03 or 07)
CSV to Excel
Column hide problem (Excel 2003)
Alerting Excel
Select multiple sheet to unhide (Excel 2003)
Wait Until File Attribute Changes
CTRL page up / page down
Line graph
linear interpolation
Dual purpose sub routine
Work with all sheets
Validation Help needed
Pivot Table Order
Using worksheet ref as formula source
Row-orientation for single column of many addresses
Bullet Charts and Chart 1Templates
How To Sum Multiple Items using VLookup with SUM?
Link Equation Editor to Spreadsheet?
protecting Object but allowing Read
Copy from clipboard
Formula (Excel 2003)
vba sheet selector via combo box (forms toolbar)
Check box
Saving Problem
Using Last Value in a Column
I want to open power point from excel
How to get rid of message when saving in XLS format
Batch Image Saving
Deleting Rows
Value set
Import selected Files
Getting information from 1 source to another
Compatibility: Office 2007 (PC) and Mac 2008
Moving data from one column to another
which function (or combination of) should i use?
Clearing cells on exit
Interest Computation using multiple Interest Rates
Interest Calculation
Copy data to blank rows (2007)
Protected cell problem
How to work work with Password Protected folder?
batch import
How to skip plotting "" cells - Excel 2007
Excel - dropping the time from a date and time cell
find row by partial match of cell contents
add 8% to a total
Populate 2nd field from Combo Box
Conditional Formatting
Dates - Saving from Excel to CSV - dateformat mmm-yyyy
Divide total by fraction
Exchange rates
Complicated (for me) formula assistance required
Calculating a Due Date with criteria
Unreadable content
Columns in ABC / 123 Order
Graph advice (labels)
Countif ? I think in Excel 2007
Pivot Chart with Formulas
Move Sheet reassigns button macros
Stacked Bar Chart Percentage Labels
What's wrong with my conditional formatting?
VBA Date Picker problem
Y2K again?
Run a macro from a server
Copy Data to another workbook
A question about links
Quicker Query
Find in range and insert value if not existis...
Pasting filtered list
Excel won't print to my laser printer
Unlock cells conditionally on previous cells
Add formula to cell (vba)
Project Explorer Preferrences
Version Compatability - Pivot Tables
Text formatting
dbf 4 files
Sort or Find & Replace by Cell Colour
Text Function with Different Regions
XY Scatter Plot
Combine Conditional Formatting
Auto change fill color
Excel 2007 - Drop down list
Symbol Possible In IF Formula?
EnvelopeVisible Failed
Follow Hyperlinks
Worksheet Change Event
VBA Solution Needed
Combo box (I think)
formula help
Conditional Rankings
Populate date values
Conversion Question
Create an Excel form using radio buttons
Adding code to an existing Macro
Formula help
collecting data
Screen updating
Tidy spagetti code
Suggestion Wanted
VB Code to make text blue and on two lines please???
Count longest run of pos/neg numbers Excel 2003
Where can I find the vb code 'key' please?
DUBT when macro in VBA for Excel run...
Currency Exchange from any to any
custom list greyed out
Drop down lists in Excel
cells instead range
Calculated items in Pivot Tables (2007)
Excel 2003 Pivot Table using Excel 2007 database
Using VBA from Excel to insert image into a word.docm
Combo Box Filtered Rowsource
Source Data for Charts (Auto Update)
Sorting rows on a protected sheet
IF with nested OR so ifTRUE result can do one of two things
How to Capture Value of Current Date and Time
Pulling partial info out of a cell
WORKSHEET Name using a formula
Auto pull data from the www
Compare contents of cells
Not printing entire worksheet
Opening file problem ?
vba code help
Show progress while Data are imported
Formula help
Bypass text import wizard
Error in average
Graph with paired variance figures
Variance with +/- operator
Color based Countif/Sumif (Excel 2003)
Copy data from multiple sheets into one
How to prevent Excel swapping date format to USDate
Copy Row/Insert
if iserror
Macro in 2007
Need formula (Excel 2003)
Macro (Excel 2003)
Excel 2007 - Formula in a macro
Data Lookup
Excel Chart Adds Data
Help on Pivot Table Query (sub %'s)
Conditional Formating on a selected cell range
Hide part of a cell
vba delete rows
Excel 2007 Addin misbehaviour
How to run a Macro from 2nd page on Excel s'sheet?
VBA, how to tell if a worksheet changed (xl 2003)
Entering data in upper case
Pivot Tables - Excel 2007
Formula Assistance
IFERROR Question
Creating a histogram
Auto-Complete activated, but doesn't work
Scenarios with Goal-seek
Error when recording macro with excel 2007
Sorting in Excel
Calculating Daily Interest
Sumif and
Update Sumif/Sumproduct Ranges
Defined Names (Excel 2003)
Excel 2007 Issue
Worksheet name reference
Checking for file
PivotTable Difficulties
percentages - if....then
Private Sub
Help with formula please
Excel 2007 - Separating names formula
User Form Question
sumif with multiple sheets (EXcel 2003)
getting rid of space so everything is left justified
Multi-select list box
Dynamic list of sheet names (Excel 2003)
dates in 'text' format need to be put in proper order for importing to outlook
If function
Bold in drop down list
delete rows with a blank column A
Establish file size
Open Google map quest
set maximum value in cell
Change pivot fields en masse
Font Size in Control Box
Page # in Background on Screen and Print
Call to Shell
Code that uses CreateObject("VBScript.RegExp")
Can items listed in a filter be copied to the spreadsheet
use of =sum
Vlookups on multiple worksheets
EXcel to Outlook
make excel print landscape all the time, no matter what
Excel 2007 page breaks
Send email using yahoo
Lookup with criteria
SUMPRODUCT with multiple criteria
Pivot Table Assistance
Excel 03 worksheet
Using a UserForm to open a PDF file
calculate number of days
Calculation set to Manual and Workbook Size Limit
large pivot table
Data merge code
tracking changes--limiting who can accept or reject
Excel Macros
VBA String formatting
excell formula
word wrap
Need formula
Cannot shift nonblank cells of the worksheet
Excel Conditional Totals
Insert Blank rows in Excel
Convert measurements to 1/16 inches
Filter disappears when Web Query refreshes
UserForm Startup Position
Need to enhance formula...
Removing * from cells (2003)
Looking for a Better Solution
using date - time
Custom Menu Bar
Conditional Formatting for a Drawing Object?
DIR Function
Personal XLS File
Excel Cell display more than 255 characters
Using VBA to copy and save a folder
Counting dates in SUMPRODUCT formula
Boston Risk Matrix - Graphing
Go To New Record with SQL tables error
Add-in (Excel 2003)
Embed a Photo
What does CODE do?
Successfully killing Excel 97
Renaming File/Sheet (Excel 2003)
Adding functions to the Quick Access Toolbar in 2007
Pivot table and getting values over 2
FTP File
Auto Correct feature
Error Message
Opening Multiple .xls at once ( Excel 2003 )
Countif anomaly - Excel 2003
Yoikes! I just made the jump to XL2007
Default formatting
Default decimal places for percentages
And/Or Formula Assistance
To divide part of cells
Excel sorting help needed.
Formula appear to have stopped working
OOps.. help with screwup.
excel 2003 object model
IF THEN in Excel 2007 Formula
sum dynamic rows?
Locked project for viewing (Excel 2003)
Extracting thumbnails from Excel file
Copy sheet + chart problem 2007
Extract range error
Data validation
Editing Link Source
Reference Vlookup Result
VBA error
Save sheet in new workbook - VBA
Formula to convert number base
Persistent Command Button
Select File
option buttons
FIFO Balance (excel 2003)
Field Mapping
Excel 2000 - Properties - General vs Statistics
Disable Macros Excel 2007
checkbook coversheet
Calculate hours and Minutes
Text Boxes
Rounding off (Excel 2003)
Calc days for project
Days in a month
Check Box Text
analyse survey (array formula???)
HIDE workbook
Remove fill
Hyperlinking email addresses
Dynamic Chart
Auto-Filtering not visible to others
save workbook in dir
Excel Security Notice
Excel Macro Stops working
Shapes printed in excel are skewed
Dynamic Charts
Changing Sum Formula based on Number of Months
Buggy Behaviours: Missing Tabs and Scrollbars
Missing Syntex
Value instead of formula (Excel 2003)
font limit in workbook
Array Formula to Condense a List
multiple if criteria in sumif
Last Value
First point above trigger
Rounding Errors
Syntax again....
Conditional Format in 2007
Working with pictures in Excel
WeekNum is no good for financial year
Losing Defined Names Excel 2007
Importing/combining 2 seperate workbooks
Simple if function question
count # of records per year
Vlookup from a dropdown box
Problem with macro
Force Excel NOT to Open in Read-Only
Change/Rename a module name
Dynamic Tab Function
Microsoft Office Outlook Web Access
Macro in Excel
Replace with relative references?
Workbook_Open event fails to fire
Capture application.username
column insert not possible (XL2003NL)
Count entries, make graph
Set variable to use in other module
Count and store as variable
Find data in column and move rows
July 6th alert!
Data Validation
Smart Quotation Marks
Macro goto specific cell
Pivot Table (Excel 2003)
adding Setup, Uninstall to an excel workbook or Folder
Quirky Sorting (2003)
Numbering with Fill Handle
Calculating last day of previous month
Extract surname in vba
hiding or making a row not visible based on other cell values
Make a cell flash
Time Format
Problem w/ basic Array Formula
Text to Column
Date formula
Upload Calendar
Countif Question
Chart With 1800's, 1900's, and 2000's Dates
Shading not displaying
detrending data
An Easy One
Final value in a column
Find in VBA
Date Format
Comparing fields
Tab Name In Worksheet
Excel to PDF
Shade total rows in pivot table
Custom formatting of numbers
Highlight Filter (Addin)
Calculating dates in reverse; always 'land on' a Friday
Sum Function
Indian Style numerics (Excel 2003)
Text Auto Filters: Print Full List?
Need quick easy Macro
Showing correct value in MSForms.Combobox
Excel 2009 - Diff of two dates
registry key for Show Standard and Formatting toolbars on two rows
Problem opening Excel file
Shell Command
Animate text
Conditional Format - SOLVED
Chart Events in Microsoft Excel
Automating Synonyms from Thesaurus
VBA to create button from the forms toolbar
Favourite Excel Blogs
Adding line in column chart
VBA to update link then protect
Relative/absolute macro recording toggle button vanished
Populate a calendar from a list in excel
Send worksheet in email
Securing cells
mail to link
Create Lotus Notes appointments from an Excel Macro
Selection too large (2003)
Very strange occurrance with this formula
Change calculation default in Pivot table
max entries in filter in 2007
Select non-contiguous cells in 2007
Formatting a cell so "0" doesn't show
Disabling addins