View Full Version : Excel Questions
- txt to xls
- IF Function Formula Help
- How to count this?
- VBA - Keycode with numeric pad
- "New line" in footer with pagesetupfooter
- compare the number of rows
- EnableCancelKey xlErrorHandler - error when refreshing pivot table
- How do I protect everything on a sheet but can use the drop down box
- Range definition
- If Saturday, Sunday or Monday, give me Fridays date
- Macro to extract info into new worksheet
- help me on pairing
- How to Protect an Excel Chart.
- How Can I select the row below a header with a macro?
- Date help in Excel poss IF Formula
- Extract numeric part and sum
- Making multiple targets for a change event
- flotting progressbar...
- Sumif rows below
- Help Needed!!!
- if do nothing statement
- Count
- Can anyone please explain why my formulas sometimes don't work
- A simple Macro to compare range of columns...Help
- Workbook_Open not working
- macro help ( very simple )
- Comparing 2 Columns
- Open workbooks with certain sheet
- Custom AutoFilter NOT working with Number Formatted cells
- Get data from other files
- Is there a way to 'fill' hyperlinks?
- VB Code
- Calculating loss or profit from multiple trade signals
- Hide rows according to cell value
- SUMIF help!
- Regarding Shape Integration
- Exporting worksheets to new xls files
- VBA : Select end of data range
- Format Protection
- Is there a way to copy and paste FORMULAS into MS Word?
- Moving entire row to new sheet when date is entered
- Remove Apostrophe
- simple question about negative numbers
- run a macro when cell value changes
- multi range vlookups
- Time formatting question
- CSV Conversion
- vlookup-table array using <>=
- VBA - ComboBox in user form
- OFFSET function with pivot table
- Should I use an IF statement for this?
- Using InputBox for password: mask actual input
- Search subfolders only
- Code worked 10 minutes ago, but not now!
- Double-clicking protected cell deletes contents
- Determine if Column Contains Value > 0
- Is Reuters installed/
- Formula in Excel macro
- Data Conversion
- Copying from 1 workbook to another
- Nesting Networkdays with an IF Statement
- Vba Check all Columns
- Partial formatting of formula output
- VBA to replace existing report
- User to follow the path directed
- OR(AND(Conditional Formatting Challenge
- Date problem
- Active Cell
- Select and copy specific sheets into a new workbook
- adding totals by matching data
- Formulas not calculating
- munipulate cell data
- Calculate Age before 1900
- Selecting a date Range from form
- Help opening a file
- changes in existing code to fill down the fomula for multiple cells
- Copy formula
- Conditional Format IF Statement
- Combo Box & Conditional Formatting
- ComboBox autoselect
- Nested Loops
- Linking Monthly IRR returns
- Swap data from last non blank row?
- Help with a formula please.....
- Pivot Tables and Blank Rows Question
- SUMPRODUCT match first three characters only.
- Checking for specific text and adding additional text to cells
- Active Cell
- Hopefully simple
- Currency Rates in Spreadsheet
- How to omit missing data on a pie chart?
- sort duplicates
- Variance with IF
- Problem with SUMPRODUCT linked to cells in another workbook
- Manipulation cell colours
- Calculating differences in dates (macro)
- COUNTIF with several criteria
- Search Column by date. Cut Copy and Past to New sheet
- Help! Tried to insert a hyperlink and now my two worksheets say [Group] in the top bar!
- Date formula based on column
- SUMPRODUCT using time evaluations
- VBA Code
- Row Address data to columns
- If or Match function over a range of cells??
- Selectively Selecting Data From Within A Cell
- Can Data-Subtotal Functions be customized?
- nested if statements
- How to Show a Demonstration for Project?
- remove the spaces
- Format cells to display decimals in cell value. HELP
- Type mismatch
- Changing Sheets & Personal.xls
- SUM IF Formula
- Automatic Screen Capture Problem: Hashed Bar Offset
- Summing a cell on multiple worksheets
- Conditional Text in If Statement, how to make work
- Clear TextBox Contents with Worksheet_Change Event
- abort Password for input box
- Less then greater than
- Calendar Problem
- A tricky one!
- Countif Question
- Menu Bar and then emailing/transferring it
- SUMIF formula with Sum_Range based on column index number
- Formula Doubt
- Hide rows, columns, sort while printing only
- Has anyone seen this in an Array formula
- Changing a continuous srt or rows to cloumns Excel 2007
- which kind formula to apply
- How do I sort subtotaled groups
- Pivot Table Group Dates by non-calendar fiscal
- UserForms and automatic totaling
- xfer info from 1 sheet to another question
- If error
- Cut/Paste Special - Transpose
- Copy range in one book and paste in first empty cell in another range
- 2007 Pivot Table, format problems in 2003
- Macro - Clear memory
- IF formula limit (nesting)
- Formula Help
- Dynamic internal hyperlinks possible?
- Text to Date or alternative text Logic
- Add-in - How To Use Code In The Add-in
- Hyperlink Result for Formula
- Updating Web Query
- Bacteria Colony
- Multicolumn ListBox?
- count rows with cell value, store result and delete rows macro?
- Extracting blank entries in a pivot table
- Can this be made faster?
- Really Annoying Error!! Help!
- Macro that email excel file
- VBA formula help
- Counting Formula
- formula help
- if statement/lookup question
- Excel 2003-2007 compatibility problems in VB
- Procedure for a collection of workbooks?
- Question about subtotals, what approach should I use?
- Combining multiple rows
- Simple Fantasy Football Auction Tool
- Top 5 Values...Return Offset....Duplicate values causing issues.
- Start Power point from excel
- Delete Rows with Eight or Greater in Column I
- Is it possible to make a Macro code that will...
- Macro to copy row data from one worksheet to another based on the presence of a value in the column
- drawing a line with VBA
- Vlookup formula fill to last used row
- Link question
- Cell Highlighting
- Extract data from multiple workbooks
- Open .DBF file
- Run-time error '1004' Select method of Range class failed
- Refine a search
- time format headache!
- Reverse Byte Order
- Macros to insert a disclaimer
- Corresponding numbers in a list box
- Calc Time Intervals
- Pivot Table Format - Borders
- Need to alter an Auto_open macro
- please help - sum% if it falls in date range
- Using Form Data in Module
- Can someone break this Vlookup down
- Something wrong with macro, please help
- Convert row to column?
- interest formula
- Hard!!!! Data Check
- Creating a dropdown box with options to run a macro
- Event handler...
- VBA - open workbook
- Macro Button that filters to current date
- Dependent Lists & Auto Report
- Second Window inconveniences
- Excel Dashboard with parametrized Red/Yellow/Green indicators
- Range object and Value Property
- Timesheet for Independent Contractor
- Using INDEX, MATCH and SMALL for a ROTA?
- Sumif question
- Formula problem
- Custom Format AS-F-GO
- Macro to delete blank rows in CSV files
- Continuous column but needs columns and rows
- how to sum values in a date range
- Call vba function from flash embedded in excel
- Lookup formula not showing last number in column
- macro calculate only if complete data
- WTF... application.filesearch finds nothing!
- VLook-Up Question
- Simple Equal Question
- Floating Table in Excel 2003 worksheet
- Multiple menu items under one heading Excel 2003
- Rank function and percentage ties
- Excel Rookie needs help
- simple INDEX question (in VBA)
- Change cell background on basis of vlookup returned value 5 colours
- Dumb Dumb Dumb
- Lookup and Return a Row
- Faster Method of Deleting Rows
- =ROUNDUP Formula Help
- Combo box - UserForm Issue
- Pivot table issue
- simple FORMULA question (in VBA)
- pivot table refresh problems
- Get the Column Name
- Syntax writing conventions
- Extract Numbers from a Range
- ListBox - Dynamic Criteria for Advanced Filter
- Excel to open outlook folder
- seperating words to different cells
- Check if menu item exists
- A lotto related question...
- Select Case Query
- Caluclate Days
- Pull out all search instances and split code
- User defined Function error
- FN key is on
- vba average three columns with missing data
- Formatting fractions in VB
- Macro to only show rows that contain specific text/Chinese text issue in visual basic (Excel 2007)
- Need a formula
- Add space and get average
- customised graph appearance
- chosing filename in dialogbox + press ok with using vba...
- Combining sub-field categories in Pivots?
- Paste blanks??
- Find Text Using VBA - Help Please
- find & copy data from different sheets
- Copy/paste button problem
- Help on SUM function
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.