- insert blank rows and fill in subtotal
- Find Data and Highlight Row (& move row)
- Using .find in VBA
- Looking for some guidance...
- Easy Validation Question
- Function key question
- Userform Text Box Format - Time
- user form - post into seperate workbook problem
- Export.xll trying to Find a Recent File Version
- List on another Worksheet
- Listing cells that have text to another sheet
- Attempting to Create Inventory List....
- Formula to return tab name
- Array Formula Update
- multiple worksheets to summary sheet
- Calendar control
- Length of Entry in a cell - Numbers only ????
- Keeping info from a changing cell
- Delimited File - Macro???
- Macro to Move a Range of Data over 1 cell, If a Certain Condition Exists
- cell borders
- Macro Security Settings
- Sub Total Problem
- Using autofiltered criteria values in Excel2007
- Show no value until user enters
- why isnt this working
- check box
- usig case select
- Count of visible cells with values in column
- Check E-Mail address entry is valid ???
- Naming new sheets according to cells values
- Help! Do not understand ActiveSheet
- Start a Macro when Cell Value meets Criteria
- 13 day cycle, no weekend work schedule
- formatting text in comments boxes
- Excel Formula Help~ Please Advice!
- Multiple sheets: make visible
- Email Macro
- Add object to comment
- Populating Multicolumn ListBox
- VBScript needed - import data from specific cells into new worksheet
- Changing the value of a string
- Combining same items at different locations
- get last day for each week in month
- Calculating times between shifts
- Cell split?
- Help with FLOOR Formula
- combobox no. argument
- Embedded IF Statement
- Copying formula to row below
- infinite looping..
- Merging Rows to new worksheet
- XML Schema and Web Query
- Compile error: Can't find project or library
- Reference Sheet Name from list Then SUM(IF...
- Macro to break links when saving to a new file
- Excel Gantt Chart
- Cell Border Color Change
- Best way to clone "page setup" settings between sheets/books?
- Edit > GoTo > Special Question
- Multipage - How to re-initialise?
- Macro pulling Web Data - Range issue
- Secure a Cell?
- Subtotal SUMIF
- Group columns including command button
- Adding diagonals to scatterplots
- Extracting info from A series of spreadsheets
- VBA open file and get
- AutoFilter: Critera from another worksheet
- History keeping and change cell time keeping
- Deleting Rows
- Copy to another sheet based on values
- VBA Not Equal Statement
- Page Break @ every change in value
- Duplicates
- Protecting Drop-Down Boxes
- Conditional format If else
- would I use a nested for/next loop for this?
- Posting info from one worksheet to another PLUS more
- Wrtiting data from multidimensional array to range
- Macro Stopped Working
- Minute Conversion
- Deleting an "object"
- 3 home games in a row
- Altering percentages to add symbol, but not formatting
- Complicated Infinite Series Calculation
- I Need To Have A Formula Automatically Update
- activating a specific cell in a sheet
- Links broken... but they're not!
- Quick question
- Copy Formula
- NPV within a Range
- Date & Concatenate
- working out a mathematical relationship
- Counting How many cells are not blank
- Pivot Table vs. Sumproduct
- trunc alternative that returns decimal rather than integer
- Leading 0 (zero) formatting via formula
- convert .xls to .txf
- Allow to Use Combo Box in Protected Sheet
- Run macro in all excel workbooks in a directory
- date formatting in a pivot table
- Formula in VBA....again
- Can I have the user scroll through range and then select
- Countif
- Need help with a kind of summation related formula
- Days in Month
- Loop thru form labels
- Conditional Macro that merges like results
- Merging two sets of data.
- select rows paste to another worksheet and return
- Convert to Text/Convert to Number
- Question on Importing Data From another Sheet
- A tricky date formula required
- clear excel cache -- or maybe something else?
- UserForm Question
- Formula question.
- Automatically Unprotect Workbook
- Insert row for new employee
- workbook formula
- functions!!
- user form question
- Copy and Paste data
- How to rank and not include zero values?
- excel VBA - search for cell values and place into array
- Massaging Data from a report
- How to define a constant variable?
- Obtaining birthday day from next month.
- Automatically return answer from formula
- Arranging data using VBA
- Dynamic Header In My Sheet.
- small vba code help needed
- Automatic Color change while typing a particular alphabet
- hide hyperlinks message box
- countif matchs text AND between two dates
- Excel menu shortcuts
- Conditional Formatting
- protect the cell in excel
- Replace Cell value if value in corresponding cell is...
- Cell shading failure in EXCEL [all versions]
- Weekends and count if
- Conditional Formatting
- Get forumal from protected worksheet.
- TIME PROBLEM: Averaging, Dividing...
- Leap Years Don't you just love them!
- Find closest number
- Linkedcell and Togglebuttons
- Macro shortcuts with multiple workbooks?
- split names
- duplicate values
- Complicated VLOOKUP question... I think
- loading data to listbox
- search function, from the right.
- true/false earlier date (week+year)
- Problem with COUNTIF
- testing times with macro
- Headers & Footers
- TRANSPOSE worksheet function: insert blank columns/rows?
- Macro debug; Selection.Insert Shift:=xlToRight
- Highlight row based on 2 conditions
- Page Numbering an Entire Workbook
- fill right
- Zero's
- Validation List / Combo Boxes issue
- Pivot Table Views
- Is it possible to add 'OR' into the 'IF' function?
- Excel Challenge 2
- Anyway to make a variable value NOT to be changed as long as it's assigned with a value for the first time?
- Displaying Unique Values
- Countif Function not working ?
- Rounding
- VBA & combo boxes
- Over-riding grouped cells protection
- Lookup with multiple criteria
- Improvements to coding method
- 68 condition if formula
- Count The Number O Rows ?
- Saving userform data with loop
- Sorting Lines Based on a textstring in line
- Rolling months
- Select Sheet Based On Cell Contents
- Get Computer ID
- Conditional Formatting - cursor postion
- Combination INDEX, MATCH and MIN (very difficult)
- Excel Database
- Auto fill problem
- Page Numbering to start from specific number
- changing colours on conditions
- Filter Tag Color
- Import data from an instrument for analysis in Excel
- CountIf
- can i make code delete itself?
- Cannot open hylerlinks from spreadsheet
- Matching specific data
- Profit/Loss worksheet for Stocks
- Check dates in VBA & format as necessary
- Vlookup, If?? Don't Know How To Tackle This Problem
- =sumproduct Q
- Probelm with replace the name of Sheet2 to label4.caption
- I Think This Would Be Count Rows
- How Do I Reference A Cell In Another Workbook?
- Insert Date
- Nesting IF's and VLOOKUP's
- VBA Loop through SOME worksheets
- Zoom in for Mac users but not those on a PC?
- Change formulas to values - tricky one?
- How to turn off updating of remote references
- Bar Chart + Quartile function + Horizontal Lines
- Conditional Formatting Formula
- pull out duplicates from list
- summing across workbooks
- Sheets code
- Pivot Table data
- Break a field based on last characters
- for each next problem
- Application defined error
- auto adjust of cell size when wrapping text
- Sum One Column if Other Column is Bold
- Comprehensive listing of ALL excel shortcut keys
- Date Format
- If Statment Help.
- Can I change the Default Size of Filter Box?
- Establish a percentile value in a database for a few different criteria.
- Wildcard help
- Color Index Name
- number advances upon opening worksheet?
- Multiple Userform - Position Top or Bottom
- Bell Curve
- Sum (or get a value) from Different Columns
- Matching corresponding values in two different sheets
- Ending a Process
- Can't "unhide" a column ~
- Paste code jump at five steps
- Change Worksheet name to certain cell.
- Pivot Tables
- Deleting rows- code help
- Export large excel spreadsheet to text file
- Specify "FROM" using SendMail Method
- show complete data of a formula
- Supress Subtotals in Pivot Table for Single Line of Data?
- Unique Results
- Calculate input value
- Very challenging macro question: how to not let users to touch the excel sheet while it's outputting data?
- Links to Other Excel Spreadsheets
- Help I'm stuck, insert/delete/shift rows/columns
- variable average?
- Making some text within a cell into subscript.
- Input date that value of cell reaches next million
- Trouble Distributing xls. file and xla. file
- Conditional Formating