View Full Version : Excel Questions
- Sum Row, reducing column each row.
- Ampersand as a logical operator in Excel?
- count items in a column
- Emailing to groups via Excel
- How to amend chart data in multiple workbooks
- updating a master sheet based on adding a new sheet?
- Present Value and negative answer
- Present Value and negative answer
- Present Value and negative answer
- How to create a unique list with a macro
- How to create a unique list with a macro
- Day of week
- Making an If Then test go further
- copying cells from a worksheet into an autofiltered sheet
- nested if statement to group numbers
- Calendar
- Multiple nested if?
- Change Data Layout For Better Reporting
- Pivot Table Field Options - need an expert!
- VBA formula problem
- Excel 2000: allow users to edit ranges
- Change Data Layout For Better Reporting
- Pivot Chart in Excel 2007
- How to Make the data from the pivot table ( Reverse Pivot )
- Help with VB script for XML import
- Help with GetOpenFileName
- Scroll bar in excel
- Understanding Formula Performance Speed
- Formulas not updating to Show Results - Automatic Calc is on
- IF and AND question.
- move highlighted rows
- Delete all rows Except .. help please
- Selecting a Range using Offset
- Commission Calculator
- IsEmpty line of code is giving me a mismatch type error
- random numbers with differnet distributions
- Sum if hours are less then 40
- Subtotaling Columns
- List of items in a column
- Unprotecting after save as
- Phone Numbers
- Question regarding cell references
- copy specific range of column from workbook file w/chg name
- Correlation of a subset of two arrays based on criteria
- Drop Down List Length
- Worksheet activation msgbox
- Form won't allow combobox list with only one item
- Type Conversion Errors in VBA code
- Using offset to put a formula in a range
- Need to count alpha characters in a string
- More unusual userform behaviour
- DTPicker default value
- How to sort/filter cells which are coloured
- Shared Workbook opening problem
- count unique number
- Data Validation
- SHeet name to appear in the cell
- Overflow ERROR
- VBA case help
- a little help with a macro for a big job... please
- merge but not show the duplicates.
- user interface to select file - help please
- Column Chart Won't Plot
- VLOOKUP help - numbers in column are in a range
- Formula comparing cells etc
- User Forms
- Closing a Workbook Without Naming it
- Code Needed
- Multiple Column Query
- Multiple Column Query
- Finding a name within a string
- Limit default screen view
- Row Count Wrong
- making a loan schedule
- Need Help Using "And" with COUNTIF Stmt
- Cell color change and days left
- Mining text cells for dates
- Help!
- Moving rows with a condition towards bottom of sheet
- List one cells value in a range
- Hyperlinks - Help!!!
- Help with Active cell
- Creating an Expenses sheet
- random number function
- If then Formula Help Please
- Rows/Columns question
- SetFocus doesn't work inside a Select Case argument?
- alphabetizing data validation sets?
- Changing axes intersection in a scatter plot
- Highlighting rows after an autofilter
- User Form to Hide Columns
- save as xl97
- COPY 1 SHT AND PASTE TO ALL IN WORBOOK.
- Tricky vLookup
- Checking Multiple Criteria
- How to use VB script for sorting columns
- Arc or CircularArrow
- Array problem VBA
- Sort by Color
- Still having problems with checkbox code
- Search for multiple names in various worksheets
- Search/filter data in Excel dropdown with large no of values
- How to select a menu in the Task Pane using vba
- Excel DDE Commands?
- VB Save as
- Mysterious Disappearance of a UserForm
- Drop Down List
- Moving or copying files
- Creating a search option
- Linking to another worksheet via drop down box
- Solving for w using Goal Seek???
- Dialing a phone number using excel
- If match then put a 1 next to it (?)
- Is it COUNTIF, SUMPRODUCT, both, or what else?
- run macro on selected sheets
- stopping outlook confirmations when using mailenvelope metho
- VBA: Loop question
- Changing a date to month name via VBA
- How do you alternate row color when text changes?
- save as(current file name,cell"a1")to current loca
- choose help
- Copy and Paste from different workbooks issue
- Macro to Find cells with perticulat Format in a worksheet
- converting a csv to xls
- VBA: Row/Column formatting
- row to columns
- Cut / copy / moving worksheets
- creating random letters that dont repeat in rows or columns
- Lookup formula help
- Find All Option
- Autoshape Formulas
- Autofilter Using Content of Another Cell as 'Citeria'
- A few queries about renaming worksheets
- Set print area with macro?
- Percentage formula
- Selecting chart without entering its name
- can't open file-not recognized as Excel format
- Generating worksheet that omits rows with zero values
- HLOOKUP on Two Ranges
- Ordering the cell based on values
- PivotTables: Row header field: managing long lists
- Combobox dropdown part disappearing when open
- VBA: Can I disable macros in a workbook when it's opened?
- Error capture in Excel VBA
- Sort Problem
- SUMPRODUCT with a Twist
- Vlookup Auto update
- changing dates that are text
- Formatting Data
- Excel Database To Outlook Contacts
- Excel Database To Outlook Contacts
- Count Ig Function
- create Addin for highlighting current cell (or range)
- VBA: Anyway to clear the clipboard?
- Recording certain values in Excel
- How to add options within the list box..I need help please
- How to add options within the list box..I need help please
- Remove frame from Userform1
- Macro to find value
- pasting very slow...need help to make it faster
- A Small Question
- Pull Validation Data from Another Sheet
- Count if query
- Merging Multiple Spreadsheets into 1 Sheet
- Table in excel that needs splitting out into 18 separate
- how to hide a row automatically if criteria is met
- Trying to count how many values are within a group + Excel
- Creating Error Message Displays On Click
- Saving excel files
- Comparing Two Ranges
- If formula to show all data before certain point in a cell
- Conditional minimum
- Another random results query ....
- Slow Macros
- How to stop macros running if not in certain columns
- filtering or hiding
- Clearing Data, Excluding Text & Formulas
- Help with Excel VBA, Automation Error
- exctracting Hyperlinks
- List text IF meeting date range
- Limited Access to Macros
- merge of 2 formulas
- Creating a macro that produces a report
- Macro to delete rows, takes header too. .. help pls
- formula to show cellvalue of every seventh row
- Automate comment entry
- Can't collapse Pivot table
- Macro for Inserting a blank row within a table?
- Shared Workbook
- Concatenating 4 cols and prepending with info on large scale
- INCREMENT VLOOKUP
- IF statement
- Key Stroke to go to next Worksheet
- Copying a formula down cells automatically?
- Auto Detect /Delete Duplicates As You Type?
- SUM Macro
- Vlookup to look at mulitple cells
- date question
- Identifying Duplicate Values
- Linking Sheets
- Create a hyperlink to a section of a page based on a cell
- No more new fonts may be applied in this workbook?
- Variable in SQL
- Changing Multiple Headers at One Time?
- Help with auto save! plz
- How to add a certain amount of rows to row of formulas.
- Search Entire Worksheet for Value?
- Board Macros not working for me
- Why wont code run when the VBE is protected?
- Move Data from one workbook to another calculate then back
- why wont macro run when VBA is protected, whats wrong please
- Graphing with multiple axes
- Enter moves to the next row.
- Deleting Columns based on multiple conditions
- EXTRACT Text: extract text
- Move Data Between Workbooks
- AUTO FILL
- smal(range multidimensional, 1......) without duplicates
- Formula Help
- Searching for Text
- # of times a value repeats in a column, and if >8, flag i
- Copying rows from Sheet1 to Sheet2 ...
- controltiptext and multipages
- Pivot Selections: Page Vs. Row
- need help in concatenate
- Video display or linking option
- examples of startup pages
- =COUNT(SEARCH("INTEREST",$C792))
- Document not saved
- Create a list of number with VB
- Lookup a value in excel
- VB Script Loop w/limit
- Extracting value from a link box
- Export Find All results
- Help with a count formula
- Update 2-Axis Chart w/o Losing Formatting - Pivot Tables
- Taking text from cells in list into another worksheet
- CopyFromRecordset error
- Template Wizard
- copy to each sheet in workbook.
- FORMULA TO EXTRACT PART OF A CELL???
- Convert text to date
- 2 questions: 1) Web Query 2) macro to sign in
- Interracting with Lotus Notes NSF db's with VBA
- Need to return a value based on several criteria
- If formula problem..
- Excel and Powerpoint Screen blanks when copying or scrolling
- sorting noncontiguous rows
- Getting values from a table with multiple variables
- duplicate entries
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.