Windows Secrets
Windows Secrets Lounge
Read data into Excel from text file?
custom validation formula
Sort & Resort Button
problems with decimals-help urgently
Objects moving after saving
Exclude duplicates master spreadsheet
Help with Lock cell code
Need help with Min Max and Group query
VLOOKUP Issue / Formula Result Incorrect
Assigning Variable Text to a Comment Based Upon a Formula
Allow N only if M has value
if function help needed
If function with input in form of dates and texts, use if function to calculate daily allowance
Formula for Counting Backwards
Button with import code
E-mail code in Excel
Recalc nightmare...hope there's a better way
Using Excel Fuzzy Add-in to compare two columns of names
Counting ""
Word and Excel only print after saving
Code is throwing - error 53
Embed len() into Vlookup (or other option)
Formula or Macro to Match Values
Formula help
Extract from multiple sheets - revisited
Referencing default printer in macros - Excel 2003
Format cells: roundup for display only
Problem with formula
Apply Goal Seek to Entire column
Help with formula (again)
Scanning into Excel
Change Cell Color
Offsetting transfers
Want to change the range from table to dynamic.
Change the color of the cell after specific duration.
The road to infinity
Pivot Table - Redirect source
need schizophrenic formula [work both directions]
Code to disable offlb.exe
Spreadsheet to send reminders: Please Help!
Pivot Table bulit used formula
Excel VBA
Need a running-total formula
Excel 2013 file prints, but can't find it to edit Windows 8.1
Load Clipboard with text from Excel using VB
Resize Excel Chart
Automatically send email based on Excel cell values (Macro)
Remove shading just for printing only
Extract data from multiple sheets
Excel Fantasy Formula 1 spreadsheet
Excel novice needs help
Using a variable inside a formula
enhance macro
Sports Pool Web Download
Dropping lowest grade and weighted average
which is faster?
scoring for duplicate bridge
Copy row with dates
Sumif function
dropbox list limitations, work around
Extracting values from XML file
Excel can't open a file
Timesheet start and end formula
find col and row
copy value to corresponding cell/column
Insert Time Calculation into Pivot Table and Cell Format for Time Incl Days (XL07)
percent formula question
Using formulas to return a file list
Turn off Password Protection
week to date percent to goal
Lost Named Range?
Word files with Excel links going to the cloud.
clearing contents of an array of ranges
Creating Outlook Calendar reminders from Excel spreadsheet
a shorter formula
Cracking Sheet Protection
How to prevent format corruption?
Copy text and hyperlink
Add new functions to existing spreadsheet
Formatting problem
Save file as .xlsx in VBA Code
Esc Key creates charts in Excel 2013
Sorting from a Command Button
Macro possible for this sequence of tasks?
Count Blank Cells by running date series
Using VBA to set Axis on Charts Issue in Excel 2007
If, And OR Formula Help
Help! How do I transfer the Total (J2-J23) in J23 worksheet A to J2 in worksheet B?
Combine multiple .xml files into one
Fixes for MS14-082 - fixes?
A conditional formatting puzzle
Thank You And Have A Peaceful X-Mas and A Peaceful 2015 As Well...
display down
Colors in charts
From cell in sheet 1 look up in sheet 2 and pull 2 cells
Formula Help
Sum of N Largest Numbers in a List
I have no idea what i need to solve this query, WhatIf? SumIf? not sure
RetiredGeek I need your help,,, immensely
Adjust salary cell to reflect employee absorbing all of the FICA
EXcel 2013 - Code seems to be bypassed if I don't put a break in
Adjust salary cell to reflect employee absorbing all of the FICA
Quicken the use of fill handle - Excel 2010
Track changes using worksheet_change event
Extract data having each record across more than one lines from text file format into excel format
Help with counting dates formula
Quick set reminder from excel to outlook
Excel 2010 - Button on All Worksheets Stop Working - Excel Update Problem?
Stop Excel Document Properties Dialog Box from Opening
presenting a picture for the active row Excel 2013
How Come Loan Templates In Excel Never Match Bills
VBA Userforms
Must be a formula (array?) that can do this - but I can't figure it out
Power pivot 2010
INDIRECT formula getting corrupted
Copy every Last available Cell of worksheets to Main workbook
Change format of sheet created using "New" shell command
Excel formula based on color?
Formula to count unique items
Difference between sheet.xltx and book.xltx in Excel 2010
across sheet countif function extremely slow in excel 2003
Solution: How to run an event by double-clicking an excel cell
Seraching using a split display
Problem pasting from word 2010 to excel 2010
Help with indirect formula
sorting macro
Need Help with and ERROR Code
How to print all vertical gridlines
Need help developing a Macro!
Need assistance with creating a script for Excel
icon conditional formating - Excel 2010
Run Time error 424 Object Required
how to direct a value to a empty cell
Excel 2010 default template
If conditions met, then move columns
add text before formula returning currency format
Add order number
Creating a query in Excel using VBA giving an error.
Populating multiple Time Pickers with a combo box
Help with a formula
Converting external links to values
Excel VBA to prevent Excel file before closing & saving
Show separate Excel files side-by-side
Need help with using Mutipule langages in excel 2010 and how to get rid of nonsense charaters
Mass extraction of URLs from hyperlinks
Instructions for textboxes
Search for Text within an inserted comment.
Excel files--how big is too big?
Macro to copy data , except where = sum appears
Concatenate Date and Text
Excel 2010 Workbook not scrolling nor Pageup/PageDown
Lock and copy files
Nested If statements
Lotus 1 2 3 opening Problem
Macro to auto increment filename in FileToOpen
Highlight specific text in a search
VBA commands to preserve displayed rows?
Excel Macro or Formula needed to create real-time (color coded) vertical chart
Excel 2013 Opens 2 windows
Converting numerical cell value to absolute or negative/positive
Simple Cell Formula Question
=OFFSET problem???
Move to multiple rows and copy adjacent cell down
how to change Excel 2003 content which shows on the toolbar?
Where is the End of the Excel 2010 worksheet?
Excel Formatting
Movement by Arrow Keys in Excel 2002
Apply trend to selected cells
Import 4 Text files to different sheet
Code to automatically accept OK button without clicking it
Using cell formula to alter another cell
View side by side in Excel 2013 not same as 2010
Arrange Web Imported Data Horizontally Excel 2007
Macro to open Files
Another if statement
how to exclude values that appear as #value
vlookup for name
Merged Cells causing issues
Cursor movements in excel 10
Divide into Group
macro text box for opening 4 digit file number
If statement
Classify Data Based Upon Cell Value
VBA Error Handling
Macro to copy data from one folder to another
Vlookups, IF, Match and Index query
XY Scatter with vertical bars in background
Excel 2010 Condition Tab coloring
Import, Append and Split
Problem with a table
Automatically Number Column
Different versions of Excel
print set up multiple sheets
Filtering a Pivot table via macro code
When Copying Worksheet to another Workbook Percentages convert to Decimals
Learning VBA - Resource Guide
Posting a row of Data Into Range until full
Trimming VBA Code
Help, please, with VB Headers/Footers on certain pages only.
Need help with cell content
formula is OK, but am i making a mistake?
Learning to write macros
How to look up data for a cell in a Pivot Table
Excel Employee Database that will work with SharePoint
"Smart" Sorting and Ordering of Rows in Excel
Debugging code
fast vba method to set background colour for record rows by Country
Activating desired cell
Open URL in user form excel 2007
Can't open Excel files with Windows Explorer
(Macro) Move Specific Files from one folder to another using a list
VBA for Automatically Resizing Rows if Data is Entered
VBA for Excel Spreadsheet using Conditional Formatting
Create an Object from Data
Importing several excel files into one to create a bar graph from all the data
Graphic behind cell data
Insert Special Characters
Help Me Figure Out a Formula
Excel VBA Macro to set chart axis max and min values using max/min formulas
I need help with a gas mieage formula.
US to UK dates
Append new row of select data from one sheet to another
Email Alerts From Spreadsheet
find first and last values with conditions
Copy filtered rows to another sheet skip last row
Excel left margin boxes 1 2 3 4
Problem extracting data from a table when you don't know where the lookup value is
Custom Format Placeholder
Odd lapsed days algorithm needed.
Data Submit Macro - Preventing Duplication?
VBA for currency symbols used on a single sheet in different locations
Line chart-changing x axis data
Barcodes in Excel
Spiff up my Lottery workbook
Print Macro with seperate headers
Help with Calendar Error
Auto-execute VBA code on workbook open
Userform chart from data sheet
Formatting numbers with VBA
Stop VBA when user selects Cancel
Sumif Formula that includes < or > sign in the criteria range cells not the actual < or > function
Excel 2010 copy/paste giving incorrect results.
need help to balance a long spreadsheet
Blank Cells Match Formula Explanation
Physical test with run time
vba to automatically adjust "print" and include borders
2 column to grid layout
Start menu drop down won't open for excel
attendance list
Problem with Excel 2007 macro
Excel 2010 Pivot Slicer
Change options so worksheet always includes folder, workbook name and tab
Investment Value
Excel incorrect result after cross-sheet sorting
Won't Print Excel 2013 Documents
Values of drop down list dependent on values of another list
modifying existing cell
Formula Problem
Symptoms of Excel Freezing with "Send Error Report" option
Copying specific account numers and values
Tuning Excel 2007
breakout stacked data to single rows
Need help extracting a date from text.
Extracting unique numbers
Need Help With 2 Excel 2003 Formulas
Modifying a macro
Average Elapsed Time
Create a custom number format
Formula Help
replace "0" with text
Excel on a different computer
Name Worksheet based on Cell entry
Word 2010 - Lost access to my other Workbooks
Date percentage calculations
VBA for updating Chart Axis based on cell value
Index match formula for point scoring
Excel WB that has required cell input!
copy/append select data from open workbook to closed workbook
Macro to create a pivot table
Formula returns Fx, I want Ax
Aggregate daily data to new sheets monthly, quarterly, yearly
Excel 2007 charting problem
Spreadsheet app
Function to convert number base
VBA Question: Combining commands to copy data to different workbooks and different sheets
Highlight text string in cell
Comparing 2 columns of data
Excel code requiring input in textbox
Opening up files in folder and sub-folder
Formula returns color to "yes" and"no"
replace default grids
Excel Changed?
Calculating Days In Cumulative Between Categories.
Help Me Figure Out a Formula?
Round times to the NEAREST hour
Plug date into cell
Macro to open up specified Files in Directory and Sub-directory
dialogstyle not working
Opening up all files in folder and then running Macro in opened workbooks
link date in a cell with outlook reminders
Merging adjacent unlocked cells in a protected sheet
Filter, select, copy, paste
Macro that adds one row label
Microsoft Excel 2010 "Not Responding message"
Track Real Time Changes In The Stock Market
Formula to calculate values > 0 on row 5 on Pivot Table
Communicating and Sharing among Excel Workbooks while running Web Query Macros
Page x Watermark
Excel 2007 HYPERLINK Character Limit
Add In MS Date Time Picker missing for XL 2010
Excel time sheet updating
Trying to create a cashflow formula but need it to also take due date and todays date into account
Rounding Difference CsV File
Vlookup with Offset
Wandering cell comments in Excel 2007
Copy excel files and folder structure from subfolders with vba
Macro to open up file and update files
Macro - copy cell value to a specific cell in another worksheet based on cell number INDIRECT
office 2003
Excel- Auto fill specific info from one doc to another
Excel Web Browser - Plotting Multiple Markers on Google Maps using UK Postal Code
Macro to extract sheet and email
VBA to select files from a list
Text to Columns Annoyance - Excel 07
Order of events for opening a workbook
Conditionally Void a Cumulative Sum
Add Signature to HTML email using VBA
Excel 2010 VBA to PowerPoint
Using If,And,Or statements
SUM cells across columns where letters represents values in lookup table
Reversal of a, Add-Sheet-Name Function
Return Column Number to use in a Range VBA
what am I missing?
VBA: changing a formula when columns are inserted / deleted
Excel Crashes with Exception code: 0xc015000f
Conditional Formatting to format only part of a cell with strikethrough?
Consolidating Data where the descriptions are common
Macro for pulling data rows
How much processing power do I need?
formula help
Dynamically move charts on over time as the data changes
#VALUE when referencing an unopen link
Macro Security Issue
Excel formula to find same date as last year
Is there a version of "MATCH" that works with multiple columns?
VBA Move a renamed sheet to a master sheet...
How do you protect cells in Excel so no one can over type them
How do you use a formula in Conditional Formatting?
Excel Formula help
Copy & Paste
Calculate the implied CAGR from three years of known cash flows
Copy filtered rows from several sheets to one sheet
Lookups/Summing in Workbooks
Change variable length of numbers to three character text
Amending User Form to set number of times data to be copied
Creating records in Excel 2000
Excel 2013 Help Needed
How to loop a macro Mac Excel 2011
Cells are up to date
Macro to list items from range is skipping columns
Reference to specific table cell from outside the table
Excel VBA to Save As a PDF
Need help with a frequency formula
Animate the drawing of Excel 2013 Scatter Plot Point by Point
Macro challenge! how to pull information across with certain limitations
How to create Lookup Tables?
Color code tabs by date
Find and Replace non numeric values in a range of cells with a 0
Query Outlook GAL from Excel using the 'Alias' field?
Change the default behaviour of the "save" button?
Excel 2010 not saving JPG image compression
Multi data validation in Advanced Filter
Problematic update of table from source
Macro to clear data on all sheets
Conditional Formatting
Making complex rolling list
Lookup (?)
excel stats formula
Test for instance of Outlook running
Excel 2013 - Conditional Formatting - Bug?
Adding Outlook alerts and email functionality to Excel spreadsheeet
Macro to copy Numeric Number and character
email a schedule
Converting Quatro Pro files to Excel
Spreadsheet "locked for editing..."
calculate time zones
how to solve this problem, getting this message in win - compile error in hidden module:modlmportxml
Pivot Table Ageing
Excel freezes and file disappears
LOOKUP into variable sheet name
Conditional Formatting
formula help
Data Validation
Displaying two values and making a time calculation in one cell
Userform textbox auto fill
Scroll Half Of The Worksheet
Looking for a Macro or VBA to help with my problem
Pivot Table - Reveal the Summarized Field Titles
User Form Code
LookUp Value and Concatenate
Excel 2010 - Simulating numbered list within a cell
Help with iserror in array
Pivot table grouping
Windows 7 Task Scheduler VB not calling excel macro but does when manually run
Day of the week scatter chart
Copy different columns from several files to 1 single column in 1 file
Border (square) around ActiveX radio button and check box
Excel Data Validation for dates changes date format
Sorting by Values and Text
.Bas file worked in XP but not in Windows 7 VBA Copy
Y Axis Crossing at Zero
Summing nested IF statements gives strange answer
inserting combo box data
12 unique combinations in Excel with random-ness
Change sheet tab color in Excel 2010 based on conditionally formatted cells
Convert Formula to Values after calculation
Maintenance shedule based on completion dates
Switching from OpenOffice to LibreOffice Calc - with difficulty
Count Unique Cells Containing Text but exclude "No DT" from count
Count unique text values in a range
Macro in Excel to perform several operations
Excel count question
Deviation Area Chart
Consolidating 5 sets of results in Pivot table into one grand total
Windows 7 fonts in Excel 2007
Macro to display message
Count unique values?
Macro to copy and paste special values
Merge/Unmerge cell automatically depending on the value
Trying to Understand
Use of a template for new sheet in Excel 2010
Width of Columns in Column Chart
Conditional Formula To Change Font Colour
Subtracting Hours in Excel
How can I modify the "Normal" Cells Style using VBA?
Need to create a report using the Master data from the Pivot Table
Bridge Scoring in Excel
Formula help based on two criterai
Need assistance with popup calendar macro in 2010
#N/A when sheet is protected
Excel Date and TIme Calculations
More Problems With Time
Formula problem
How to paste values by row in loop?
Compile error with Excel 2010 spreadsheet
Hyperlink Problem
Filters on Pivot Tables Excel 2010
Is this a Lookup Function
array formula question
Change some sheets in several files
Working with hours and minutes
Macro to Print a PDF Document from Hard Drive Excel2011Mac
Workbook not opening on first page
Table Headers
Multiple Full Stops (Periods) Errors in Excel
A vexing Chart issue
Excel Cannot Complete This Task With Available Resources
Want to rename columns, delete unwanted columns, and reconcile reports
Printing batch files in Excel with pdfp
Date Format Wrong
Sales forecasting
Vba macro code for calculating averages those which have more than one value...
Macro to copy data into Word
Button to Close Workbook
Excel formulas PV , FV other
Fill anniversary dates
Match columns A,B in two sheets and Bring ColumC data
Excel - Tracking Labor Hours
How to auto fill days when input dates
Need Excel button (macro) to consolidate information
How to switch the categories in a RASI spreadsheet with the data
VBA macro code for grouping data based on 2-hour time intervals
Copy Data From Multiple Files in different locations
listing variables used in a vba routine
Copy column from several excel files to one file - vba
help needed with pivot table
Macro to automate formula
Opening workbooks in seperate instances of Excel
Open multiple workbooks based on cell values and copy and paste information
Obtaining 3 different time range counts from one Time field.
sorting worksheets in a workbook
create new folder at one location and copy photos in that folder from other location
folder creation and moving pictures into that newly created folder at different location
Need to create summary of data in two-column table
Replace a worksheet currently in use
Conditional Formatting Help Needed
How do I position graphs next to a cell in VB?
If cell 1 contains a value make Cell 2 = a value
Excel 2007 changes view
two looked up numbers side by side in one cell
Excel 2010: Visual Basic Error on Closing Excel
characters w/ different fonts in a cell
Microsoft Map: from Excel 2000 and earlier
Excel 97 print settings
*** ~ 1) Basic Referencing Cell From Another Sheet & 2) Counting Instances Of Anything ~ ***
SUM() excluding errors
Macro announcement
Using IF to find a text string within a text string