Windows Secrets Lounge

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

DATEDIF Grief

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