View Full Version : Excel Questions
- VBA loop preventing further worksheets from opening
- Data validation for text box
- problem with comparison
- Opening Files in multiple folders
- Custom Number Formatting of Axes on Charts
- Formula for copying from 1 workshheet to another within the same woorksheet
- Delete rows with #value!
- Removing leading zeros and spaces
- Need Help with a Formula
- Advaned VLookup Issue
- Need help with macro
- If there is Filter - Remove, If none, exit sub
- Password Protect Macro
- Search formula result...
- Workbook_open() doesnt work
- Auto fill formula down when data present.
- filename shortner
- Replace a macro in multiple Workbooks
- File loses all formatting after saving, closing and then reopening file
- Count Data in a specific range date
- Using two NEXT loops
- Summing of dates with times in them
- AddComment with a date in it
- =countif - Auto Update
- IF/Vlookup formula explan
- INDIRECT function - having trouble...
- VB Formula to list data based on criteria
- Visual basic question
- Compile error: invalid outside procedure
- A trigonometry question
- Parameter Query; sheet protected
- VBA and Excel
- search cell using list
- SUMIF with both vertical and horizontal data
- Identify a single letter in a cell
- Highlight current date cell
- Cell reference to a picture
- A bit more involved than my first question..
- values in a range
- Drawing tool bar
- Formula Help
- End-Down, in Shared/Protected Workbook
- Add Worksheets
- Calculating Unsorted Data
- Code to Perform Keyword Search on a Website
- Sum same rows after insert
- Autofilters in VBA
- Finding Fraud with Excel...
- Template Save As
- HELP calculating years from dates
- Keeping the shapes, add in a calculation
- Referenceing NonConsecutive Cell with Macro
- VBA - Respond to Double click on one sheet only
- Change button apearence works on 2003 but not 2007
- Attach a Worksheet to Lotus Notes E-mail
- Help with a function...
- Auto insert line if no match?
- How do I automatically hyperlink to the reference in a cell?
- Flashing/Highlighted Cells for DATE
- cut and paste every third row and paste cell contents into first available column above
- Removing Rows based on Cell Content
- Font.Color very slow
- Why Excel's file size balloons
- Save Pivot Table as Web Page
- File Size
- Help opening workbook and copying data
- Regression -- Constant is Zero-- Help
- Application.ScreenUpdating = True (or maybe FALSE)???
- Textbox pad with zeros if maxlength not met
- SaveAs VB Code
- Loop until + If else function help pls
- want formatting in adjacent cells to match
- Array Formula help
- Paste formula only in cells containg values
- Automatically Updating Cells
- Save to another workbook & keep in original workbook name open
- Show/hide hidden columns using conditional formula
- Macro-Add new data to the next row daily?
- activecell to work only in certain range
- CommandButton on WorkSheet
- Vlookup Problem
- Need Macro to take data from spreadsheet and either put into Access DB or another excel sheet
- 2007 problem FOR NEXT
- Excel Charts
- change font color in an "IF" statement
- Pivot Table - how to summarize by value?
- combobox value in Cell
- break line issues
- Vba open from template changes links
- Count the number of workdays between 2 dates
- Nested IF Formula, Order of Operations
- Dynamic range in VBA code (recognize active row)
- Subtotals-
- email when cell changes
- Drag and Drop Layout Generator?
- Ranged countif and sumif criteria
- Declare a VBA variable as Excel array type
- Filter Multiplication Question
- vlookup last match
- Auto calculate and display a divisor accross a row?
- Clear contents button
- Stupid syntax question for range variable.
- match with wildcards in an array
- Transfer entire contents of a multicolumn Listbox to Worksheet?
- VBA Help
- Force entry in multiple cells
- Multiple sheets
- Filling down formulas
- Excel 2007 (xlsx) document crashing on open
- cross sheet copy based on value
- Changing date in formula?
- Conditional formatting an entire column
- RefEdit problems
- Next Workday formula
- double lookup
- Fill Multiple Cells With Data From One Cell
- Auto vertical pg break
- trying to compare date range vs today and then return value
- Pivot Table Chart format
- Countif "Count how many Mondays" from a date range
- Problem Referencing Arrays
- Excell spreadsheet row spacing
- Deleting Duplicates Help
- Populating responsive dropdowns WITHOUT VBA
- Unable to get the PivotItems property of the PivotField Class
- Duplication macro
- VBA User Form Code
- How to incorporate inflation to adjust on a calendar basis, and other questionss
- how would you Search a Column of Text Strings for specific text?
- Extracting list of consecutive phone extensions
- Seperating + and - values
- Reference with two criteria
- Wrapping two columns when printing
- Countif date?
- Copy and paste macro help
- How to show hidden spreadsheets ?
- putting userform data in a sheet based on textbox date
- Adjusting Date & hour for GMT
- Help on getting SUMPRODUCT formula right...
- password file
- how to calculate standard deviation
- Simple VBA help
- custom cell format
- formula subtraction and copy
- inserting a date compare formula if required.
- Rows.Count not working
- just wondering
- copy info to new sheet
- Auto Filter & Formula
- Automatically input static date
- Active cell question
- VBA for SaveAs not working
- Form Caption Length
- Macro Help!!
- Advanced Filter
- What possible pattern could be made?
- If cell value is changed then call macro
- Help with Importing CSV from Dynamic URL
- Excel Formula
- Help create ONE dynamic chart from large data set
- compare numbers
- Counting dates in current month
- Conditional text mode
- Populate a yes/no column based on another sheet's contents?
- Open new workbook on difference application.
- odd file size question?
- Split column contents into 2 columns
- VBA error on row deletion.
- ComboBox.DropUp
- Evaluate Method
- count if more than 10 days for certain months
- Macro 2007 add to filter selected value
- Make calendar of weeks in worksheet
- Excel Quick Questions: Urgent!
- Working on a Duty List
- Team Competition Formula
- If cell A is blank use cell B
- Combo box "on change" event triggers loop help please
- Date/ Time appear on form labels w vba?
- Print required rows and columns
- Adding Multiple Times
- Lookup, Index, Match ?
- protect sheets even if they are group in a doc
- Search In WorkBooks
- How to specify a location for updating with vba
- SaveAs based on closed file names
- Excel 2007 VB Accounting Number Format
- Data Input
- Learning Excel Formulas ?
- Changing cell in multiple sheets?
- prevent copying
- Another One
- Simple Macro need help! (Private Sub Worksheet_Change)
- Small Excel Table
- lost formulas
- Changing cell different colors?
- Add calculation to =ROUND(W5,0) & " " & IF(W4<W5,"▲", IF(W4=W5,"●","▼"))
- add string to a string
- edit Formula in Macro
- Is this vba code right?
- ComboBox, ListBox, Array, Sheets, keys, Unique items -> need faster
- Displaying an average
- Excel formula help needed
- inserting pictures
- Reading a big text file
- Run Macro Every Sunday, but.......
- help with this data
- While and conditionals...
- Dynamic Lists & #VALUE Errors
- help in vlookup or anything related
- COUNTIF Formula?
- Is it possible?
- how to write vba to create chart on fly
- Macros
- Count the amount of entries based on the Date in a column
- Odd request with line adjustments
- inserting image
- Adding worksheets as needed
- is this possible?
- How to separate CSV informations
- Combobox?
- Mechanics of a drop down combo box moves too fast...
- Change formula to vba
- =ABS(W4-W5) & " " & IF(W4< W5,"▲", IF(W4=W5,"●","▼")) Gives #REF! result
- Replacing formulae with values in a protected sheet
- Linking subs
- A Growing Spreadsheet: Refreshing an existing Web Query Through VBA
- Averages
- populating cells with references from another open Excel file
- Month number from Month Names
- Index and Match with Duplicates
- MS Word to Outlook via Excel ?
- Insert a row and new data using vba when if statement is true
- How to write code with error values?
- How to have Date count show as a Blank instead of returning a 0 result
- Custom extension
- Vlookup - Based on greater than
- How to pass different ranges to a chart source?
- This might not be possible, but...
- Unload Calendar when Active Cell Changes
- Consolidating/grouping multiple series in worksheet by date
- Scatter chart with different labels on x axis
- formula help
- How can we produce a blank instead of returned value 0 from a text to number argument in a conditional format?
- IF false Do Nothing
- Drop down list
- Get count, based on Comments from specific months of specific years
- Holiday tracker formula!!!
- Formula Help
- Simple Loop Help
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.