Windows Secrets Lounge
sorting worksheets in a workbook
GETTING RID OF #N/A resulting from a VLOOKUP FORMULA
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
Using IF to find a text string within a text string
Extracting text from the middle of the Cell
How can I stop my macro from asking to copy a name that already exists?
Formula Help Please
Predicting what the next numbers will be in a sequence?
How to pull a cell value on separate worksheet based on multiple criteria
Average of recent entries
Collapse range's entries by removing some values
Date to be displayed within a formula
Excel - data validation from a list multiple selections
using parent directory with .SaveAs
Automated Macro in Hourly Basis Pie
Formula for excel 2010 to compare dates in cells and return sum
Formula to Rank data
Date search problem
Useful tips from Microsoft!
vlookup link changes - suddenly
Need help - Mutliple IF conditions
pivot tables and excel sheets saved to intranet sites
Creating cells that draw attention .
Function to find out-of-order dates (Excel 2010)
Set up Outlook calender reminders from Excel
Creating new To-do/timeline form
help ADD "if" cell is blank do nothing
vba to insert rows
CSV's don't import properly if a macro has been run
Delete Excel Page
Page X of Y
Count unique numbers in a spreadsheet
Need themes from Excel 2010 for your Excel 2013?
Send Email & Body contents from html file
Macro to create privot table
Chart updates from rolling columns on Excel 2010
Formula NOT displaying 0 (zero)
Version 2010 Excel problem with external linking
Highlighting Values using conditional formatting
Extracting color cells in Excel 2003
Macro to run for each change in column B
How do I get a user to select several items?
Copy from one sheet to another depending on the date entered.
Deleting blank rows
How to use a date field within my spreadsheet as notification
Open attachements based on start date end date
Format/Strategies for HTML Output
switch windows Excel
Removing <CR> and <LF> from a field
find 1st value GT 0
Windows 7, Excel 2010: Strange behavior of macros/functions
Conditional Formats Office 2007 And Windows-8
Would you use SUMPRODUCT of SUMIF?
very long load and save times with excel 2007 windows 7
Unable to determine download link
Excel conditional formatting to repeated values in row with condition
Problem with Pivot Table.
Saving html files in Excel 2007 problem
moving blank tabs
Excel 2013 crashes when editing
Selecting a Range in a Macro
Missing Sheet Tabs and X won't work...
A useful piece of paper to print off?
Macro to print 2 areas from spreadhseet with different titles
Hiding balance in unused rows
Generate a list of DOC files that contain a key word
Is it possible to create a library of useful routines?
excel if and ranges question
detecting duplicates on excel 2003
Finding Unique Entries (again)
Text to Date Value
continuous space keeps on going to next next line in wrapped text
Look up value in fixed decimal places
Set rows to column
Sum A Group Of 7 Rows On A Second Worksheet
Create a new sheet with month name and year name with monthly calendar sheet
Using Solver and Goal Seek
spreadsheet profile picture
Append file name while importing in Column A
Importing data from a txt file and parsng the data
Set Column Headers
Macro needed to export Adobe Acrobat FDF Comments file to Excel
To calculate or not to calculate
Adding 2014 to a date range causes errors in spreadsheet
Sum - if a4 = "x" and w4="20" add up all the w4=20's in the rows from row named nameA to nameB
Excel quadratic function calculator
UDF for Sum alpha and numeric caracter 2
Problems with validating dates in EXCEL
Help with Copying Sheet from One Workbook to Another Workbook using Excel VBA
Syntax in macro
Overlay shapes issues in Excel2007
Bookmarks in VB code
How to find attributes of ".cell" I can use?
Excel: Lost "Recent" list
reducing the number of copy operations during an update
UDF for Sum alpha and numeric caracter
Center Pie Chart in Excel Cell
VLookup over multiple worksheets Excel 2003
If statements with two critera
I need help with a spreedsheet that shows my average tips.
Obtaining the % of total for a list of items
Excel 2013 Error - "There was a problem sending the command to the Program"
Hyperlink in a cell
Format for Pivot Table to Hide the "(blank)" result
Extract Middle Part from Numeric
If commands with dates
I can see them but I can't load them
Excel2007:vba to copy rows, including hidden rows
include formatting when referencing cell.
Excel 2007 side scrolling does not work with Logitech M510 mouse
Excel 2007 SaveAs question
Excel2007: Checking visible cells for a specified text prefix
How can I reliably indicate progress through a program to the user?
How can I limit what files a user can select?
Here's something back for the help I have received
Clearing values but not formulas ?
Including comments in referenced cell
Data Validation/List Question
Cursor movement in Excel macro
Excel2007: Resetting Autofilters on a protected sheet in a shared workbook
Excel 2010 crashes when I use a keyboard short cut
Change data marker shape and size on line chart in 2013
Renaming all tabs in a spreadsheet and clearing their entries - Excel 2010
Excel COUNTIFS help
multiple variables in one formula
Pivot Table Help
comments in printout (Office 2003)
Enter dates between specified dates & set Print area in Excel
Need help with conditional formatting
Macro to let user choose 2 different workbook, vlookup then copy data to the current workbook
Locked for editing by me - why?
Not enough resources message for the first time
How do I keep Excel from changing (R) to ®?
Using VBA to automate pivot table creation
Conditional Format based on adjacent cells being equal
keep rows in view
Create an Object from data
Spreadsheet for calculating interest and loan payment on judgement with no ending date
Error message on Function that worked in the past (Excel 2010)
No Previewer in Excel 2010
Conditional Format based on Language Contained
Send mail body from cell value and text file
copy and paste
Concate email address
Populate next Column to Right if blank
variable based on total
Converting image to text
Changing multiple names to pseudo-names down a column
Multiple If formula with TEXT
Alphabetical sort of burial book
Calculating Stdev and Averages in pivot table that has multiple columns.
Text to Column Question
Combining Subs / skip one if file not found
Excel out of resources
Excel 2010 - check boxes and option buttons move after save and re-open
Convert 2nd MinRange Formula to VBA Function
Date format in Header
separating numeric and text in a column
Import Multiple .CSV Files Into An Excel File
Converting valuesin proper number
The document was saved successfully but excel can't re-open it
Table Index/Match problem
Remove last character in cell
Web toolbar - unwanted appearance !
Create a form from another worksheet
Excel 2010 - copying and pasting to an existing graph.
Trying to figure out if there is a formula that can...
Activating second part of macro
Using Array in Code to select two sheets
Code to match reference numbers
Excel Spreadsheet for Top 25 Rankings
Generate a list of worksheets
Get Sequence of Date then sum in sum sheet
Writing a function to another workbook
Copy print areas
Search or Find String Value
Excel 2010 - extract date from date and text field
Sorting chart without sorting data
Creating drop-down list
IF find Zero average the previous 5 values greater then 0
Turn columns into rows from on sheet to another
Need help with some formulas
Excel help with spreadsheet
Macro to clear data & open files
Structuring Pivot Table
Returning table to another sheet
Modifying formula to remove #N/A error
Returning value that fits all criteria
Names Nightmare (Excel 2003)
Conditional Formatting Help!
Moving & Deleting Columns
Excel Formula Bar & document recovery
How to change column heading from number to Alphabet?
Custom Sorting crashes Excel
How to display No. of Rows and Sum value in MsgBox
How do I display a listbox in VB?
VBA for conditional formatting, but not applied dynamically
Macro or Formula to delete rows where values and stock $# is the same
Sort a list for the size of each row
Exported as Text file to have a Header line
Compare 2 sheets
Excel: Clicking in one cell annoyingly highlights several cells
Excel formula wizard - not inserting commas between arguments
Finding Unique Entries
Networkdays (Excel 2003) UDF
Delete Duplicate Rows
Copied a worksheet, now combobox is broke- what happened?
Create calendar from a list
Run Batch file inside the selected folder
Get Values and report blank cells
Protected worksheet with subtotal function
Delete both duplicate rows
How to count text values from multiple cells in one cell
Need a clue on managing data on date that is split into three cells
Lookup function problem
Autoincrement a single cell on a template
Ap ageing worksheet, to ten vendors, protected worksheet
Finding date to match MAX and Min values (Excel 2010)
Search All Excel Files On Drive If Data Already There
Sending text via email results in unaligned columns
weekly average for daily data
How do I close Excel from VB?
VBA FileSystemObject Properties: Dimensions, Size and Vertical resolution
Merge multiple workbook with 1 sheet each from one data to another
Macro to open file and copy data
Message to warn which sheets have a variance
Force Web Pull Macro to Run First
Best way to match a cell value on worksheet
If Date is Day Before or After Holiday
finding duplicates in a data base with 3 three criteria points
Constants Declared, howto call sub from userform
Summing columns until all totalled
How To Close 5 Instances Of Excel 2007 At Once...
Macro to create index sheet
Can I create a standalone VB program to access Excel spreadsheets
looking up for a cell in multiple files
lookup or vlookup using Excel 2010
sum across various conditions
convert id number into date
Vlookup & Subsitute to get result
Establish a Pattern in Excel
each worksheets in a folder copy header and last row paste masterworkbook
list and calendar on excel
Drop down list
Trailing 26 Periods for Charting
VLookAllSheets excluding current sheet
Insert sheet based on Template and Cell Content
Files not visible in folder
Can't enable macros on 2010
Macro to split out spreadsheet-Reopened
How do I reset a spreadsheet to it's original starting point to make it reusable
Web query VBA
Multiple sumifs formula in a cell
Auto adjust the vertical axis to the same scale for four graphs in the same workbook
Macro to delete Row & Sum
Macro To change Month in Link
Total invoice amounts by project
Copying and pasting a matrix from one workbook to another
Excel 2010 - Beginner help - dates along horizontal axis rather than vertical.. how can I change?
Macro to split out spreadsheet
Importing multiple XML files into Excel
Macro to delete Numbers
Computing Concurent Usage from Log File with Multiple Criteria
Error message after cut&paste Word-->Excel 2010
Error when creating pivot table
Search Files in Folder
Restrict cusor movement
Web Query to get all result pages
Lock down Excel's custom quick access toolbar
convert folder listings to excel
Macro to delete rows where values are the same
Excel 2013 - so slow to open!
Excel: Conditional Locking or Data Validation
QuattroPro to Excel conversion
Imperial to Metric conversion
Total filtered items only
Needs some modification
Extracting Data from Excel Database
Programming Excel w/VBA
Find High, Low, and Average Price
display conditional formatting rules
Concatenate, Remove Period and Save as Text file Through Macro
Denormalize a variable number of sheets with variable number of rows into a Summary sheet
Help with Code
Need a Macro
Parsing data from xml file in folders and subfolders
Creating Buttons in VBA
Protecting Hyperlink in Excel 2010
a blank cell result in Excel
assign variable in data fill
Excel: Dynamic Range
Extract specific text from a string
How do I copy different columns of information into one column and then add...
Excel 10 - Disable Automatic Hyperlinking
Produce a count of types?
exclude zero in pivot table
Excel: Solving Bloat and Corruption
x-axis format problem: How to label the first date and ignore the rest of the day
open *.xls in already open Excel 2007
Need Help Looping through Sheet with Concatenation
copy and paste document names into a spreadsheet
Extracting data in Excel
HELP converting .txt to excel with certain data stripped out and reorganized
Using SUMPRODUCT between worksheets matching but cell content
Help with setting up loan payments
Delete Blank Rows
Excel 2010 Time on Y-axis?
Using NOW or TODAY with DATEDIF
Excel: Need help with macro for data management
Selecting certain cells to record in another tab
Libre Calc adding a new sheet
cannot get proper sorting
Formula to compute value based on Ageing
Search files for information contained in Excel cell and return path
Convert Excel formulas in VBA code
Pivot Table - Grand Total for Rows
Writing to cells in Excel 2003
Importing (truly) random integers
Setting the months displayed for a 3-month date picker (Excel2010)
Custom Number Format for Date
Show last birthday date in Excel 2010
Hide properties in one tab
,Run batch file from VBA
If formula using time
Number format error
Customer Sheets and Customer List In Same Spreadsheet
Show last birthday date in Excel 2010
Count including decimal places
Excel XP can't save
XL Macro to place date in sheet header
Excel 2007 Conditiona Formatting Formula help
XL13 - Worksheet tab navigation
Calculation appears when it should be an error
Macro to hide rows based on cell value
Excel Time/date and phone numbers
~ merge two spreadsheets with one sheet each into a new one based on matching ids. please advise ~
Delete range of numbers
Best approach to display days, hours, minutes
Macro to extract specific desciptions
Help with Offset
Macro to highlight Data
Hide Rows Where data is zero
Print External PDF Files from Excel Sheet
RECORDING STARTING AND ENDING CONTROL RECEIPT #s
Macro to range value items
Show message Box and delete rows
What-If Analysis Data Table
Copy a cell format from one cell to another?
Dates in the columns up to last date of the month
Loop through excel files in a directory and copy onto master sheet
Email to Excel
Have I found a sorting error in Excel?
Coding Problem (Excel 2010 VBA)
vba to set worksheet Tabs based on Language
Find-Replace Formula to VBA
need to change 0 or 1 to show as an empty check box or checked checked box
vba to rename Tabs based on sheet codename
Macro to move files from one folder to another
macro project unviewable
Solver constraint problem
Using Excel vba to stuff a new page into an opened Word document
XL '97: Current printer is unavailable. Select another printer.
combining data from one column all into one cell
Excel 2007 - problem breaking links
mail merge (?) on certain rows of sheet with access records included too?
solve for x ?
Reporting in Excel by data source (SQL Server)
Excel Digital Clock
Several Excel 2010 ?s: mostly editing hyperlinked text issues
VBA Currency format issues when users around the world run it
~ how do you add the horizontal axis labels to a scatterplot when the 'edit' button is blanked out?
*** Simple Muti-Series Line Graph ***
How to count no. of occurrences of a particilar value in a cell range
Inject code into another workbook
Shortcut question using Open Office
Can I change code on the fly?
Combining several workbooks
VBA instead of formula
formula help and adding error
Numbers blurr when cells add up total
Error Bars with log scale y-axis
Saving File as CSV-zeroes removed
If and statements
Creating an XML file modified by data in spreadsheet
Pop up Message
File closes on scrolling down Excel 2007
Macro for fetching data from dynamic range of a spreadsheet to another spreadsheet.
Automate deleting filtered results
Data Matching problem.
Importing scenario parameters into the Scenario Manager
IF formula, but a paradox
Un-protect worksheet without PW
Data Connection build up "fix", Macro
Moving average, variable date range and number of entries per day?
Summing a column based on the number of the row
Moving data from one sheet to another based on a "key"
can't insert rows or columns in excel 2010.
making duplicate cells unique by adding counter
excel ghost - cant x out of it - have to ctlaltdel select and end task
Large data set filtered to new tabs
Create pop-up map in Excel
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
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'
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
Easy (?) Subscripts and Superscripts