View Full Version : Excel Questions
- How to Find & Replace a particular string (an email address) found within all excel files within one folder
- formulas needed
- Comment font changes from default
- 1 to 45 , 7 number combinations with predefined SUM
- Cell pointing to other cells
- Dynamic Listbox?
- How to: Worksheet arbitrary range values to VBA Matrix?
- Rows have gone missing!!
- Sumif with criteria
- Why is my file so big and marco so slow??? - link to file
- Play .wav when message box pops up
- Codes to reset multiple cells in multiple worksheets within a workbook
- code to prevent numeric entries
- Vlookup or If?
- Change background but remain printer friendly
- Deleting a row in the middle?
- User form data???
- Reminders???
- need simple script to rearrange data
- Decreasing loan principle over a term
- Decreasing loan principle over a term
- Need help counting muliple criteria in same row
- Football Tracker
- Cut and Paste Selection to new Worksheet
- Language in CELL function
- Selection.AutoFill Destination macro
- Move control on VBA Userform
- Find out how much will be displayed
- Calculate Top Cost Drivers
- Max/Min question
- My code does not work. Please take a look.
- statistics questions
- Time Capture
- Shade sections of a bar graph
- VBA conditioanl formatting a range
- Time sheet question
- Visual Basic Macro Assisance
- VB Code Help needed
- Alternate option for NETWORKDAYS.INTL
- Match from multiple columns
- Run-time Error 1004
- macro for strings with 1 repeat in a column
- Data to the right of a dash
- Clear Cells After First Two Rows But Retain Formulas in Cells
- Need Another Formula...
- Extraction of data from word file into excel
- Historical Rates - Oanda
- ŐWC controls in Excel
- VBA Add-in slowness in excel 2010
- Pivot table - creating a % field based on two other fields
- Loop within same cell until > today
- Delete empty rows
- Auto Populating Specific Cells in Multiple Identical Worksheets
- SUMPRODUCT or whatever will work...
- SUMPRODUCT or whatever will work...
- Add days to date
- Extract text from a range in 2 cells
- Data validation list
- VBA Help, Macro set to refresh but overwriting wrong sheet
- Select by column and copy
- time difference gets #VALUE#
- copy values around a value by column
- Silly dynamic range question
- Currency Converter
- Volatile named ranges? Prompts for save changes on exit
- Hyperlink not working
- Close Excel
- How to transpose data with VBA
- Excel 2003 Pivot Table Source Data contains formulas
- Formula Question
- holding onto a high or low value
- Data Analysis
- Macro help
- collapsible panel in a form - need help
- Excel VBA disable print screen
- Using a variable in an AutoFilter sequence...
- Delete rows based on range of values found in Column A
- Open txt file using valaue in textbox2
- VBA codes not visible in Personal.xls
- FoundFiles in 2007
- MRAND and RANDBETWEEN...I need a compromise between the 2!
- If 2 constraints are met, I need excel to select its corresponding MOQ
- Input fixed (current) date depending on adjacent cell entry
- average non Blank
- Count Number of Jobs in Various time intervals
- Help with writing Macro
- Macro to copy data from an open text file to xlsx
- Scrolling weekly chart & OFFSET by a year
- Excel Tab delimited
- Three Condition Sum Product?
- Auto # rows in sequence based on data in adjacent columns?
- Populate with next choice in dropbox?
- Automating consent page through excel VBA
- Insert rows given a cell value
- Need help with formula
- Excel for Macs
- Userform:checkbox:controlling cell value problem
- Run-time error '9'
- How to hide blank cells in combo box?
- Macro to print to PDF based on cell value and using cell contents as file name
- Make cell read only using formula
- Paste the data by ignoringhidden cells
- Excel formula calculating Holidays
- set background for specfic no of rows and colums
- [VBA] Reduce size of embedded images
- Moving cells around
- VBA Multi-threaded coding?
- VBA Multi-threaded coding?
- Help! End if without Block If
- Further nesting of IF formula
- Copy data from one sheet to another
- stacked charts with customized coloring
- Compare Columns in Excel Issue
- Macro Advanced Filter Help
- Google Co-Ordinate Finder
- Delete username in comments
- IF COUNT formula needed... I think?
- TextBox Blank after tabout
- Saving Muiltiple Sheets
- Sum values based on a word in a text string
- look up
- Check if data in box
- BeforClose
- Currency Format
- worksheet_change x2
- Code to find out if anyone is logged into a computer on the network
- ListBox - need to show filtered Data only
- Macro - Copy/Paste Into new Sheet
- Swapping the way peoples names appear in Excel
- SUBTOTAL a COUNTIF
- Automatically run VBA script?
- Showing form while keeping focus on sheet
- How can you check if a colum has data in the correct style?
- Contain Value
- VBA for Circular Ref
- Tariff calculation
- Data Validation…
- using value from textbox in userform and adding to another textbox
- Number Combination
- Macro for opening a varying amount of files
- user name on comment to be deleted in one short
- Userform help needed - matching combox value to worksheet identifiers
- Counting cells if the cell contains defined text and another cell contains defined text
- Conditional sum using a macro
- Average Mandays per Employee
- Is it possible to save differences when changing cells, to another sheet
- Deleting duplicates in Sheet2
- Sum if array
- automatic calculation
- Display/Hide # of columns based on user input
- Indirect formula
- How to loop VBA coding...
- use check box to enable option on form
- [VBA] ColumnWidth Unit compareable to image size
- Forecasting Month
- ActiveX Controls, ComboBox, Adjustable to text size
- User Forms
- Polynomial Userform design
- close open dialog via DDE
- Quick help needed on a SUMIF-function with a string condition
- open a new file using non-default template via DDE
- Strip certain Characters from a Cell
- =if(isna(index(match isn't working for me...
- Grouping & Hiding
- copy with conditions?
- high resolution event timer
- Subtraction value
- Filter Question
- Calling arrays in more than 1 function/sub
- Prevent user from making selecting within range
- Date from TextBox to cell
- averageif excel 2007 as an array formula problem
- #div/0
- Cross-Sheet Conditional Formatting
- Add Macro's to List Items in a Dropdown List
- Need Macro to recognize if workbook is already open
- Sum not to exceed
- Visual Basic Private Sub Worksheet_Change Conditional Formats on Multiple Ranges
- Creating worksheets from a database
- remove/add module using vba
- Copying and Pasting Pivot tables
- problem with spreadsheet
- Max Number and Cell number
- Scientific Notation Errors
- Loop Question
- Combine/Aggregate Two columns
- "duplicated" Name error
- VBA Code Checker
- apply macro to specific tabs with specific words in title?
- VBA - Custom filter
- Count number of entries equal specific month?
- Pivot tables 'option' tab - XL2007
- Complex formula to identify when numbers turn positive
- Select a subset of cells within a row
- Excel 2010 Pivot Table Count Unique Values
- Simple Excel formula, but clueless
- Controlling MSN from Excel
- Vlookup doesn't work when paste HTML data into excel???
- For/Next Loops based on response
- SORT CountIF SUBTOTAL, and im completely LOST
- Table loses properties
- How to extract specific values from a column?
- VBA to find mininum number and then copy/paste
- Remove formula upon entry
- Macro to use cell references and text to replace words in workbook
- Time Average Question
- creating hyperlinks to documents on a shared drive
- Calculation
- jpgs from excel
- Finding all Text in a column that matches a numeric value
- Issues with using tab key
- Copy and Paste Formatting
- make cell containing #value! result blank
- ThirdParty security and protection
- Practical use for ISLOGICAL()?
- Big Problem executing code from excel 2003 then running it in 2007 file that xlsm file. Please advice.
- Independent Zoom Worksheets
- Array runtime error 9 help
- Excel status tracker
- Fill cells based on cell value (named range)
- Macro
- How to change the default filename of printer.
- Copying cell issues
- Macro to enter a calculation based on a condition
- Macro to pull data from pdf file
- Lookup, transpose? Help.
- Change Commandbutton colour when pressed
- (Yet Another!) Filtering Question
- Macro to use cell references and text to replace words in workbook
- Vlookup with multiple matches
- Autosum lines with numeric values
- Stop Displaying Message When Opening File Programmatically
- Average Percentage Between Dates
- Hide/Unhide rows by use of a formula
- Macro to find replace specific text in multiple sheet names
- check column for numeric data and stop and send alert if not...
- Conditional Format
- Excel template for word input
- Average of row excluding 0
- Rank within Rank
- Transposing Data
- Help with Sumproduct Syntax
- VBA Split onto a separate line
- Val command on a string than contain an undefined character
- How to run a macro in the background
- Inserting rows conditionally
- Finding the Cell Reference
- Password protect a single tab?
- Merge mutiple excel sheets into separate summary sheets
- Statistical Data with an If, and If, then count scenario
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.