Windows Secrets
Windows Secrets Lounge
Copying from a Workbook without opening it ?
Using Excel 2010 Sending Emails through Lotus Notes to Multiple Recipients
Excel 2010 chart setting to make major horizontal axis by month
countifs and using a date from another cell
"source" folder renamed, links broken
How do I display a message?
Time conversion formula using Seconds for macro triggers
Need help with batch printing
how is it done?
help with excel filtering
finish date formula needed
Calculate Average Time to Complete Audits
Issue with editing Excel formula
save changes
Copy pic from every site with URL in column A
IRR trouble: Want to figure average annual rate of return
Macro to email sheets
Add picture to comment
Removing leading numbering from link
What are options for recovering deleted sheets within Excel file?
Errors were detected in file 'G:\DOR\DOR_2013-06.xlsm'
fill rows
data validation list depends on cell
find which cell to use
Question about a Dim statement
Excel 2010 date formula
Need help with text strings search code
Transferability of User Added Buttons
Copy Command in Excel 2007 takes Long time to execute
Copy a sheet from one workbook to another?
Groupings of data and averaging
number of duplicates
Why is this giving me a compile error?
LEN not working with IF in Excel 2007!
Macro to enable data to be printing on one page
scatter plot x versus y but showing data point lables form another column
Private Project
Easy (?) Subscripts and Superscripts
Exporting table from IE to Excel
Scatter Chart X Axis Problem
VB - run time error 9 - why?
Help with if-then issue
Insert range?
problem with MODE function
Upgrade to Windows 7/Office 2010 - Excel macros error out
data reformat
Problem Exporting Spreadsheet from SAP to Excel
Coverting time zone and update date accordingly
Summing based on Filters - Excel 2007
Computing expected sales Units
Data Validation Question
Finding which category in an excel table
Formula for Date/Time
How to fill an array with VBA
Comparing two columns
Formula to extract data based on Asset number
Restrict functionality after a specific date
Compare Lists
Opening a network excel file in VBA takes so long it prompts for password
workbook links updating strange behaviour - Excel 2010 SP1
Formula =[@[Asking price (sale currency)]]/1.58
excel 2007 delete duplicate doesn't match function results
VBA AutoFilter with array Criteria
Can't figure out where the formula is wrong
Cannot see which cells I have selected in Excel
I need the SMTP name from Outlook in Excel - anyone got some code?
How to set Excel 2007 options radio button to Manual mode only
Forcing Excel to ask what printer to use everytime you print
Excel 2007 Solver "timeouts"
Conditional Formatting
Set up "table of contents" and jump to location (Excel 2007)
Break Links to Source in Both Workbook and Chart
need help with vlookup
Need formula help to calculate annualized compounding percentage
Help with Offset formula
Creating Relative Links in one Excel spreadsheet to multiple Word files...
Can't delete the named range in VBA
Add User ID's to existing spreadsheet
Updating Excel to newer version
Grouping, but not summarizing
Fractions in Excel
Word Document to Excel Spreadsheet
Excel 2003 DateCheck procedure
Emailing grouped records
Lagging screen response
VBA for column letter
How to mirror data from master worksheet
Mystery autofill
PV Panels Sheet problem
Compare 2 Excel Worksheets & Identify non-matches
SendKeys "{ENTER}" in Macro...............Permission denied
Copy Macro Module from one worksheet to another and then assign it
Combining cells in rows with the same ID into one cell for email mail merge
Formula mystery
Increment number when Date changes
Downloaded word-(text) ext file to a excel with complications
Macro Buttons Shrink in Compatibility Mode
A sobering thought
Macro to open workbook and copy data where name matches
Macro to copy data from specfic Cols in Source workbook
*** ~ Lost all 2010 macros when opened with 2013 ~ ***
Remove the " mark when copying/pasting a cell
Exporting from Adobe produces wrong date format
Highlighting cells to create extended cursor
Convert cells from General to Date Format
Finding the "missing" record in a filter: Excel 2010
Slide Timings in Excel
Excel footer, What is optimal size for A4 print?
Macro format
Forgot how to do this again
COUNTIF but if Hi-Lited Don't
Checking for duplicate/similar values
Goal Seek within VB
Helpfile for a workbook
Exporting Outlook email details
Protect Worksheet but Allow Refresh from Sharepoint List
Sheet 2 is same format as sheet 1 without copy/paste special/formats
Sumif not adding values correcly
How To Process Web-Imported Values
Delete Columns if Empty within a Range
Need help with conditional formatting using .net
Check box or radio circle on and off in a cell by clicking
Using SUMIFS when the Range & Criteria rely on there relationship
Named Range to be used with Target.Address
Adding preceeding and following "-" to center text
Vlookup where value is a formula
Another Compare Data columns issue this time with 2 columns
Pivot table - getting all possible column headings
Error creating Pivot Table formula
Tagging data to copy to different spreadsheet
Find last value in a column
Sumif Problem
Vlookup where numbers on one sheet are text
Sorting issue
Do Until If Cell range is 0.00 then Delete Row, won't Delete !
Help with a solution for calculating incentives
I need some design help
Selective Addition
Car Re[air Template
Web Query syntax error
Macro to compare data
Single vs Multiple Workbooks
Macro to Copy data from One folder to specific Folder
Coverting rows to column in date and time order
Comparing account numbers
Copying Down a Long Column - Excel 2003
Early and Late bilinding in ADO/DAO
Conditional formatting with five-icon set
Exporting certain data from a sheet and as save as CSV File
Macro to open specific directory and copy data
How to copy formatting?
insert or update data via VBA Source excel to Sqlserver
Indirect cell addressing
Need a rounding function
Need help Retrieving Data from one Ms Excel Worksheet to another
Count Unique Customers by Class and then Consolidated
Formula to Split data
Is there a difference between Excel 2007 & 10 re: this function
VB to insert space, create sub headings, and merge cells
Cell reference keeps reverting to data result
Microsoft Template; formula question
Delete/Condense Rows
Create column,move all strings to column A and fill series
Lost formatting in Excel
VB Code required to evaluate Excel formula
Determining if a Specific Value Ever Exists for a Project Name
looking for a sample excel file for inhouse training session fo pivot table
Excel 2003 Custom Toolbars
Need a workbook BeforeClose event
from network to sharepoint
Prompt for Signature on Every Save
Hyperlinking in excel
Sorting by different columns automatically on two sheet tabs
Nest IF/And/Or Too complicated?
Replacing zero-length strings but skipping certain columns
Using a formula instead of Goal Seek
Using Count If to to get PASS /FAIL /NA based on values in 2 separate cols
Trouble pasting excel spreadsheets into word or powerpoint
When is an empty cell not an empty cell?
Backup Storage Disk Space Calculator
Edit links manually only
How to Display a Blank if Linked Cell is Blank??
Macro to update internet links
Recreating a data display table using VBA
help with formula
Cross Version Copy
Matching very large number of cells in array
Getting the Addins tab to display in Excel 2013
Naming ranges using VBA
Open a foler then select the correct filr and copy form that to your master
Line Weight in Excel Charts
Conditional formating a formula cell
Sum values based on a Named Range
Conditional formating - excel 10
Significance or function of '^' in a formula?
Observation About Text to Columns Wizard
Second opinion; Can anyone poke holes in this formula?
Formula help needed!
Combining Data of 4 groups data (in 3 columns) using common unique index
Calculating Time from Custom date formats
Pulling rows from one tab into another based on a value
E-Mail Certain Worksheets in a Workbook
Offsetting a chart
Help with formula
Error in MSExcel 2007
Using Excel to find trends and patterns: problem management
Copying selected records
Can you in VB append column headings to a row and repeat
Printing Images Imbedded into Comments
02/12/2013 Windows Update
A lookup to take into account 2 column values and 1 header value
Displaying a string in a blank cell !
Difference between two times - to the second
Sequential print from list
can't update horizontal data in chart
VBA to refresh all queries and pivot tables
Updating Links
Need to understand Index/Match and Vlookup can be nested.
Need to change lines in Excel 2010 chart
Changing Dates in Text to Numbers
Wrap Text function treats negative sign like a hyphen
Flaky Sort Macro - Excel 2003
MSQuery time conversion error
Change signs based on criteria
Deactivate Timer Macro
conditional formatting to display a currency symbol based on text
SUMIF the criterion contains a specified substring
Libre Office Calculator help please!
Function other than VLookup
Create new sheet with customers from one sheet but not on 2nd sheet
Remove all words that are not all caps
Delete certain text
Microsoft Query Assistance Needed
Combine 2 tables with data from separate Fiscal years
Conditional Formatting question - shading of one cell or groups of cells
Formula with database
Prior postings in Spreadsheets
Sorting and Moving Pass Fail Results
Pivot Table Report Filter - Excel 07
conditional formatting (more than 3 variables)
Count Cells Containing "IMMEDIATE"
Trouble Running Macros During Cell Change
Excel 2010: "can't find project or library"
Conditional Format if Cell is Blank
stack chart
Dynamically Challenged (in Charts)
PowerPoint: hide selected objects from printout?
Global search and replace of text on sheet tabs
Excel macro function firing when it shouldn't
Help with Code or Forumla
Formula needed to extract a date from a string
Conditional Formatting
Inverting columns of data
Extending formulas down a spreadsheet
Saving settings in Excel 2010
Determine if data in one column is in another column
Excel 2010 Yields Massive Files
Update columns of numbers in spreadsheets
User-defined function: Triangular Distribution
Excel error opening
Sorting Unique Items Over 2 Columns
Lost Custom Colors
2 worksheets on 2 monitors in Excel 2010, Windows 7
Active Cell + 250 lines highlight macro issue
Macro troubles - relative referencing, but not really.
copy creates a blank sheet
Tool tip for a UDF
Sheet Change Event doesn't fire
Creating a daily cash report showing # of trx and total amount
Assigning the 'On Open' macro ?
Combination of numbers
Help with BIG Project
Transpose with a pattern
Ratio calculation
Calculate % difference
Average time calculation
VB Corner for Excel- Learn Visual Basic, VB Code Repository
How to footnote a formula
Using a pivot table to add minuets
Formula to find next business day
How to pad out emails?
How do I change a txt file to a quote delimited/separted file?
Lost Macros
Macro for if auto filters dont find a match to not copy data to a new sheet
Using macros in Excel 2003 and 2010 and vice-versa!
Type mismatch
Find Upper and lower boundary numbers. calculate average rate between them
Excess Spaces
Need Code
Sum based on colour?
Clculate Remaining Months and Days
How to Autosum in a macro at each change in data
Not sure how to do this - missing file numbers in a sequence of file names
removing protection from an Excel spreadsheet
Auditing utility accounts (with pivot table?)
Locate chart below last row of data
Taking a variable break based on change in naes over an entire column
Parsing trendline equation
Help to adjust this Spreadsheet please? :)
Excel 2013 poor performance
List of records with unique entries in one column
Sort by the code
Changing the X scale of a chart
Excel Combo Box Macro
VBA for Excel - Copy rows and populate with split cell values
Find function
Obtaining a "SUM" or a "COUNT", "COUNTA" etc. on a filtered list
Macro Pivot table where the range of data always changes
Printing custom views
Cannot create Pivot Chart with VBA in 2007
transpose column to row in loop
More on Sheet Tab Names
Quattro Converter
Sheet Tab Names
pdf conversion issue
Permanently save custom number format for all workbooks
Need formula to extract from string
pivot table and calender month view
Lining up decimal points
Changing the order of columns
Conditional Formatting with colours - tied values
I saved over a file I can't replicate
Changing order of names in a column
Select and print defined areas of spreadsheets
Hyperlink formula to long file names that include commas
Help with Excel formula
changing to lower case
transfering excel spreadsheet with hyperlinks into Access 2010
Excel File Growing Beyond Belief
Help with arrays couning dates
Days between 2 dates, including the 2 dates
macro to copy cell contents and preserve data regardless of change in orig
Restrict the number of colors in Excel 2007
Close routine, cancel close and return to spreadsheet
Formula help: is =Right right?
Excel 2010 loses number formatting
Macro to copy data from multiple workbooks and sheets
How to Change Cursor Behavior in Excel 2003
Create new spreadsheet (13 columns) but data has variable number columns
Editing a user defined function
Count based on two conditions
Delete rows base on string first text and also leave numberic
Derive a Cell Reference in a formula, not the value
if statement
Offset funtion challenges for date selection
Excel Help
Need help debugging user-defined function in VBA
Macro/VBA if statement-Excel 2010
Workbook Tabs
Message to advise when values <>0
Excel 2007 - PERSONAL.xlsm project locked
Excel count enteries
Excel 2010 Date Picker
Highlight Cell if Row is empty
sorting grade n marks
Excel 2010 color scheme
.xlsx file not opening in Outlook
Upper Case Date Format (2007 SP2)
Rolling Calendar
Limiting user input
Macro to auto-hide rows
Forgotten Formula
Excel formula or macro for string of numbers
Index and Match
Selected output from coin inventory
Forgot Formula, and can't find it
How to get name of selected sheet for use in excel macro (vba code?)
Compare multiple (non adjacent) columns between 2 sheets in Excel 2007
Excel VBA to Clear Ranges
Need a Formula to plot employees within a range
Excel for iPad
Export to Excel from webpage no longer works
Printing to JPG Format
Excel 2010 bar chart with 2 y-axis
Can updating rolling calendar tables and their graphs be automated?
Macro to format Dates
Need to create a simple Hierarchy
Combining Workbooks/worksheets
Inbed search function inside array
Spontaneous shutdown of Excel
Convert hours
Formula to find and relocate discontinuous series of numbers
Want to highlight missing dates
Calculating date and time in business days other than Saturday/Sunday
Combo Graph Question
Excel 2010 SP3, intermittent link cell problem
Conditional Formatting Problem
Excel Options question
Adding amounts across multiple spreadsheets within a date range
Dual Axis Graph Question
Checking overdue date value from cell
Get average of percentages
IF function
Excel 2010 formula to shade cell to match another cell
Changing formulas to point to new column in budget
Sumifs within a range
Sumifs Question using Excel 2010
Need some help with visual basic to use cell ref for Y axis values
Excel - output in Unicode
Excel formatting
excel compatible format
Saving files to sharepoint
Pasting a volatile formula in Excel 2007
Password protect all tabs
█ Automatically transferring data between worksheets █
Data validation with a named range and conditional formatting
Conditional data formatting in excel 2007
Rearrange Smith, John to John Smith in Excel
Data validation annoyance Excel 2010
Excel comment font.
Excel formula or formatting to change number
Copy Data from One Col to another
Grouping Dates in Months Pivot Tables
Putting Cell Contents into a Print Header, Then Formatting
Default Folder
feedstream calculation
Networked EXCEL - warn and protect against access
proprietary spreadsheet protection
Testing error conditions?
Making Excel 2010 accept quotation marks and spaces
Help with excel 2000
Smooth Vertical Scrolling in Excel
Display a graphic based on a cell value per row
Dynamic Print Rage
Need help w/duplicate data
ActiveX Listbox problems [2010]
Comparing mortgage loans
Microsoft Excel
Rolling Counter using CountIf (Excel 2000)
Excel will not print the complete cell
External hyperlink to Excel 2010 worksheet
excel 2010 wants to install another program when opening
Code to open up worbooks and copy data
compute sequence (partition) number
Line spacing in wrapped text
Excel 2010 Flowcharts
Hide Unhide Columns
Check for certain duplicates but not all
Using the "find" command excel 10
Link Several sources to one spreadsheet.
Graph Needed For Time
Concatenation and quotation marks
Adding values based on a certain criteria
Fliping a range
Filtering based on text in Excel rows
Setting up a check box
Pivot Table Macro
Some design ideas please
working with multiple excel sessions
Writing a formula in a pivot table & being able to copy it to other cells
Excel Vlookup $ problem
Sending a message in the body of an email
Interchanging columns in Excel 2010
Macro to create Pivot Table
MS Query in Excel 2010: concatenating two fields returns error?
Getting rid of #n/a in a vlookup formula ( excel 2010)
formula help
Hide Duplicate rows in a range and give serial no
Batch file to copy sheet
Excel - how to copy the sum from one cell and pasting as a value in another
Excel - how to automatically format number (##) to text (US$##.##)
Help with Code
Form, hiding/unhiding active X controls & maintaining position
MS Excel 2010 { } function
Julian day in formula
VBA Code to copy specific data drom Source Workbook to Destination Workbook
Strange behavior for a combination chart (Excel 2010 and beyond)
Convert Formula to Value and copy values
VBA Code to Open Workbook and copy data into destination workbook
More than one Cell Being Selected - Excel 2010
Want a user function in Excel to add incrementing counter to list of values
A quick way of naming a lot of cells?
Protected Sheet & Book but developer mode still allowed?
Tutorials on VBA
Column name headers cut off at top
Macro to export sheet as CSV
VBA Code to extract specific Data
MultiConditional formula
curve fitting
counting greater thans
Sales Forecasting
Need a Macro to turn "off and on" conditional formating
find a text in a string
Excel 2003 using Send To, Mail Recipient quandry
Design Science's MathType add-in to Excel 2010
formula for adding time to a date based on a number entered into a cell
Cell does not display formula results
copying and pasting a hyperlink in VBA Excel 2003
Page Number to Exclude Count for Title page and TOC
Change Excel input mode
Dropdown conditionally based on values in a table
Formula in data validation List
Select Data in Excel 2007 will not update graph
Highlighting rows based on column value