- Macro Cell Propagation
- pick a non blank cell and use it in a formula
- Validation erm, Validating?
- How to do a select copy from one sheet to another AND REPLACE the current information on Master Spread sheet
- Display all the time zone automatically
- Sumif only if value is positive and of background color is white
- Show list based on particular Cell criteria
- On error goto label problem
- Formula to link two tables using interval search
- How to Check a datetime is in GMT or BST
- Populate textbox via combobox code
- question on paste special
- Excel and VBA help needed regarding text
- how can i make my workbook to have a username and password to open?
- Simple Find
- Solver - variables wont change as integers only?
- charts - conditional colours for columns
- Frequency, CountIf or Sumproduct for this...
- Excel VB Macro: Use of Variable in place of "What" in Find Method
- which number of week is this?
- Dependency of the separated sheet on mother file.
- Hide/Show pivot table item in MS Excel 2007 with VBA
- Carry across a value from one userform to another
- Quick Response Needed
- Protection
- IF Statements
- Combobox to list spreadsheet entries
- Macro to copy rows based on cell colour
- Index, Match, Mid, cell Problem linking each sheet to a master sheet
- data list
- IF Statements How can I shorten this formula
- INDEX and VLOOKUP combined?
- Vlookup to external workbook
- Rolling Report Help
- not able to identify the interior color!!
- Could somebody please show how to add total time
- How to save file from FollowHyperlink to a local folder?
- Compare range values in VBA
- Desperate! Macro to do something simple?
- Counting in a variable range using INDEX and MATCH
- stopwatch - pause button
- Showing the content of an Excel sheet while running VB app
- Macro Formula - Referencing by Declarations?!?!
- Modal value - two columns of data
- Post to cell and textbox at same time
- Dynamic Chart
- How can I get rid of these #N/A
- VBA Form remembering input
- Clear identical ranges over numerous worksheets
- need help with this code--update links
- VBA emails?
- MACRO TIME! ...yey:(
- Calculating multiple cells
- IF statment to display a userform
- delink chart
- Counting days contacted minus weekends
- find max in array
- Slow performance with clicking page preview/page break
- Range vlookup
- This should work, but doesn't!
- Passing Variables
- Export cell data from excel to word
- selecting a range in a macro
- Altering the enter direction in Excel 07
- Splitting a number by percentages over columns
- Advanced Index Match and Rows Problems... All Have Failed Who have tried this. Can you Please Help.
- Textbox to Listbox update
- Extracting data from ELS view of outlook to excel
- Need Macro to Sort Many Columns in 2007
- Create a Questionnaire in Excel
- Window scroll not working
- xml file question when saving as webpage
- Reference row 3 in any current column.
- Converting Quicken files to Excel
- Reference row 3 in any current column.
- Need formula to find lowest unique number in series
- Issue using Excel 03 & Access 03 together
- Adding numbers that have letters at the end
- Merging data from two different workbook
- Evaluate formula in VBA, then Paste Special
- Print Preview Different from Save As PDF
- Current FTSE 100 Stock Prices Via Excel
- Hiding and Unhiding Rows Automatically
- VBA If statement
- #Div/0 Sub Remove_Formula_Errors()
- That crazy IT dept. . .
- Tab order
- Calculation Dependent on Dates
- Picking a random name in excel
- Need Formula to find the lowest unique number in range
- Opening file from My computer
- Range to Array
- Cannot view excel attachments that are linked to other forms of data
- User defined range for Macro to run simple copy and paste
- UserForm Question, How to run code on TextBox "Enter"
- Format % - label on userform
- Case Statement Usage
- Formula Help..
- Questions about the inner workings and specifics of VBA
- Table filter
- Basic saving worksheet code
- Books to learn Excel and VBA - 2003 or 7
- Copy Rows/Cells IF criteria met
- Question Graphs plotting axis
- absolute stumper
- Name Manager export/import from/to Excel
- Make multiple images visible
- I need help desperately
- Changing an item in the validaiton list using VBA
- Mid and match question
- Pivot Table Calculated fields
- sentence breaker
- Table filter
- Help Understanding Sumproduct . .
- VBA adding variable (filename) to a vlookup
- Validation
- combine 3 formulas
- Connection Points
- no cells were found
- 2007 Pivot table - data formatting
- Pics on VLOOKUP?
- Get Data from IE Web Page in VBA Module
- Lookup Table to BIG?
- Interactive Chart Using Mouse Move Event
- Creating a Formula Using Subtotals
- VBA and Range problems
- Update userform
- Command Button Performs Multiple Functions
- Inventory on hand calculations
- VBA to exclude One Sheet from printing
- Syncing certain information from different Tabs
- VBA for Index/Match
- Closing an APPLICATION and skip saving
- Macro to paste using autofill
- Column deletation
- populate list box by matching certain values
- Stepping Backwards through a range VBA
- VBA - How to Save and Close without prompt
- Count.If cells containing year 2009
- Worksheet Find Function in VBA
- Matching Duplicates then searching for a specific value
- Formula to search
- last days of the month to fill in series
- Insert rows same as number of cells
- clear an array
- Period between consecutive events
- What is the code to search for text in VBA?
- Simple--Using Time in a Combo Box
- Formula Error Question
- Lookup Dates
- Consolidated Pivot Table
- Getting a cell to display a zero if same cell is #VALUE!
- cell showing ascending order for other row
- Adds "=" to dates & converts date to 1900's
- Conditional formatting based on meeting multiple criteria
- Any suggestions to make this calculation more compact? (Gross Pre-tax Income derived from Net Income after tax)
- Simple Convert Question
- Bill Of Materials
- V-Look up in a user form
- Multiple combo boxes with varying listcounts. Run thru all combinations?
- Error with perfectly good code
- VLOOKUP with Range of Dates
- Text Boxes - Can VBA code copy my text form a cell and bold, etc.
- Merging Multiple excel sheets into one
- Macros for Extracting Data from Multiple Worksheets for a Mastersheet
- Input box - collective format
- using .Column after an .Offset - need the letter but getter a number
- Check-the-value Macro
- Loop Problem
- Macro to Format Header Footer
- Can we use CONCATENATE to combine two formulas
- SQL JOIN question (Excel or Access) - Only return first JOIN instance
- Loop Problem
- Usage log best way.
- Problems with advanced average formula
- 2 periods of data with similiar/dissimiliar labels
- Question about deleting rows given a criteria
- EASY: VBA to center text and set font color
- Please fix my macro code
- Conditional Formatting - Icon Sets
- DISABLE cut function
- #N/A Returned by vlookup when look up value is a date
- looping through "sister" columns?
- vlookup problem
- Countif but not on hidden columns
- vlookup getting wrong number
- Limit access to worksheets
- Should I keep using Excel for this?
- Excel date on tab (Visual basic)
- Allowing a user to manipulate Excel from behind a user form
- if and vlookup with isna
- Split text in cells
- Input acceptance
- Formatting and Subtracting Time
- Mouse shortcuts
- need help badly... and fast
- school trying to use Excel to chart testing/data could use your help...
- Convert to uppercase when a cell is modified
- Solver Macro vba range
- Cannot right-click excel buttons
- Copy only rows with values
- Playing a WAV file using VBA
- dynamic determination of highest value in a range
- Deselecting Selected Items
- Post Userform data to Cell Comments
- VBA IF statement question
- Date if/then function help
- Arrays and =OFFSET ... is this possible?
- Consolidate multiple columns data in single column.
- Macro to Filter on a Date
- Turn blank cells to 0 and value cells to 1?
- Auto Updating Multiple Sheets
- Data Entry Order Spreadsheet
- VBA Code: Inserting speaker notes from excel
- Want to return value from 2nd column based on match in 1 field with first column
- Graph based on pivot table PER month w/unique values
- Trend w/ High Possible & Low Possible
- How to convert 'date/hour' format in integer
- Which functions to combine/insert html + data?
- insert ado recordset into table
- wildcards in IF statements
- creating drop down list
- Elapsed Duration Based on 4 Cells
- bring in values from another spreadsheet
- Ranking formula looks right but not returning unique ranks
- Numeric Keypad
- rows to columns help
- Search workbook macro
- Is it possible to set the font size within an IF function?
- Problem with code :(
- Copy from Subtotals
- Organising exsiting excel database and Mail Merge Outlook
- Index and Match Multiple names? Does this exist?
- Lookup cell value and paste
- How to find the lowest date?
- copy and paste
- IF statment to run a SQL
- Select item in listbox based on cell names
- Can 'with' be used for more than one worksheet?
- Summary from different workbook
- Change the font on the row and columns headings
- Finding the previous month in VBA
- Macro for workbook consolidaton
- Help with simple Forms checkbox?
- VBA sum a range
- Nested IF for Hiding rows
- Delete characters from cell if text
- Check if AutoFilter is applied or not (for single column)
- V-lookup
- Question - Graph - Plotting Axis