Windows Secrets Lounge
Finding First and Last Items
Using Goal Seek on Multiple Rows
Indirect Validation formula getting corrupted - part 2
Using Check Box to show only rows of data that contain a specific word
Protect Range with Password
Saving a file under VBA with cell reference
Trying to restore automatic download
Bid tracker workbook for excel
Finding rows with a blank first cell and concatenating other cells in the row with the cell above
Outlook reminders from Excel - YES, AGAIN!
Update Data in Worksheet with Userform
How to plot 2 values per row sequentially?
Import xlsx sheet from server to existing workbook, etc.
Save Selection of a Sheet as PDF
Match Columns from two sheets get results
Select unique records and save to new text file
Copying data with two criteria, from a grid work sheet to another worksheet
Pivot Table filter by Year
Can I control printing with a macro
Help needed with a formula combining lookup and if statement - Excel 2010
Excel: Send Range of Cells to Email Based on Contents of Cells?
Excel: Send Range of Cells to Email Based on Contents of Cells?
Help with writing data using VBA
Averages from data in table based on 3 requirements
Blocks on Excel 2013 When Maximized on 28" Screen (Dell P2815Q)
Print list of PDFs from URLs in Excel columns using Macros or VBA script?
Help with sumproduct
UDF to parse formula
Macro to Extract/Update certain data from text file to spreadsheet
Data Recovery Software to repair and open corrupted file
Populating via "Lookup" (Maybe)
Calculating time difference in military time
Want to Learn Excel?
Combining amounts from two different schedules into one schedule
Import a Specific File
Copy value from a internet page
Move Files from one folder to another based on date
Transfer value of combobox in userform1 to textbox in userform2
Pull Out Number if Cell Contains a Number
Macro to open up files and copy to row after last data
Print Macro for several sheets
Create Reminder in Outlook using Data from Excel
Change VBA code to allow both string and integer to be entered into a text box
How to set up a colour code system using excel
I need to Pull data from one sheet to another based off cell value
Search file content for a specific string contained in cell and return the file path in next column.
Copying a file from One Folder to another
How to have user add a line keeping formatting and average running correctly.
Interactive scatter chart with mouse
Macro to show sheet name and value where the is a variance
Changes for Excel 2016?
Delete Unwanted Lines from Text File.
ms excel or open office spreadsheet
LINK EXCEL 2013 to WORD FORMATTING ISSUES
Help with Code
Create Excel Form to collect data from emails
Macro or tool to compare two Excel spreadsheets
Strange = behavior has me pulling my hair out.
Create formulas in Excel and populate reminders in Outlook (Excel newbie)
How to automate process of replacing semi-colon within cell with line break (Alt-Enter)
sumproduct vs sumif formula
Opening multiple Excel windows - Excel 2010, Windows 7
Having troubles with conditional formatting formula
"upgrade" of pivot table
Help Import Text File and Create Summary
Formula to compute value in Total row based on Column Heading in seperate sheet
Code to email Sheets
Function for compound interest
Can an Excel sheet show a description of the custom sort levels in the header/footer?
Code to help user memorize stuff
Help with CSV. Copy values from 100 CSVs into an excel
Help with CSV. Copy values from 100 CSVs into an excel
Rounded number format
Excel 2016 default book isn't working
Show or hide rows in each sheet except Master sheets
Running Excel2016 and other Excel versions on same computer
Display only one record before sending email
Excel novice pulling my hair out-Vlookup doing random math & can't find external links
Excel -> Outlook Task Reminder
Can't make date format match downloaded data
Excel Calc to increment a value.
Data Validation - List change
How to assign monthly reminders from Excel to Outlook
Radio buttons on a form
Using the Excel Name box
Prevent Copying of Cells into Workbook
Format cell for dates & e-mail addresses and have cursor return to start position
Excel Cannot Complete Task with available resources
Conditional Validation and No Null Field requirements
Can a Custom Sort created in an Excel worksheet be used in another worksheet?
Microsoft Excel has stopped working
Excel VBA exits on function call
Sort dates in ascending order
Difference between afterupdate and exit
Remove specific conditional formatting
Moving from Excel 2010 to Excel 2013
Pulling data from 11 workbooks to summary workbook
Interior color change event
Excel VBA Code To Change a Frame's Properties
Creating sheets and copying data
Extracting uppercase text from a string
Script or macro needed, or instructions to create same
Permitting users to edit only their protected tabbed sheet in a shared excel 2013 workbook
Possible to compare data of two sheets with VBA?
Excel - Macro to allow different clicks for different view zooms
Excel 2010 The clipboard cannot be emptied. Another program might be using the clipboard.
VBA Code to convert Numbers to Time
Need formula to eliminate values
Transposing data from a horizontal schedule to a vertical schedule using formulas
Calculate gross after net less a tax rate
Time Stamping For Excel Documents when opened and closed
Trying to work out a formula to sum 7 days of data
Formatting Time in VBA so user can enter am/pm in cell
Excel 2010 File Sharing Violation - or file corruption ?
Anyone else use ASAP Utilites...
Need formula help
Issues opening an Excel 2013 worksheet by right click
Max/Min on Index Match Based on Color
Can't make excel 2010 start with default template
Changing Date format from one to another
Excel Online - Custom Number Format
Date and Time
Assign different values to Yes/No (Yes can be 1,2, or 3, No is 0) and total
Formatting for Word
Export multiple (specific) worksheets to CSV files in a specified directory
Open, Copy, and Paste macro in Excel 2010
Unable to find next blank line and move data
Excel macro to remove rows
problems with vlookup
Problem with updating Charts Excel 2013
Formula to increase % of units based on site type
Trying to capture a constantly updated value, Excel 2013
Hyperlink to spreadsheet tabs
Macro to copy values from a closed workbook to the current workbook
Export Excel spreadsheet to fixed-width text file
Condense Text Running Down a Column
How to enter data into a table and have it name and populate a given template
VBA code to apply conditional formating
How to align Bold words to the left or right
Utility or Productivity Suites for Excel
Conditionally format a row in which a cell meets the condition
In dire need for help with Searching in list...
Macro to read filenames from a folder and create delimiter text file
Excel Recent List (Excel 2007 - Win 7)
Macro to moves files based on a period
How to index match MAX or MIN value of a partial text in a table
How to refresh separate-instance workbooks?
Macro Help Please
Need to revise code in spreadsheet
Sorting items by color
User Defined function problem
Macro to use advanced filter to extract data to respective sheets
Convert Formula to Macro
Add Date Range to SUMPRODUCT Formula
Using Data Validation With a Custom Formula
Excel 2010 - startup macro problems
Custom Date Format
Excel dates to Outlook reminder
Hyperlink in VBA
Wood Roundup file
Populate Cells Based on Matched Criteria and Enter Value From Another Cell
Summarizing the totals of a subtotal worksheet
Excel - coloring points from complex selection of points and sorting
How to add a Pop-up message
Filter selection across columns
Text suggestion & Type determination based on predetermined item name list...
Macro to zip files in folder and sub-folder
Alphabetical Sorting in VBA
ClearContent with Range
VBA txt log file maker for 3 separate .txt log files - needs "overhaul"
Result extraction back to "Sub worksheet_change"
Unable to open dbf with Excel
Formula with 2 IF's and 3rd statement instead of 0 ending
Move zip fles , except last zip file
SUMPRODUCT to VBA
Error invoking Excel from Access 2013
Opening Excel 2013 XLSM opens XLSB? - can't hide
Code not working on most of data set
Expanding formula to a range...
Need help with subroutines...
Code to prevent Duplicate Worksheet Names
Sorting Sheet Tabnames by group type, number and tab colour
Lottery Workbook Update
Decipher Line of Code
Need SheetName handling help :)
I need help with one If statement...
Execute Worksheet_change after sheet was updated via vba...
Update Date When WORKSHEET is CHANGED
How to set email reminders from Excel
Macro to move file from one folder to another
Update 2nd sheet when 1st sheet changes...
Combo Box data disappears after first use
Module to print a series of PDF files from within Excel 2010
A simpl(ish) way of getting the nth word
A Bit of Nostalgia While Choosing which Excel to Open a File
Populate Cells with Row/Column Intersection
Type mismatch help
Front End/Back End solution
Corrupt excel .XLSX file
Import Data date changes
change column or rows without affecting other columns and rows
Macro to delete unwanted Rows
How to pass the result of a Frequency Function to an array
Pivot Tables for excel 2010 total count greater than 5
Number of journeys on a particular day
Clearing Data in same row based on certain Criteria
Vba code help to sum dynamic range of columns
Formatting longer numbers as text gives the 'E' expression
Web Data Query Possibilities
Adding physical dashes into text-formatted numbers
Text box value from a web page copy and paste
VBA Code to Get Value from A Cell in Another Worksheet
VBA to validate the data
JSON format and VBA
Clearing Form After Entering Data
Excel 3d charts
Disabling paste into cells
Delete leading/trailing spaces from a range. Excel 2003 VBA
Need chart help
Moving formula from sheet to VBA...
help with time in excel
Trigger A to Z sorting without knowing the exact starting row...
Delete cell contents once another cell has data
my start menu is missing an 'arrow'
Conditional Formatting (Excel 2010)
Making Monopoly game on Excel spreadsheet
how to get the count of passed rows and display in summarysheet
Copy pasting a cell range involving three sheets and batch processing
Convert Data to US Map
Dynamically expanding template, cell numbering & turning formula to value after running.
Move file from One folder to another
Count Time Entries
Is IE Web Browser Excel's only default for web DATA query ?
Formatting Text Boxes in User Form
More than 2 contains filters using autofilter in VBA
Seemingly Complex Counting
repetitive line graphing strikes again
Add text to a formula
Locking Pie chart wedge colours
spreadsheet with minutes
sort into rainbow order; Excel2007+
VBA to color Active.Cell with Arrow key syntax
Converting Google Drive Docs to Google Sheets that I could use and keep up to date
How to send email automatically when cell value changes
Copy and paste cell value based on fill color
Apply a rule to all worksheets
Using excel to create task reminders in outlook
Date filter criteria not being applied
Excel SUM formula
Index match paradox
Copy Data problem
How To Separate Text And Numbers From A String
Where's help for VBA in Excel
Importing file names and listing
Interrogating data #2
Relative to Absolute Macro for If Statements
Rename the sheet with cell value.
Sorting monthly sales after checking date...
Correct syntax for ElseIf formula
Macro to Open workbooks and copy data to respective sheets
Where do I find a list of all possible actions for .cell
Worksheet Tab Conditional Formatting According To Date
Sorting a Pivot Table by value - Excel
Reduce stocks of items by 1 when a button is hit
Adding Lastworkday Date
refresh appears to delete rows of cells
Automating single iterations to test random data
VBA Code to send email from secondary account
Showing (or formatting) only columns that have an item in another column
Google Doc Spreadsheet with row protection...
Conditional Formatting - Changing Font Color Changes Font Face
Copy Data to specific rows
Want to add functionality in the macro
Conditional formatting if cell value is < or > value in another cell
Formula to extract new account number
Capturing a count that later changes
Sorting multiple worksheets at once
Conditional Formatting (Excel 2010)
Pivot table: How to count the same variables in different columns
Percentage of total...GOOGLE Sheets
EXCEL: How do I use 'SUMIFS' with multiple criteria but a 'sumrange' of multiple columns.
Unusual Table Lookup
Set up Outlook calendar reminders from Excel for follow ups
Paste an array to another with beginning the next empty range
Problem with drop down and Vlookup (Might use a while loop)
Formula to compute net amount per control
Pivot table sorting
ISTEXT and VLOOKUP
Excel Save as CSV Question
Move a range of cells up or down of another to change sequence of production items
clear contents of a range beginning from last row with null value at a cell in a given range
VBA Code to Open Workbooks saved in a common folder and copy data into destination workbook
distribute data over a length of time
how to create backup file in Office Excel 2007
Additional Help Please
Vba code to merge differnt sheets from different workbook into different workbooks.
Sending emails and referencing specific cells
Sort cells between 2 sheets
Using AVERAGEIF and OFFSET for the range
Sparklines: Conditional formatting?
Excel 2010 - Deleting columns
On Selecting subcategory from the dropdown respective main category should display in the next colum
Not sure what function I need to use.
Follow Up to Jaggi's Closed Post
sumproduct: 0 vs valid value (Excel 2010)
Getting error Excel is not able to complete the task/ out of memory
Code to add data using entry form
Problem with Excel 2003 toolbar buttons
Lock the cell after the date is added.
Problem updating links to another workbook
Closing a thread
Problems moving Excel control sheet
need help to copy data from one file and paste it into another
How to set tip in text box in Excel
2 computers - vba to extract data from access works on one but not the other
VBA to copy the header and copy range
Help with nesting Sumproduct and Countifs
Can someone explain problems with .xlsx files?
3 Email notification before expiry dates
Is this a Word or Excel issue? Mail Merge font problem.
3 Email notification from Excel before expiry of date
Want to return Data Validation list location
Need Excel print macro to exclude few worksheets from printing
Search / read text file
Convert excel formula to vba code
How to Populate Word Form fields using excel data
Excel 2010 - Formula to get result of basic sum and replicate into every 5th column
Linking spreadsheets to calculate totals
Count by days of the week
VBA code to browse to/open an excel file, select data, then transpose it into the original file
Having an issue with my Pivot Table, wondering if someone can help me and show me the way
VBA to import all sheet
Using Indirect Function in Sum Formula
Excel 2010 - Filling and formatting cells based on a date
VBA code amendment help.
junk file for Maud
Linking Name in Code to cell address
Sum Column B based on Column A and format it
Set email address in Cell
code to highlight Excel row upon hover
Returning a value in the last filled row of a particular column
Code to color row if two conditions are meant
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
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
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
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?
COUNTIF, or DCOUNT?
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
Macro to open workbooks
display column headers when viewing workbook
Count same characters at beginning of string
Excel 2010 - How do I change the DEFAULT tab color?
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
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
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
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
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
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
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