Windows Secrets
Windows Secrets Lounge
Email file in PDF
Cover Sheet results
Word form to collect data for Excel spreadsheet
Summing one column by choosing the cell marked by another column
Excel formatting hekp
"IF EXIST"-type formula
Summing across multiple worksheets based on variable data
Issue with the data while converting the .CSV to .XLSX
Restricting excel cell editing
Need ideas for tracking inventory lead times and capital forecasting
Hyperlink autoexecute
Copy data from closed workbook if changes are made
Draw line graph automatically in each sheet
Using Excel to find easy to remember phone numbers in a long list of numbers
Spreadsheet help...calculating totals based on a date
Summing a variable number of rows - how, without a macro?
Help with code
Conditional formatting issue
VBA Automation error
Macro to remove values in formulas
disable osppsvc.exe
Checking for existence of command button
Importing multiple XML files into Excel
Using VBA enter three letters of a word into a form or cell and have a msgbox show a list of words
Making a Macro to send dates from Excel to Outlook Calendar
Need further modification in the below code.
Need a Macro for Production Sheet
Need help to add loop on the sheets
Box/Gridlines from Excel when pasting into email/Word
Tracking Changes in Excel 2007
Automatically adding variables to entries based on former entries.
Need to get results in message box
Excel Web Data Query - Parameter problem
VBA - select Cell containing named range
VBA - select Cell containing named range
Using indirect formula within Vlookup
Grouping and subtotaling data
Counting Excel Cells By Cell Color, By Text Color, and by Specific Text
Maintain Format
Formula error Sumproduct , combined wth Index and match
Two numbers in same cell ($ and $/sqm)
Excel 2013 Select data by date and move to new sheet
Delete cell contents if a condition is met
Macro works in EXCEL 2007 but not in 2010
Macro to insert date
Does Excel create error logs?
Doing a query of data with a dialog box in Excel
Split Master sheet to Multiple
VBA Code to Count Consecutive Days Worked
setting up input box or combobox to copy data based on selection
Non Repeating Output List from Excel Equal to Input list
Excel 2010 scatter chart setting to make major horizontal axis by month
Leave Roster
Macro to open workbooks
display column headers when viewing workbook
Format help
Count same characters at beginning of string
Excel 2010 - How do I change the DEFAULT tab color?
Cell calculations
Change input value based on certain criteria
help and guidance needed after self inflicted havoc
Sample data file with 125,000 records
Animated Bar Chart
Regression error
Re arrange Date in Column from yyyymmdd to mmddyyyy
Formula to extract ref numbers
Form - Hide Questions if answer not required according to age criteria
Macro to extract data based on certain Criteria
Same Day of Week Last Year
Creating Automatically Generated Emails in Excel When Criteria are Met
Suppress Chart Axis Labels if Value is Zero
Random name generator?
Run macro in another worksheet (Advanced )
How to move specific data from one sheet to another.
macro to refresh values
Formula for running average
Sixteen digit number formatting problem
Excel database duplicate validation
Sorting Worksheets Based On Specific Cells Values
Track Real Time Changes In The Stock Market Additional Help Requested
Purposeful Circular Reference, resulting in 0 when linked, anyway to avoid?
Excel VBA Pivot Table Outline view for Date filters
Freeze rows Excel 13
Grouping in Distinct Counts
Sorting rows by excluding decimal containing rows
VBA Script for Excel 2010 - re-populating a cell based on values in a different cell
Selecting item in Drop down
Fatal error
Help Viewer not working
Sumproduct formula in pivot table
Eliminate Doubleclick link and convert to real link
opening a new excel spreadsheet
Output in current workbook instead of a new workbook.
convert the numerical result of a formula so that it can be sorted without the formula operating
Adding hours to a date and time
Interval between repeated events?
Macro to send data to master file from shop-floor file
Macro to check if existing data
Formula help
Excel keeps increasing in size
Countif for various possibilities
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