View Full Version : Excel Questions
- Macro to refresh pivot by changing date
- sorting of data in excel
- compare & capture the respective details to other excel file
- VBA code to paste formula in range not working
- Macro for deleting the rows those having empty cells in either of the columns or both
- sorting of data in excel
- Event still triggers after setting EnableEvents to False
- Adding content to blank cells from duplicate entries
- Searching for exact phrase in Excel
- Worksheet Change Multiple Cells
- About separate numbers from a text by Excel Function
- OFFSET AND FIND function in one
- Need Help Creating a "MainMenu" on a Userform using API calls.
- Browse a file in excel vba
- countA formula
- Excel 2007: Form Control, can't "Move and Size with Cells"
- Retrieve synonyms from Wordweb Program and Paste in Excel
- File Properties of Web Documents
- Sumif using criteria and dates
- multiplecomboboxes False then ..
- How to get the button name:LineRowNumber, where RowNumber varies for different buttons.
- Countif cell is not equal to
- Creating one complete list from two partials
- IF Statement Help
- Select Page Break Areas/Range
- Repeat 320 rows and then increment in excel 2007
- How to embed images using ShowPicD
- Select Range by Condition in Cell
- Multiple Validation selections not allowing single selection
- Sum cells across multiple worksheets
- Conditional formatting on 4 cells in row
- Need a faster Code to delete Zeros
- Typically complex formula for me
- Macro Help
- VBA to capture data from User Form
- could someone take pitty on me
- Break Data Links
- No autolist members for Worksheet object
- Return values in sequence if TRUE
- fm MatchEntry numbers for combo boxes
- Count If
- Cells
- conditional formatting in excel 2010
- Selecting the bottom cell of a table
- excel slow when input number
- XL For Search Tool
- Fitting Power function and to record R-square
- SUMPRODUCT on 2590 cells - Very slow
- Skip code if condition is true?
- spreadsheet in userform questions
- validation list to sort rows
- Level cost
- Combing two excel files
- Insist on 3 decimal places given
- Help Shorten code
- listbox items not displayed
- Convert to Number
- Merging cells
- Comparing columns
- Create a floating text box or userform that will scroll up and down
- Insertion of picture by xls formula/ naming the picture with multiple selection criteria.
- Text filter from a range?!!?
- #ref! error when trying to access data.
- Create multiple records from data
- Match, Index, Lookup?
- VBA search for a character group
- Open website and open excel book vba
- Counting...
- single if statement to replace multi?
- Help - MATCH not equal to
- Array formulas
- File System Object Query
- Comparing two columns
- IF, THEN Formula?
- How to disable the numerous pop-up/warning boxes when saving as a .csv file?
- Pivot Table source data range (VBA)
- What Formula To Use?
- Cells selection
- Change comment in VBA module when workbook opens
- VB Confusion
- Conditional Format help
- I Need to Count a Date
- conditional sumproduct
- Apply condition to range
- Data Validation from lists - values + formats!
- Formula help needed
- VBA... Import data not working
- VBA - AutoFilter Multiples in different formats?
- Formulas referencing CodeName in a macro
- copying formula to other cells problem
- macro - find two items, insert row
- need help copy pasting rows across workbooks
- VBA & Tabbed Browsing
- VBA - Selecting multiple cells using ActiveCell.Offset?
- VBA coding problem
- Error with Array
- Im in a VB mess
- Cannot expand fields/too many fields defined
- summarize monthly dates with categories and totals
- Combine Sheet with headings in different order
- Select all visible sheets except 3, then copy and paste an image
- Fail / Pass question
- Location to paste, quick question
- Formula needed
- Retrieve Message Box content in excel cells using vba
- Delete rows in Excel worksheet VBA
- Can you create a name for a column?
- References Won't Stay Checked
- Why, why, why wont this IF function work?!
- Concatenate with quotations
- Passing variable string from WorkbookOpen to userform
- vba procedure to capture multiple cell values
- Form letter help
- VBA code to return row number of found value
- Text box keeps appearing
- Copy down formulae
- delete SINGLE point in chart
- Excel Tables problem
- Pivot Table - Calculated Field
- Tough vba lookup
- specify workbook in VBA
- Remove underlying data in Dates.
- Break apart cell by commas
- VBA - Define Range of Cells to Copy
- red flag
- Unprotect/ protect
- Sub-form lookup
- Does anybody know what idmxl8.xla is?
- Saving macros in a master file to copy and paste into new files or macros
- Excel 2007 Formula to match & align words
- Change colour with mousemove
- automatically delete rows
- Another Update Links Question
- Index, & Match formula
- How to add a total to end of ListView column
- Copy Paste and Skip
- What is the correct CodeName syntax?
- Last Column Calc
- Quicker Dupe Deleter VBA Help
- VBA to add total of ListView Column to end of ListView column
- Combination Sequencer Using Tables
- Import all active wrksheets from multiple wrkbooks
- Array with Lookup Function
- Add multiple sheets and name from a list
- copying values that change weekly into another sheet
- Filter is reading dates as text
- Countif based on range in other column
- VBA Chart problem
- Rookie Needs Advice on Bar of Pie Chart Question
- Advanced Lookup Array Formula
- VBA LOOP "IF And Then" Criteria not Working
- Replace Blanks in selected Range
- VBA SaveAs FileFormat 53???
- Compare Rows, group identical entries, and find lowest value
- Color for results from different sheets
- using the Average calculation with cells that contain 0 or no data at all
- Matching
- Conditional formatting w/ formula
- Looking for help on a count function
- formula for tariff
- scrollbar not working right
- How do I compare information on two different sheets with different data
- Control Other non-Microsoft application
- How to use Lookup Array vs V or H Lookup
- Message Box (on open) to choose (or not) to open a file
- Unable to add alphanumeric text..........
- Immediate Window
- Naming a tab by a cell value
- Most compact/efficient VBA to do this?
- Add Leading Zero's To Alphanumeric Field
- Listing results from multiple worksheets
- Why isn't this SumIF formula working
- Instructing a cell when to add/substract with a word
- Text Search
- Empty Cells
- List
- Simplify Condition Code
- Default Color when adding Data Labels
- Copy UserForm
- If statement
- Sort numbers to fill a value
- TODAY() function - get a date value in a formula NOT DATE FORMATTED
- Looping to Format Cells
- Sumproduct (with vlookup)
- Formula that looks only at dates which fall during the current calendar year (relatively speaking)
- Learning VBA
- Two Value formulas in one cell?
- Visible Property of the PivotItem Class
- 2007 xlsm file in Office 2011
- Paste Image into Protected Sheet
- Auto populate staff #'s
- VBA Procedure
- vba for Highlight duplicate value in different array or range
- Finding value from a row that meets conditions from 2 columns
- find/replace macro
- exporting row as different file format
- Pivot table
- Auto naming a range based on cell content
- Suggestion to improve this work schedule
- New to VBA - Show/Hide rows based on target cell
- Cell content into VBA code
- VBA: REDIM Function?
- VBA Code help needed
- VBA-Conditional formatting
- Find # Number Farthest From 0 Positive or Negative
- separate string on basis of where "space" exists
- Merging VBA
- At witts end
- VBA to skip lines
- Range formula to find values between dates
- Problem with IF condition
- Extract Text
- Extract columns from tables onto different sheet
- Replace sum by average
- File name gets updated ever week
- Search Multiple Pages
- dynamic range for dividing by reference
- vlookup for row below
- Delete cell based on dropdown
- Macro to find a cell with a specific word (when its mixed in with a sentence)
- Calling powerpoint module from excel macro
- Find text characters in cell and add to end
- Look Up Help
- Conditional Formating
- Array Problem When Dimension Not Known
- forgot workbook password
- Retrieving comments and keeping formats
- need help on sales commision
- Formula - SUMIF - Can any help?
- Conditional or If Statement
- create a macro/button that will go to today's date cell
- Null values issues. Alternative for my Max(if) array?
- Formula Question
- Populate every single slide with every nth cell
- finding consecutive cells
- Is there a formula that...
- Sub Procedure and Dim
- 'For .. Next' Problem
- Dynamic Folder directory
- Open Word , Excel & Powerpoint files import only
- Need help Importing Data using web query to specific Columns
- Request for creating an attendance time sheet
- Personal add ins
- Excel Marco - Series Line colouring
- Reposition a Worksheet
- Hyperlink proble
- Sumproduct array results parsed to vlookup
- ***Clear cells only data not the formatting
- Searching words in sentences
- Count Unique Values but have data so it can be used in pivots/lookups
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.