View Full Version : Excel Questions
- Working out the Previous Month
- SUMIF
- Adding extra parameter to COUNTIF function
- Importing Lotus Spreadsheet
- "hardcopy" cell values, is this possible?
- Formatting a Date in Excel using VB
- Calculating sum from a specified criteria
- Multiple font sizes in a cell?
- conceptual challenge - find the avg? first date
- Speeding up a Formula
- IF Statements
- Inserting formula or linking text box with a cell
- Copy tabs and paste into a new tab macro error
- Entering data without forms?
- need help with lookup and summing.... :(
- Deselecting a range
- copy and paste hard values
- Can't call procedure from This Workbook
- 3D Vlookup
- Drop down box help
- This is a challange
- Excel Password Recovery
- Help with 1 more formula, please
- a vb range question
- quick question
- alter various letters to one of a combinination of sentence
- get the last day of the month
- Finding data in a book
- How to set deafult in Pivot Table
- two questions (1 area chart ?, 1 footer ?)
- Combo / List Box - Select More Than One
- Formula that can tell the difference between two letters
- countif function criteria question
- Help!
- splitting cell value into multiple cells
- Pivot Chart
- Cannot change to 11 x 17
- Highlighting cells
- BeforeSave and Cancel
- Deleting Links: Excel X Mac
- User Form size
- pasting data to 2nd worksheet to next available row
- Date Formula Help
- Pivot Table dilemma: top 10 AND bottom 10 sort
- If Contains
- Multiple combox boxes
- Code for Turning off Toolbars Share One Row Option
- Pivot Charts
- variable problems
- Hyperlinks unstable (absolute vs. relative) -- STUCK
- Convert hh:mm:ss to minutes
- Shell Statement
- Changing Characters Entered
- Sumif or SumProduct
- Creating a chart and exporting it to Word
- What to do in sort(merge?pivot?or what?
- Change code so not noticable
- Autofit in VBA
- combo boxes (again)
- Delete Rows IF criteria - Need VBA Help
- pH Titration
- Criteria tables for DSUM with range values
- Global versus local cell names
- Dropdown appear without using down arrow
- Workspace files not maximized
- Linking different lists
- cut and paste with protection question
- date picker
- How o find a price and match it with its corresponding date
- Moving around Spreadsheet using Macro
- Class does not support automation - run-time error 430
- Teacher can't add!
- single quotation mark?
- Link Path changes when file opened from remote location
- next blank row
- Super Protect Workbook/Sheet
- Excel Chart axis label
- Macro causing workbook unsavable
- How to make it: Enable Macros or Do Not Open
- Excel Minimzing when clicking on external link
- Small Business Tools Excel 2000.
- XP number format
- Risk & Sensitivity Analyses Excel 2000
- Forms Design Excel 2000
- sum a multiplication of values in 2 cols based on a conditio
- Run time error 1004 Object _default of method names not foun
- Adding time
- Mail merge list in excel
- Multiple workbooks
- Text to long to be displayed within merged cell section.
- Sort odd table (see eg) using Lookup, Match, Index - Can I?
- Split up
- Need help with macros
- Check content of cell in Worksheet_Change function
- Lookup with 2 criteria
- Splitting cell contents
- Protected Workbook Password Lost
- Concatenate(A1:A200)
- retrieve column letter
- Hlookup
- If-function
- Autofill
- problems with scrolling
- Pivot Table Formatting Problem
- VLookup returning #N/A rather than 0
- Dynamically defining ranged
- Want a VBA macro to shade subtotal's lines with word 'total&
- Sendkeys using Numpad numbers
- vlookup not finding data
- textboxes & treeviews
- dropdown box within chart that runs different macros?
- Time calculations to give negative results
- Worksheet protection query
- Posting Formula with Cell Row in VBA
- Can't Figure This One out
- Auto importing multiple workbooks to 1 workbook & summar
- Edit a named range to include more cells?
- Links to Workbooks Mind of their own
- Sheet Navigation by Double-clicking Cell
- Consecutive numbering help needed
- DisplayFullscreen=False?
- Transferring Custom toolbars between standalone PC's
- Automatically enter a formula each time a new row is started
- Can I get the data type for a cell?
- maximum number of worksheets
- Print dropdown list from auto filter
- Find and replace
- Custom autofilter
- Conditional Formatting
- Date Question
- Shared Workbook issue
- VBA properties of Charts
- Advanced Sort
- does excel not like the word 'true' as it doesn't like 'ID'?
- Userform help
- Returning Multiple instances of similar data
- Doubleclick on a cell shows formula
- HELP! on IF, AND, OR Function
- Numbers being treated as text
- Hiding a user form
- Pivot Table Refresh loses formats
- add two features tto my macro: copy to clipboard &
- Filtered Data
- Formula Trouble
- VB Looping!
- "for each sh in sheets" but for "for each fil
- Complex code for Max Value / CountIf
- Creating HTML with Excel - problems with user interactivity
- can i do this in Visual Basic?
- Two Drop Down Lists Working Together
- How to Turn Off Automatic Convert to Hyperlink
- pivot tables - can I use calculated fields?grouping?
- erlang excel staffing formula
- Range Name Creation
- use pastspecial on range, but only if above certain value
- How to change background colors of a cell using if statement
- Better way to Summarize data?
- Printer list....
- Pivot Table Multiple Source Range - Need Layout HELP!
- Display selected records from Excel Database
- saving spreadsheet
- Lock Column Widths
- Too Much To Nest
- MATCH? VLOOKUP?
- interactive list box on a user form???
- Opening .chm files with VBA
- Pivot Table: Page Button
- How to Move Cat Axix labels to bottom?
- Need A Formula
- Another Basketball Stat question
- Cannot copy worksheet from one workbook to another...
- Help! Using a VBA array as a argument in a Function.
- Data Validation Lists
- Programmatically enabling macros?
- sending workbook from vba
- Referencing another workbook + using index/match
- What could this be?
- how to make drop down menus
- VLOOKUP VBA and Variable Question
- Conditional Formatting
- location of a excel file on a mapped network drive
- Problem with DDE
- Can't get rid of a custom toolbar...
- Sending Email....
- Time Values
- user form opener
- MS Query Alias
- IF AND statements
- worksheet change - add contents to master list
- Validation for cells
- Pasting a Chart into Word and Resizing it
- Baffling!
- Time
- counting players results
- special effects in charts
- Find & Replace macro loop
- Double Click
- Working with a protected worksheet
- Change Default File Properties Summary
- Help with Macros...
- Letters as a code for numbers........................
- Open sheet with Userform showing.
- Add-ins...
- Disabling macros depending on which Excel file has focus
- Own Macro file locked for editing..
- Charting default color order?
- Random Cell Selection
- Userform question
- Data entered in one column affects another column
- Select All
- freeze background color of cells
- to open several excel files
- Date Format
- macro problems
- How do i select min value from range
- Formula for allowing more than 7 nested functions.......
- ANY TIPS FOR NAMING MANY CELLS
- Join two sheets and export as one html file
- Email by VB
- Auto Run a Macro At a Particular Time
- Command Button - Macro to print a specific work sheet.
- Vlookup in an IF statement ?
- SAVING WORKBOOK
- list directory / folders
- Column chart
- What's wrong with this (short) VB code?
- Filter question
- Deleting rows with more than one condition
- Deleting rows based on teh fact that one column has text
- Data Validation (max limit)
- FORMAT A CELL
- How to maintain the state of a toolbar in an Excel addin
- Cut/Paste based on a cell's value...
- Dynamically creating a Userform
- two quick questions
- Merged 2 WkSheets,Some Cols have diff headings,NeedHelp
- Automating cell filters and summarise
- vlookup question - esample provided
- FORMULA USING DATE RANGE
- Splitting one cell into two
- Find / Filter column where all characters are CAPS
- a "grid" control????
- Name of QueryTable: QUERY1???
- Changing cell formatting using conditional formatting
- counting occupied cells
- Out of Office in Outlook
- how to find/sum products?
- Autoshape won't stay where i place it using my macro
- Auto Macro - Again!!
- list box-spacing
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.