View Full Version : Excel Questions
- weekend overtime
- Using IF function to enter a value in a cell
- Year Formula
- Running on dates
- Avoiding an error when automatically saving read-only file
- swap a portion of data
- IF and AND Contidion Two conditions at a time
- #value is showing for time
- Access to Excel
- No list in autofilter window
- seperate a number from a text cell
- I'm sure this list exists!
- a menu with caption "&add & remove"
- problem w/ linking data and networks ??relative path links??
- Sorting - Most frequent customers
- Displaying excel worksheets in VB????
- "My Doc" files auto-opening when excel is started
- Using Countif on closed workbooks
- Excel Activex Controls
- [b]Stacking Charts[/b]
- Line Column Chart
- defined errors
- DATA VALIDATION
- Subtraction weirdness
- double filter
- Conditional Averages
- cut and paste with a macro
- Where are my customized toolbars saved?
- Background in a single cell
- Countif question...
- Validation In-cell drop-down not working
- Searching for some sort of Drop Down List
- vlookup or vba
- Merging data from different worksheets
- opening workbooks
- Zero Values in Blank Cells
- Auto-execute macro to launch MS Word from Excel
- Customized Headers based on data on a page
- Merge/Combine/Overlay but don't Duplicate???
- Excel Error - Shutting Down
- How do I remove CONCATENATED "_" 's ?
- #VALUE!
- Patse Text From Clip Board To UserForm TextBox
- Need help: adding pretext to column of data
- Numeric formatting control
- Batch Files
- Adding up in Excel?
- find UserForms in other workbook ;)
- How to run another programs script...
- Import E mail Addresses
- missing range name
- Random Selection of Data Based on Criteria
- strange problem
- can I get rid of the CR on my worksheet
- ...alright...
- List Range & Autofilter
- Evaluate and hide
- OPEN WORKBOOK
- ComboBox list source question
- Copying Similar cells over a range (Macro?)
- How do I Only Show Filled Rows
- Project Zero Elimination
- combine several workbooks with vlookup??
- Hiding a file not found error?
- Workbook deletion
- Select Combo or Textbox value or Userform should not unload
- Make cell blank by formula
- Copy sheet when sheet name unknown
- Problem opening an "open DBF file" using Visual Ba
- insert row problem
- Present value of irregular amounts
- ALL CAPS
- IMPORTING A VERY LARGE XML FILE
- Syntax for FTESTV
- Excel Visual Basic Book?
- Subtotals in 97 and XP
- Setting Page Breaks To Keep Same Items on Same Page
- Files opened list
- Password protect worksheets
- Iterate through the alphabet
- Locking a VB Project for viewing
- Question: How big is your...
- Returning the column index
- Pivot Table Avg Not Correct
- Can you use wildcards in conditioning formatting
- Excel 97 copy of chart
- Easy Conditional Format Question
- creating new variables through iteration
- ranges get me every time
- Date format question
- VLOOKUP
- alpha issue
- compare 2 different stacked column series
- VBA - A question of speed / performance
- Custom Icons
- Help with transferring information from one sheet to another
- Finding MAX of a range and matching
- Open, search, and replace multiple files
- dates
- SumIf with Conditional Formatting
- Using code to "underline/Border" a cell!
- make Rank show ties as 1,2,3,4,5,6,etc.....
- VLOOKUP Problem, makes no sence
- Random Generator
- SaveAs
- Multiple 'If' 'Then' 'Else' Statements?
- seperate a Text from a number in a cell
- EMPTY STRING ( "" )
- formatting question...
- Making a Popup Graph
- =round - Excel Rounding Problem
- vlookup & if statement
- On Refresh Event
- Creating a Directory
- Remote macro execution
- Corupted Pivot tables
- Reading jpg info
- Selecting Items From a ListBox To Go Into Another ListBox
- Another Formula Question
- Need to Cancel this Post
- Application On Time wont turn off
- Conditional input?
- HLOOKUP/VLOOKUP/VALUE?
- count # of different entries
- Opening Outlook from Within Excel
- HIDDEN ROWS AND AUTOSUM
- Hiding Embeeded Charts !!
- Calculating cells that contain a specific piece of text
- Question: Vlookup and tilda ("~")
- Pictures and userforms
- scroll text in statusbar?
- Clever lookup required
- excel data transposing
- time format
- Text Removal
- ActiveWorkbook.AddToFavorites - tricky one!
- Graphing to the end of a variable list
- Importing Text Data
- Help with code please
- FILL FUNCTION
- Just need simple answer on index match here..
- cell comments via VBA
- Copy Sub-Totals**SOLVED** Thanks Jimboy
- Look Up
- Using form button to change visibility of control button.
- date format ex. 04/22-23/03
- Dynamic cell display
- Countif query
- Code to Delete Row, but not entire row
- Need Formatting Help!
- If Condition and copy function
- User Defined Functions
- Need to sort table with formulae
- How to move from cell to cell in a specific order?
- Cell Value By Condition
- FINDING UNIQUE ENTRIES FROM A LIST
- How to use countif with more than 1 criteria
- sort data in one particular field
- quotes
- Date Formulas
- GetOpenFileName equivalent for Folders?
- Text in Multiple Cells
- VB Code to delete certain columns based on Duplicate Entry
- Automatically hiding blank rows and columns within a table
- Two VBA Questions
- Remove last four characters from filenames
- Sheet_Change
- Pivot Table - External Data Source (import with condition)
- Add .Guid to references
- Colorindex issue
- Reverese Concentation
- double quotes when saving to a text file
- change color of cell in true/false statement
- Query with Parameters
- Macros
- conditional formating
- Two workbooks open - how do I activate the non active one?
- Copying and Pasting filtered Data
- Rounding numbers in Pivot Tables
- Disable "...already exists" Save and Replace Messa
- Matching Cells containing time in VBA
- Autonumbering
- Open a workbook on page one
- Newbee to Excel
- If function
- VBA to Sum Variable Amounts
- Linked Workbooks
- Disable "Auto-format" of cells?
- Combo Box Problem
- Capital/Lower Case/Proper
- Range
- Help with Spreadsheet and Chart
- Formula with IF
- TARGET and "BeforeDoubleClick" ONLY IF inside a NA
- Expanding Grouped Data
- Running a Procedure in the background
- Can't make pop input box a pop-up combo box instead
- Lookup Multiple Tables
- Conditional Formatting
- Automatically create a header
- Macro Formula to sum column totals
- Applying the same equation to multiple cells
- Hide background query
- Time Compare Formula
- Disable Help in Excel
- Using variables to create hyperlinks in a macro
- Table question
- Simple macro produces unintended results
- DoubleClick ComboBox
- Formula
- Excel Lookups
- Summarize Data
- Text boxes & advancement to next text box with Tab or En
- Check box question
- Shared workbooks and macros.
- chart problem
- Logging Activity in Excel
- Wordwrap
- savecopyas
- Disabling File Save As
- Referencing worksheet text box
- questions on vba
- DROP DOWN LIST BOX in my form for user to select PRINTER
- Formula Question
- Multible column auto sum
- [b]auto filter on protected sheet?[/b]
- Resize Right Header
- Sort by month
- Most likely an easy if statement ?
- VB to set Selection in Drop Down List Box (Combo Box)
- Copying and pasting cells with formulas linked to other cell
- Deleting Stuff
- A macro consisting of saving a file with the date and time
- Opening all prefixed files in folder
- Variable for Number of Print Out Copies
- SendMail Error
- cell entry to manage how many ranges to include in a formula
- Cut and Paste Part of a Cell with a Macro
- Percent of Sales
- Tournament League Tables
- Combing Cells without losing data
- xaxis formatting years
- Copy Cells from one sheet to another using criteria?
- clustered bar chart (formating the height of the bars)
- Auto hide blank rows and columns dynamically in a table - 2
- Macro to move cells back to same row on main worksheet
- Problems with pasting into percentage fields
- Comment Box?
- Formula Question
- Monte Carlo Simulation
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.