View Full Version : Excel Questions
- Index and Match
- Prevent web based Excel pages from opening in IE
- summing values in a column
- Changing the Format of a Vlaue
- Match a figure to a range
- How to clear cell formatting?
- Inserting a row
- Move to end of Used range in row ??
- Remove 1 character from txt string
- How to insert number 1 in Chemical Formula?
- Inverting graph axis
- hiding sheets
- Text to value
- not sure if this is possible in formula terms
- nesting IFs
- automatic overview
- send mail to 2 email address's
- Return word containing certain character
- Save as including check for existing spreadsheet
- Formule problem
- nesting IFs
- help with a chart problem please
- Finding dupicates within a cell
- Grey Screen of death
- How do I point my Query to a new server?
- GetSaveAsFilename Date Format
- Moving Text boxes within Excel
- message box time out
- Summing N/A
- Opening File with Macro
- Sumif with dynamic criteria
- "Can't shift cells off screen"
- creating drop downlist from a different workbook
- Help Excel formula Complicated
- Need to return a section of a text string using a comma
- Range Limits
- Excel rounding 16th digit to a zero
- Cell referencing with square brackets
- Autofit Rows and Protected Sheet
- trying to replicate: =X-Y (Unless Y=0, in which case =0)
- Data Validation Dropdowns
- Excel 2003 / Pivot Chart / Conditional Formatting / Macro
- if either 2 cells contain a true formula
- Filename
- Urgent Help
- VBA - filter a col in a WB with criteria from another WB
- Datedif calculation error
- match function help needed
- Text To New Worksheet Macro
- I hate reaching for the mouse:::
- Vlookup problem
- National Insurance number validation on blocks of data
- Lists & LookUps
- Ctrl+Break works but Escape key not responding in userform
- Finding number cominations in a range of cells
- Disable scripts when opening a workbook
- Yaer date formula
- Yaer date formula
- need to rearrange data
- negative time is shown as #####
- Help with Macro!!!
- Help with Macro!!!
- Macros keep getting deleted
- VBA Digital Signatures
- Assign value of 'Insert/Name/Define' variable to VBA Variabl
- Autofit Splits Words
- Average IF array with two conditions
- VLOOKUP moving reference
- VLOOKUP moving reference
- VLOOKUP moving reference
- Pop-ups
- Protecting Template and partially protecting worksheets
- Help w/ cell reference in VBA email code
- Escape key doesn't stop processing - but Ctrl+Break Does
- ListBox Width changes issue
- Freezing Rows and Rename headings in Excel?
- Simplifying Autofilter
- .SetSourceData selecting ranges from non adjacent columns
- Graphing with Secondary Y-Axis
- A Go To column heading widget?
- Sum contents of a row within a moving range
- Summing Variables (ReDim PV(1 to N,r to NS)) in VBA
- Double Lookup
- Userform that doesn't lock the workbook
- Countif not happy over multiple sheets
- Searching Excel from word
- Vlookup In "Reverse"
- Help needed to fix this SAVE AS code...
- SQL using VBA, upload excel to access loop
- Private ComboBox Event Subs NOT staying private?
- Hiding the macro code
- Print list of linked workbooks in a workbook...
- Really SLOW - No formulae - Is HTML hogging resources? Fix?
- Selecting a cell entered in a message box as the active cell
- Very strange excel behavior
- VLOOKUP / MATCH - Efficiency improvements using sorted data
- Row Offset and writing to next line in Activesheet--SOLVED
- automate hyperlinks on list
- SUMIF text?
- Sumproduct and Vlookup? Can they be used together?
- Change active cell color according to name above *[Solved]*
- Creating Arrays
- optional macro on closing
- Fill down a formula when row is first used
- Copy one row then insert new row, repeat
- Delete duplicate cells or rows with a duplicate cell.
- Sort and Align 4 Columns
- Eliminate Dupes in Mailing List?
- Round up
- Entering value in cell, displaying different in another
- Negative Values w/ Spin Button
- vlookup #N/A
- Setting the background color of a range
- Is their a way to attach all the files that are in a file to
- Whats wrong with this code?
- What formula can be used to get this result?
- Advanced VLOOKUP
- What formula can be used to get this result?
- command button to halt running code
- MouseMove on autoshape rather than form/command button
- Change spreadsheet that is in all caps
- Forecasting
- What formula can be used to get this result?
- In my code have the date default to Monday
- Inserting a row
- If Value on a Range
- What IF auto fill date formula question.
- Identifying when a field has been changed and taking action
- Save sheet as
- 3 columns into one but with space between words
- 3 columns into one but with space between words
- Remove Extra Characters
- Quick Dim Question . .
- Macro password help
- Moving Data from one workbook to another
- Subtracting dates and times
- Loading a list of forms via a macro
- Not Null If Statement
- Multiple lookup values
- Wave Functions
- Conditional Formatting Ranges keep changing
- List Box Selection - Change using VB code?
- Protecting Template and partially protecting worksheets
- Named Range change on each sheet
- Grouping in Pivot Tables
- Timing a series of pivot refreshes
- Excel Formula for "if the day is before the 10th",
- Excel Launching
- Sort to Different Page?
- Filter TOP TEN for multiple dates..help PLEASE!!!
- protecting worksheet and unprotecting some cells
- Get all available XL worksheet functions
- Need help with parsing data in a cell
- Merging the results from two SQL querys on seperate sheets?
- Employee of the month (email of certain cells).
- Hiding a Userform
- SL Depreciation for multiple purchase dates
- Preventing Logoff or Shutdown
- Shifting one column to the right
- Miscalculation by Excel?
- Reading text as a range in a formula, type conversion
- 1004 error (newbie)
- Need a formula for invoice
- Scan for cents?
- VBA Question
- VBA Question
- Help with IF/AND/OR formula
- CUSTOM TOOLBAR ISSUE
- Trying to copy worksheet that has a macro
- Looking for some coding help
- Excel 2007 - Advanced Filter - unique records - strange !!
- R1C1 Formula/Loop
- Time sheet calculating hours owed
- Need Help Understang Code . .
- Cell Problem
- Countif formulas
- Keep formatting & formulas of data when double click piv
- Creating employee schedules using preferences
- check boxes and row width issue
- Number format vs general format
- Multiple column filtering
- Pivot Auto Update not working
- Vlookup
- VBA Function to copy data between two sheets produces nothin
- Linking Pivot Tables by Page
- Problems with Pivot Tables
- Change cell data
- Payment Formula
- Very specific help needed
- SOLVED - Unable to define sourcedata for chart
- Complicated coding and loops
- Complicated coding and loops
- Selecting certain worrksheets for a macro to run
- help needed- simple question
- Conditional Format Formula
- Application enable events
- Important but Simple Question
- have a question about merging mutiple workbooks
- Excel advice for a small business
- Dates and Calendars
- Sum cells that contain numbers and text
- help please! Automatically showing pictures
- After-print Event?
- Number of combinations in increments
- I need help with excel
- Seperate datas based on certain condition
- Shorten and automate code
- Betfair, Trading and Excel
- Need Help with the IF command
- Sum of range + loop
- Filstructure in a userform and save to new directory
- Can't change pagefield when no data in previous view
- Removing duplicate rows
- Adding to a list
- Exstracting Data
- Sumproduct ,columns
- Textbox set focus
- Run Macro When Worksheet Is Selected
- Locking Textboxes
- Printing Frame Text (Userforms)
- Colour of VBA Code
- VBA Vlookup problem, application vlookup
- Tricky one,please help!
- Making cells disappear
- Sort keeps reverting back on data refresh
- Controlling button properties on a worksheet
- Sorting Columns and Freezing Rows
- Save Workbook in subdir (vba)
- Sumproduct with dynamic range
- how to use find properly?
- General Query about Excel -> Windows in Taskbar
- COUNTIF with another IF, plus an OR?
- Regular expression question
- If statement question
- Cell format
- Save As Macro
- Help summing by a group
- Add item in a combobox
- Q re: splitting cell contents and returning related data
- Vlookup or Search question
- Saving Custom Toolbars
- Code for auto-complete
- Never Use VLOOKUP(,,,FALSE) again!
- Getting data from Excel to a Java application?
- How do I reference a reference?
- Code to close down a specific excel File
- Creating a drop down menu?
- Removal of blank spaces
- Rather specific query re: opening files through hyperlinks
- Deleting rows on condition
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.