View Full Version : Excel Questions
- Finding last few characters in a cell
- Use Open File Dialog box when file is selected display file
- Exporting excel data as Pipe delimited
- Shared Workbook, lost worksheets
- Dynamic Charts (plotting highest numbers)
- Control Buttons displaying big red X on a Mac with OSX
- Selection.PasteSpecial
- Lookup Formula
- On Del function??
- Do not print text
- STATISTICS GURU Needed: Help Dealing with Outliers
- print without opening
- Auto-Select file name when .PDF printing
- searching a column for each instance of a value
- InputBox To Get Row Number By Selecting Cell
- Formulas for Adding Zeros to SSN's
- Removing empty cells
- macro to perform operations on all worksheets in a workbook
- Open this file from its current location
- Auto Emailing a PDF file from Excel macro
- delete data
- Age
- Copy sheet from wb1 to wb2 - without reference to wb1
- UserForm Checkboxes
- **RESOLVED** Printing problem in Excel
- Page Header Question
- How Can i decompile an Excel file
- Formula for Average Growth Rate per Year
- Combining Look Up and Logic formulas
- updating records with macro
- HPageBreaks error in VBA
- Password Protecting
- Paste and move down
- Help Cleaning Code
- Date Sequencing
- Making caps not matter
- Limit date range in Calendar Control to 1 year
- insert rows
- Prevent woorkbook being opened
- Input Mask?
- Search Facility Needed. How?
- Need to write and save .bat file using vb
- Help - Formula ranges
- Drop Down menu in cells?
- Macro for saveing and inserting files
- workbooks.open with javascript
- INSERT OBJECT BOX
- Page Set up
- Need to add a number that contains TEXT or HYPHENS. Can I??
- Kill a read-only file - getting an access error
- file links
- Checking if filename is open, then macro run else don't run?
- Can't get macro to move on
- Copy linked cells : Variable number of rows
- Disable scientific notation - Permanently, how?
- Try to close then delete using code
- Calculate where results fits into a range
- Diagonal line within a cell
- Chart with data in 2 worksheets
- Right click mouse button on the keyboard?
- Set Print Area Macro
- How to display a word when a char typed in?
- Migrate Personal file from Excel 2003 to Excel 2007
- How to seperate names
- Increment the date
- Linking cells to a workbook whose name changes
- take mouse arrow away event?
- UserForms
- Convert Function ToolPak gal to liter problem.
- Date Trouble
- End Sub not ending sub
- lookup for images inserted into a sheet
- Combobox or textbox value is a number ?
- Extract combined information from one sheet to another.
- Keeping the same cell when switching worksheets?
- Number length
- Doubled search
- Typing two lines in one cell
- Separating words from one box into two
- VLOOKUP MULTIPLE COLUMNS
- Select case problems?
- Select case problems?
- Add-in error...help needed
- text longer than 255 characters
- Warning when more then two decimals are used
- Pivot table: calculated item to recompute in tot
- Pivot table: calculated item to recompute in tot
- Loading Form causes Macro to break
- Adding labels to a xy chart series by selecting text box + =
- named arrays in a formula
- Conditional Format Formula
- loop through all worksheets in a workbook
- Counting Rows
- One more conditional formatting question *Sorry*
- Compound Interest Spreadsheet
- Variable Recognition
- Substituting Cell Names for Column Letter /Row Numbers
- Weeks in a month
- VBA to Find particular data and then Copy Row
- range of S/N converted to type of equipment?
- If VLOOKUP Looks to the right.. What Looks to the left???
- SumIf help
- question on vlookup perhaps?
- Changing format of Date if > than current Date
- Birthday calculation in a Pivot Table in excel 2003
- Changing format of Date if > than current Date
- Conditional Formatting vs. VLOOKUP
- Automatic Sequential Numbers on Invoice
- Writing from Userform to Database help required
- Converting a decimal value, to feet and inches
- Wierd Glitch Part Three
- Custom Number Format
- Change data source
- Self Updating graphs
- Not enough system resources to display completely.
- Making a formula read a cell's contents to know locations
- sumproduct help
- SQL inside VBA
- formula
- Contract a database
- SUMPRODUCT formula help
- Calculate Commission Percentage
- Menu system like Explorer
- Beginner help sought for vertical cell alignment
- Creating an array formula using sum and offset?
- Macros & Named Ranges
- Chart problems with Office 2007
- Due Date HIghlights
- Importing from and exporting to text files one line at a tim
- help with formula
- Read Only problem
- Display a variable list in Message box.
- Copy folder contents...folder contains current day of week..
- Coniditonal formatting on a calculated cell
- advanced vlookup function
- Pivot Table to different xls file and sheet problem
- Cell Referencing isn't working
- Hyperlink?, Import?, Export?, I'm not sure how to do this
- Need help with personal.xls and VBA = macro modifies the
- Forms in Excel
- excel amortization template
- Run-time error '9': Subscript out of range
- Adding a drop-down woes
- Question: Keyboard shortcut
- Variant Limit
- a couple of late night questions
- Pivot Table: Calculdated item issue
- Logical test in IF
- Lookup using differenct criterias
- Pivot Table format and Calculated Items
- Understanding Arrays
- Equity Trading Spreadsheet
- Display message for a fixed time and then close
- delete a doubled row
- How do I save data in excel when input=different excel sheet
- group the data
- conditional formatting help please
- Macro to paste in certain column, moving over each time
- formulas
- Help matching invoice to the purchase orders
- No Right MB Click in 2007?
- Help ?Auto unhide rows code
- Autosize all columns ?
- Referring to closed workbook
- Generating Pairs for Bridge Players
- Segregate Employees with VLOOKUP ??
- zeros???
- Search For Text in Closed Workbooks
- finding the 4 highest and lowest numbers in an array
- Double Click Worksheet Code Explanation
- Sorting problem
- Finding out what links are on a worksheet, and what they do?
- VBA / Excel: Code to check if events are enabled.
- Device I/O error
- Running same code from checkboxes
- Worksheet menu bar custom item can't be edited
- Userform coding help
- excell in a web application
- Vlookup - bug? Doesn't find match when match is there.
- INDIRECT - sort of
- macro with copy/paste to variable col/cell??
- String Dim
- Offset question
- Option button question
- Can I move values without moving borders?
- Help Please, Im new with Excell
- COUNTIF Syntax
- No of Days between 2 dates
- Condtional Format>Countif 2 Columns
- Another set of eyes for this Excel formula in VB
- displaying majority in a list and the highest cost together
- Auto Filter
- Recalculate a formula
- Capture data???
- conditional formatting? maybe
- help someone with a stupid question!
- Pivot tables - lock formats
- Confussed with VLOOKUP
- Time Sheets
- MIN question
- Deselect single row in multi-row selection
- Reset VBA Code
- Removing Duplicate Numbers In A Row
- Message Box Question
- Simple Userform/Code Query
- Embedded Slide Controls for Scenario Modeling.
- Select Variable sheet name in VB
- Formula For Counting Sequences
- Remove data refresh when save as different name
- Adding steps in an IF Formula
- Aging column
- Adding 'select all' option to userform listbox?
- How to trap an error in this code with a message box?
- Seperating data into other sheets
- Convert numbers to text
- Calculate SH/Sales Tax
- How do I set current range as a variable?
- VBA Vlookup
- Comparing the text in two columns for similarities
- Need to display rows that only contain the word "Total&
- Statement
- Reference data by date only (2 questions)
- Brain Ache Please help
- Adding a letter to a number within a cell
- conditionally formatting date cells by their age in years
- Need help with countif with multiple criteria
- 5 arguments in a formula?
- Predicting the Future
- VBA Code
- Need macro help
- Changing Date Created Date
- Advanced validation lists with name range formulas
- Naming an autoshape
- {Resolved} Moving embedded chart series via mouse
- Need help with combinations macro
- Help with .Resize applied to a range object
- Charts not recalculating
- Excel does not find a value returned by a formula
- Specific Macro Help
- Need a macro to search for a cell with specific text
- Pivot Table to Not Include New Categories when Refreshed?
- delete duplicate rows
- Sumif/Countif
- Search for date range in one Column to enter in another
- Macro to populate a treeview
- Sumprod returning diff values when its conditions aren't met
- help searching thru data using a user form
- Chart Name Changes
- Audit sheet
- Can the formula bar display values instead of formulas?
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.