View Full Version : Excel Questions
- How to set Custom Autofilter "less than or equal to&quo
- Problems with Edit Menu
- Chart disappears until clicked
- "Invalid Picture"
- SUMPRODUCTS slow my PC down
- time formula
- VBA for Open File box
- Title bar in MsgBox
- Click into a macro
- Have can I show last opdate
- Have can I show last opdate
- hh:mm:ss to Minutes is wrong
- Delete range of records based on vertical selectn of fields?
- Formula not visible
- Multiple lines in MsgBox
- the "X" button on user form. Help needed.
- Incrementing a cell value based on another cells value
- Excel Solver constraint issue
- Adding Items to Listbox
- Copy a basic formula to other boxes
- Excel vba and the % symbol
- CHANGING THE COLOUR OF A CELL BASED ON THE VALUE OF ANOTHER
- Conditional Format different colours for 450, 480...1180 etc
- CHANGING THE COLOUR OF A CELL BASED ON THE VALUE OF ANOTHER
- Create input box and search
- Select rows and paste them to another sheet
- Is there a way to insert a button to do calculatefull?
- SECURING ACCESS TO DIFFERENT WORKSHEET WITH PASSWORDS
- Loop through Worksheets Question
- Pasting formulas without $
- Need help with Macro to clear copy
- Option Buttons not working when sheet protected
- "Drag to fill" query
- Lat value in column in XL2000
- Macro to show/hide defined ranges
- Date Question in VBA
- GET CELL COLOR?
- BIG HELP on CSV
- Deleting a text box
- Copy All Visible sheets to a new book
- Automatically checking a checkbox in a sent form
- changing the color of cell based on the color of another cel
- How to add multiple rows at once ?
- Hide a Sheet in Excel using VBA code
- Remove strange non-printing character
- Dynamic Listbox
- Date formula needed
- Combo Box from Controls Toolbox not working.
- Disabling the option of view /option
- Macro Question
- Sub Total function
- Cell protection changing with macro! Why?
- Table of Contents (Printout page numbers)
- Can't figure this out
- Code to autofilter based on a partial cell value
- Editing Links between files
- Replacing the =Today() Command
- Is there an easier way to write this code?
- Is a value included in a range
- RowSource
- Copying workbooks that begin with a certain word
- Formula help
- Subtracting 1 day from a date
- ByRef argument type mismatch
- Indirect reference and dates
- slow macro execution / print driver workaround?
- Member already exists
- Validation which includes VLOOKUP
- Quick autoformat question
- Format Axis
- Sum Product with Criteria
- Disable "Update Values" When Using "Replace&q
- Total of Totals??
- Pivot Table - Grouping Dates by Week, Months, years
- Turning off Hyperlink from entire workbook
- vb for cells wtihin a changing range
- Charting in XL2000
- Replace nested if with array
- copy worksheet or formulas
- Deleting Rows containing No data in a certain column
- Analysis Toolpak problem
- ISNUMBER CONFUSION
- can I use $F$3 directly to find out the value of a cell?
- Count totals in vb
- Calculating Date based on Value
- Using Formulas to Format Text
- Trying to make a sweet spreadsheet (tricky forumula)
- SHORTCUT FOR SUBTOTAL
- Subtotal question...
- Create a folder for WorkBook via VBA: can do? how to?
- Excel 2003 calculation upon opening file
- date formula adding days to jump over weekends
- Text Manipulation
- Need Help find something in 2007
- Excel charts linked to PowerPoint break after exit. Help!!!!
- Excel template - please help
- Results differ when running code with and without a BrkPoint
- Error received when I attempt to delete macro
- Decrease file size
- Folder Exist? Check if true w/ Boolean response
- Folder Exist? Check if true w/ Boolean response
- User stamping?
- Pick the earliest date from a selection of dates...
- sorting with combo boxes
- VLOOKUP with exact match
- math formula
- Countif
- How to add 'right click' access to a macro
- Cell References Not Updating
- Multiple Linear Regression with 20 independent variables
- COUNTIF works differently in Excel 2002 and 2003
- cells updating only when saving workbook
- DOW to Date
- Help with a complicated sumif please...
- Optimize - for (if endif) next
- Looking up the largest value in a column for a specific SS#
- Calling a macro from Solver
- app.insertFunction.Trend(Range(known Y's, Known X's,New X's)
- Excel #VALUE error, but everything is right
- Open Access Database from Excel
- Collect data from multiple workbooks into single sheet
- Target in ListBox
- Workbooks Fail to open
- Count text items
- Cond - Format with dates
- How do I get rid of empty macros?
- override an array formula?
- Macro LstRw
- copy number of sheets to file dependant on row count
- Pivot Table - Column Nesting
- Creating an autoshape
- named range on cell value
- Loan Calcuation Help
- Excel 2007 is SSSSLLLLOOOOOOWWWWW
- Copy subset to different sheet
- Oracle ODBC Data Import Peformance severely affected
- The IF function with conditional formatting
- RANDOM
- Trouble adding a 2nd and 3rd series onto a chart
- Need help with a formula
- ADDRESS MATCHING
- I guess I need to explain
- Purchase and Sales Data Analyis
- how can i Update a cell with a value and keep the formula
- error message
- LEFT & RIGHT Functions
- VBA to count rows with criteria in one or more columns
- overwrite an existing file
- spreadsheet distribution
- Autofill of matched data
- Extract data from closed workbook with GetData() and Match?
- Cancel button on a userform
- Sorting and Suming using drop down lists
- Problem with VBA Help pages
- Conditional evaluation of a cell comment?
- Summing based on conditions
- Color code chart by date
- For Each ws in worksheet array
- How to create a button that will hide "zero values"
- flashing between sheets in excel
- how to get the current cell address as a input to a func?
- How do I sum letters that represent numbers
- Another Problem: Pivot Tables --How to macro a few things?
- Insert current Date, BUT don't change next time
- Help: about hiding sheets using VBA
- Need help with conditional formatting formula
- pivot table won't clear deleted data
- vba code to open a pdf file
- Unwanted white background on data labels
- Default Font Setting
- Handling Worksheet events through add-ins
- Protected Sheet
- measuring crests and troughs.
- VBA: Changing Properties using Macro on Control Toolbox Item
- Conversion of Numbers into Text
- Decyphering error messages
- SetLinkOnData example code sought.
- Items in a series of data
- Sort list
- Message box to notify duplicate entries
- Macro Button - pass a variable
- Might be easy for you!
- For... Next loop problem
- Macro to see if cell contains link to other workbook
- More sort matrix
- Email Reminders
- Data Validation
- Color Formatting
- Formula help
- Add Form Control
- Conditional Formatting or Something else
- input box cancel
- Print Multiple Sheets per page
- VB Script for Baselining a plan..
- Comapring Dates
- IE7 causing Excel to fail to open??? HELP!
- Comapring Dates
- Compare 2 variables
- Copy range by Reference?
- Using VBA to enter date when other cell is = '0'
- Date Field
- vlookup/if problem
- export Excel sheet as Image file (i.e JPG)
- Workbooks.Open error
- Formula to Ignore Blanks
- Enable/Disable Control Toolbox Button
- Running Average
- macro not working
- HELP! Opening file / date / VBA problem
- Opening files
- SUMPRODUCT
- Dropping 1 field from a pivotchart
- Macro to run a bat file
- Automatically filling cells if A:C match A:C
- File Size
- "At Start Up, open all files in folder:"
- Forcing a fixed value on a cell with an IF formula
- Help Please Concerning Conditional Formatting in Excel 2003
- Find question, how do I make it so that
- Dulpicate Records
- Performing calculation and generating table using a macro?
- COUNTIF CRITERIA
- Renaming *.xls Files Help
- Auto open, update, print and save excel files...
- F9 Recalc Does not go away!
- VB TO FIND FILE
- Formula Req.
- How to extrapolate data from multiple sheets all at once?
- Assign a cell comment to a variable?
- Code for printing to last row with data?
- algorithm for special count of numbers in a sequence
- Conditional Formatting
- problems with hiding sheets
- Offset problem
- Highlighting the row with the selected cell
- IF formula - positive or negative distinction
- non-vector (multiple row) vlookup
- ActiveSheet in embedded workbook in PPT
- Custom Headers and footers
- Need Help Translating Formula
- Chart is using row number instead of vlue in row
- Exporting Comments
- Formula to Include Validation list
- Refer to named cell or range using VBA?
- Chargebacks
- How to advance the counter inside the loop, before the end?
- Formula based on a vlookup result
- Goto
- find unique item code
- is unique cell value present in sheet True/False
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.