View Full Version : Excel Questions
- make any number begin with decimal point
- Vba code help
- Having a macro run if changes are made to certain cells
- Unable to break link
- simple formula?
- Activating Hyperlinks via VBA
- problem with cell having comma and not digit how to convert?
- Remove all unprintable characters, all white space, and punctuation from a cell
- Update VLOOKUP links
- Print Macro Issue
- Append data from one worksheet to a another worksheet
- Combine two lists if data entered in adjacent columns
- EXCEL!: Protect Cells & Cloumns in 30 Worksheets with a Password
- Need to apply a function to a range of cells over a range of worksheets
- If a check box is checked...do something
- Search Formula
- Problem sorting data into a list
- Capitalize Data in a Cell
- Invalid file name from valid source
- mr bang
- Alphabatizing Worksheets
- Data Import help
- Indirect VBA problem
- Extract Day Number via VBA
- Copy only certain formats
- help with SUM function
- System date format and excel calendar input.
- Save as not working
- Range.FillDown Acting Weird??
- Delivery/Timeline Analysis
- Adding Auto Number
- EXCEL1: HELP on auto filter button
- Sumproduct question
- Date Formula
- multi page userform
- Format Boolean Data?
- Excel Assuming?
- How to loop through a range of cells
- Using forms to Create Database
- Import Data in a Named Range from one Excel file to another
- Pasting formula in Vb
- Change Variable and Loop
- Concatenate inside a Vlookup?
- Set Print Area (Without using a Macro)
- Date calculation
- Associate data between multiple sheets
- Inputbox question
- how to create pivot tables from multiple sheets?
- Select All Rows (minus header) and Paste to new sheet
- Version Conflict With Find/Replace?
- VBA Routine only pulling subset of records
- find if external reference is not valid
- What is wrong with this code?
- Multipage tab size
- Access to Excel to Access
- Entering a Cell via Keystroke
- Subtotal?
- Easy Question (Just forgot how.. )
- Sort page on open?
- Excel 2007 Pivots and conditional formatting
- goto command to go in specific cell
- Filter a criteria on multiple columns
- COUNTIF, SUMIF, SUMPRODUCT ? wildcard substring
- YoY % Growth / CAGR calcuation in Pivot Tables
- Array/Lookup/Sum/Group problem
- condense my formula - Please help
- Nested if question
- Extract individual elements from a String
- Formatting column width of a range of columns
- Reccuring number
- how do i link an mysql odbc table to excel 2000 ?
- Conditional Formatting
- No fill for marker using .net
- Data Validation
- How to make a Equipment Maintenance Database
- Pivot Table questions
- Removing items from activex combo boxes.
- Formatting alpa and numeric in same cell?
- VBA paste
- Find and select date within cel
- Macro to Import Text File: GetOpenFilename???
- Cutting and pasting a bunch of columns at once
- Add new row after each comma and copy data from the row
- Value thresholds....768,561 rows
- Macro to create a new spreadsheet from existing workbook tab
- Redim Preserve in 2 dimensions
- code check
- Save worksheet as "Filename mmddyyyy" in MACRO
- Copying Data
- Excel 2007, re-set cell value to empty
- PivotTable Refresh..not so fresh
- password gone
- code to change font colour after certain date
- Trick Hyperlink
- When Selecting a cell I want a message to display the value of another cell. Possible?
- MIN() MAX() Guidance HELP!
- Full Screen if Read Only
- Border colour macro
- Be kind enough to convert formula to vba macro
- COUNT Question
- Msgbox every time the file is opened
- Excel 2007 trendline
- Search and Replace only works to a point
- Look for next blank cell in a column
- compare 2 columns and remove rows that match
- Bar code problem
- VBA Help
- match, lookup
- Auto-Adjust formula for different range lengths
- Check if a sheet contains vba code
- Validation Input Message - Character Max
- Finding table name with code
- Function acts like text
- Add additional items to an order form
- Apply formula to autofiltered rows only
- Printing out VBA Code in Color (Colour)
- "Unexpected error" in web query
- Excel 2007, macro step-by-step- instructions
- Replace using a macro helper column
- Formula or script to make fields mandatory
- highlight similar cells
- Multiple Range Select
- Range Question?
- Protect all objects except comments
- Setting the Same View on all Sheets
- finding average of numbers only
- Copying Duplicates
- Excel 2007, reset a button
- Excel quiz questions
- VBA code for automatic deletion of rows
- Move numbers contained within a string
- Autofilled time doesnt rollover
- one header for whole work book
- Macro Updated by Macro ?
- Please help, Formula to compute interest using effective interest method
- Dropdown in Excel
- References to another sheet are defaulting absolute
- Help w/conditional range formula
- Button Help
- I'm sure it is an easy formula, but I just can't get it!
- ? Range from variables in VBA
- extracting data from URL
- Copying multiple workbooks into 1 template workbook
- if help?
- Hide ListBox Column
- merging help?
- date and time macro or VB?
- Convert a string to a Range??
- Equals last cell
- Calculating 6 week and 3 month periods, please help!
- pivot tables wont refresh
- is this POSSIBLE???? (solver/goal seek???)
- trunc function
- Userforms and looping
- Sumif upto today
- Graph in excel
- Conditional formatting
- VBA RandBetween
- excel to sharepoint
- Adding Standard Deviation on individual data points on a graph
- VBA Question - Excel
- Condensing Recorded Macro Code
- Excel convert to pdf file in macro
- 2007 - conditional formatting based on formula
- Calender
- writing to a cell takes AGES
- run macro when Right Arrow key pressed
- Form location help
- password
- loop problem
- Can I avoid #DIV/0!
- Message Box - Help Needed
- Export Excel data to CSV
- Macro Calculating Message Box
- More VLookup Headache
- Show value from a table on second sheet based on month
- Run Macro from hidden sheet
- Reference to a cell depending on row in a specified column.
- Some advice on how to program with VBA.
- Pivot table created by macro to have variable source data range
- Event Macro to other other Macros each time the work book is opened
- for value more than 2 places in decimal
- .FileType = msoFileTypeAllFiles Question
- how to search zipfile depending on cell value
- Match Formula ???
- How to display most recent value with VLOOKUP
- Refresh Excel
- filter
- bar graph LABEL font size
- Find outlier and in tha case of two possibles choose furthest from the median
- VBA - Print only if report is not blank
- VB script - PIVOT table - debugging help
- help with possible excel
- Import specific fields from Access to Excel (VBA)
- lookup query
- IF function
- Multiple users to save data through Userform
- Getting ShapeObject Cell Anchor
- Import Access Select Query to excel
- UserForm Driving Me Mad
- Using VBA to launch and log into website using Excel
- Macros and user-defined functions used in several workbooks
- HELP ! - Storing Data Via Clicking A Macro
- Dynamic Range Sort
- Older Verision Conditional Formatting
- Formula for If/Then Statement with Times
- Conditional Formating Question
- Run Time Error
- Chart with annual and quarterly data
- change information in several charts
- Creating PIVOT in existing sheets using VB code
- Vlookup format problems
- 2003 Syntax error not in 2007
- Nested IF Statement
- Trouble using a value contained in a circular reference
- Automatically Moving Info. From One Tab to Another
- Need cell formated to show days, hours, minutes, seconds
- IFERROR etc
- Modify Time Format Macro
- Sorting-different spreadsheets together
- VBA to update external links automatically
- How do I add Pluses between words?
- Command button color change cycle
- VBA to subtotal grouped sheets
- is there a way to count rows highlighted excel 2008
- conditional format in pivot
- conditional format in pivot
- Counting duplicates
- =IF Number or Letters
- comparison thing
- Excel Email and Hyperlinks
- Daily Schedule
- multiply VLookup (car travel time calculation)
- How to create a new workbook in VBA
- Please help with dates
- Countifs using an array instead of a range
- Max value query for multiple areas - Poss lookup?
- use text in a cell reference in a formula
- If/Then Formula Statment Help
- Save as Macro
- Macro help finding and getting rid of data
- Easy question for a simple SQL query
- Setting a Range Object variable's address
- Running a VBA Macro upon a Keypress
- Alternative to index/match array?
- sorting by last name
- VBA Suspend AutoCalculate
- TRUE or FALSE: does a value in col C match any value in A or B?
- Need Help with a Formula
- Pivot Problems
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.