- Filter out amounts that equal zero.
- Maxif??
- Macro to copy/paste value to new worksheet if condition is met
- help with sumproduct formula
- Protect drop down cell
- Calculating Average from list box selection
- VBA Code - Something not quite right...
- Reduce File Size
- Best way to run multiple modules?
- Higher level macro problem
- Error handling for absent files...
- average over a date range / vlookup
- Smart Transposer Needed
- Volume Pricing Lookup using Array
- Creating a drop down menu
- Dynamic Date Formula - Mondays
- TextToColumns Method
- Conditional Formatting Aggravation - 2007
- Counting the number of agreements in one column
- Creating new copied rows and parsing data
- VBA code to update formula to use dynamic range?
- Add to formula to stop errors showing
- Macros to open a file and paste data to another file
- Complicated if formula
- Loop within a loop issue
- Selection.Replace problem
- Linked Cells
- Ranking automation
- Swap?
- Comparing Column 1 Data to Column 2&3 Data that may contain Column 1 Data
- Help with iteration macro
- Un-hide a sheet via macro based on an input
- Is this impossible in excel? Link to other sheet based on value of cell.
- Spreadsheet Formula producing #####
- Sparkline
- IF formula not increasing
- macro to exact a range of cell value from multiple sheets
- VBA - IsEmpty Alternative
- Can't remove missing reference using VBA
- General Excel Question in regards to dual monitors
- Help with macro please
- Copying automatically updated values to new row
- VLOOKUP + Specific values in Table Array
- Combined Sheets/Update
- Help with macro to delete rows
- Appending data to Cell
- Columnar data to rows
- Purpose of TypeName in this basic sub routine
- Copy a range of data in each worksheet and paste it on a new sheet.
- Pivot-Table DATE-FILTER Dialog Box
- Concatenation problem...#N/A
- Form filling and auto completing
- I need a formula
- Rank Problem...
- List Horizontally
- Oledb
- Lookup complex formula
- MsgBox user response
- INDIRECT alternatives for closed files
- variable speed clock
- Formula help
- Combining "Or" & "And" in VBA
- Determine whether a text string exists in array or not
- How do I do a vlookup, match, and OR statement?
- Cells adding extra period
- Can I use an Array as a Range??
- Add a scroll bar on both (hoz + ver)
- I'm confused about NETWORKDAYS.
- Pulling particular value from cell
- VBA to Lookup last 3 results and display in UserForm
- Sum a row of numbers if Date matches
- Conditional Sum Formula
- Sending an email from Excel using Outlook
- Listbox code only working for first record selected...
- Message Box Based on Columns
- If Statement?????
- How to select a non-contiguous group of cells from multiple columns within a row that is defined by a variable
- additional condition to small
- Can't for the life of me work it out!!!!
- Multiple column count
- SaveAs Command saving current workbook
- How to Auto Full Relative Range in VBA
- Option Button Help
- Price list calling from drop down selection?
- hyperlink to a variable location on same sheet
- Save File to SharePoint Site
- Organize data from one column of dates
- Pasting cells into the first blank row on a different worksheet
- Overflow - Can't Figure out
- Sumproduct with Mod Column help needed
- Get the next matching value in "index(,match("
- show each values that add up inside SUMIFS(
- Run-Time error '1004': Application-Defined or object-defined error
- Hide Properties Via VBA
- Turn a number into a graphic
- trouble with MOD
- indirect to other workbook
- Consecutive numbering/referencing
- Put Cell Values into Array then dump Array into new Column
- Returning Values from Columns Adjacent to Most Recent Date
- Averaging if using colors or contains condition
- filter on criteria then copy and append worksheet
- Indirect with Vlookup function
- Pivot Table Copying
- chnage combobox rowsource as result of
- Best Error Handling Practices / Add-Ins
- Retain Column Header Information
- Dropdown list in sheet 2
- Excel2007 displays strange rows above standard column headings
- delete a pivot table (but not the data or format)
- Help with excel files
- VBA for figuring out which sheets are selected when multiple sheets are selected
- Opening Closed Files and Reading to Array
- Merge tables without sorting rows?
- Need help with bankers rounding on a calculated cell
- Date - Number vs. Text
- Email Won't Attach File Unless File saved
- Combined Sheets
- Working with COUNTIF formulas.
- Error Handling for Data Import
- ActiveX Checkbox 'Linked Cell' properties
- Comparing 3 values
- Workbooks.Open Text Issue in Excel 2010 VBA
- Sorting where Rows have merged cells
- Filter data then Copy to range("A1")
- Extracting cell value by cell color
- Unique combo 2 columns, max for combo from 3rd
- counting populated rows and columns
- Vba project
- ListBox ListFillRange
- Sorting columns and rows
- Sum values of column in listbox
- Sumproduct with n/a
- Another Countif question
- Adjust Row Height Based on Number of Characters in a Cell
- Help inputing dates
- Find and match multiple value
- Finding a String within a cell
- Hours to days
- Event generated with a mouse-click
- Formatting Cell Values
- Extra Apostrophes
- find listbox selection in a range
- Troublesome worksheet
- multiple if with between range
- Random numbers in range
- sum formula
- Better way to copy LARGE range to clipboard?
- Using Average in Pivot table 2007
- Returning column header based on cell color
- Duplicates in random numbers + msgbox
- Drop down box to control charts and other data outputs on output sheet?
- Disable specific dates in Calendar Control
- Result Card problem
- How do I use the Option Explicit statement
- Copy protected sheet to another book?
- Filter
- I have 3 columns with 6 rows and need to get at least 100 possible combination
- File Path Question??
- List box populates with two combobox.
- SUMIF using a range in criteria
- Cell Information...
- Excel Help
- formula problem
- selecting data using ctrl+shift+down for recording macro
- sum certain values based on certain values to the left
- Number of minutes lost?
- ISTEXT result on a range
- adding external data in pivot table
- Top Ten Values offset formula
- Macro Button
- selection box with hint
- auto populating column query
- Run macro based on shape name
- Error in macro
- Problem with selection autofilter
- Excel Macro Before Close Event
- Conditional Formatting For Week of Month
- Exams - percentage
- macro to copy a variable number of cells
- Printing only visible groups
- Array formula edit
- Long hyperlink
- IF statement with OR inside the statement
- Find which column has the highest value?
- stoping Colum Q being over typed
- only Counta Range whith a another ranges match
- Loop through folder and run macro on all workbooks
- Sum/Lookup??
- help me guys its macro's thing
- Macro to check a cell
- sendkeys, or controlling 3rd party software
- Selecting sections of data from cell
- how can I count the amount of cells with a letter in it, whilst only counting ones from a title on the left column
- Arrays
- IF formula including AND, and OR statements
- Count values between dates
- Managing large datasets with a form
- save excel attachments sent by email
- Formulae.....
- calling macro in another workbook
- how to write must not equal in code
- Combo Box Help
- search an array, return an adjacent value
- date to date
- Macro to copy values from Sheet1 to Sheet3, based on criteria in Sheet2
- Looping
- Multi values in a column using check boxes
- Help! simple mistake in code but i cant fix it!
- Sending Debug Errors to Email Address
- Run macro automatically
- Disabling steps in a routine
- how to pull data one workbook to another workbook
- Matching text
- Tricky One Need a hand with (novice)
- Public Variables
- Help with reports
- Quick & Easy IF or LOOKUp
- need help
- More Code Needed for macro please
- Convert
- Need help on formula urgently - exclude 2 items in summing
- Comparing Two Columns of Data and Returning Corresponding Cells from a Third Column
- Macro to do Calculations on a dynamic Range
- Help with saving updated values
- linking ws command button to userform command button
- Error in loading DLL. How to stop this error:
- Automation error...Run-time error - 2147221080 (800401a8)
- Conditional Formatting
- Convert decimal seconds & minutes to time format
- A formula for "select statement"?
- loop skips values
- VBA:copy rows based on criteria to a new sheet/file.
- VBA code that works for RTD style Stock Market Feeds
- #div/0!
- Long If statements?
- Consolidation Macro runs too slow
- step by step on how to count duplicate names
- UDFs returning #N/A during code execution
- VLOOKUP just goes completely wrong
- Excel 2007 Remove all Custom Styles
- Userform background image
- VBA Macro to copy and paste row maintaining relative formulas.
- Need excel expert
- Importing data using Microsoft Query
- attach addin macro to shape
- Unique Values Available Currently
- How to display worksheets with a checkbox
- unprotect a workbook
- Hiding/Modifying Excel Menus