View Full Version : Excel Questions
- rounding and minimal amount
- Check values match range
- Process Brio in VBA
- Template
- VBA convert A1 reference to R1C1 reference
- permenantly naming spreadsheet
- VBA Friend Sub?
- Calculate/capture time
- Index?
- Rs.Open SQLStmnt, _
- First non-error value in a column
- SUMPRODUCT formula with condition
- Using date to get range for formulas
- Worksheet change event spanning multiple worksheets
- Extracting the selected value in a form listbox..?
- Setting Pg breaks using VB
- Trim function
- disabling copying of format from upper cell
- text file directly to vba array?
- HELP! VLookup - Destination sheet changes
- Removing blanks from a drop down
- Help with alteration to Macro
- Search for a Range based on a date
- Simple Question I hope?
- Look up & add multiple entries along non-contiguous columns!
- Learning Curve
- check whether a workbook is open
- Generate the target date/time excluding Weekends
- Sum as count
- how to get row no?
- VBA - How to enter work book name in cell?
- SUMIFS using many rows and many coulmns
- Help with userform if condition
- Counting Condtional Formatting
- Excel 2010 Toolbars- Tabs
- Shapes With Macro
- Excel 07 Macros in Excel 10
- Array elements summary in VBA
- Macro to Copy Data from Columns and Paste it Rows after If Given Criteria Matches - Working need to make a minor change
- Help With Input Boxes
- Vlookup then reference row below
- Find in different workbook
- Excel 2010: how do I show 1 continuous sheet?
- Knowing Name of Shape with VBA
- range name
- Macro to Clear Contents Based off Criteria in a Filter
- Macro to open multiple sites in multiple tabs
- Macro very slow to execute: shape deletion seems to be the problem
- weighted quartiles
- auto Copy formulae
- Deleting a line given two conditions
- Double Declining Depreciation Schedule Doubling Months
- Average IFS with OR function
- VBA Find/Select Worksheet with Range as Name
- Conditional Formatting, Concatenation, Indirect, Highlightin, any thoughts ...
- Compile Error: Invalid Outsid Procedure
- Formula Help Please
- delete duplicate cells after merging data
- Parsing City, State, Zip from one cell
- Linked List Box with Unique Values
- Hyperlinks - Retaining cell Name and embedding Hyperlink
- Fuel mileages
- Prompt for new Active Cell
- Can I use an inputbox to have a user define the location of another workbook?
- Return blank cell when using "=" for reference
- Combine Duplicates?
- Error Message: Excel has stopped working
- Tabindex to decide on order of controls in loop?
- IF Formula
- Deleting rows with duplicates in a certain column
- Emailing multiple recipients from Excel Based off Cell Value
- Vlookupnth (UDF)
- COUNTIF or COUNTA question
- External Link List
- Format Text in cell as proper name "Marvin" instead of "MARVIN"
- Table Help
- Automatically Naming Worksheet...
- Pie Charts: Segments Not Separating
- VBA automation - gaurding against general ODBC error (database connectivity)
- Vlookup with wildcards in the "table_array"
- VBA Help
- Chart help!!
- Creating a 2nd Excel Workbook
- adding a module with VBA
- Display cell's entire contents without Autofit
- Can't place formula in cell using VBA
- Excel Userform Print last 30 rows from worksheet
- Taking data from one excel and moving it amongst manu others
- fileaddress = #NAME?
- VBA Question
- If-Then type formula with relocation of data
- Creating Inputbox for Loop If Statement
- Print ALL URLs from spreadsheet at once
- Bar Top Value in Chart
- Formatting file paths
- countifs(team, "olderthan 1 year")
- VBA to delete the folder
- Embed
- VBA - Simplify Multiple Selections?
- Macro: repeat macro on the next rows down
- Copy all rows based on text in cell...
- Formula Auditing Functionality Not Working
- too many arguments for this function
- Referencing the cell color
- Hlookup #N/A ????
- Moving Information with conditional formatting
- Maintain cell data when formula resets?
- Sum criteria
- macro autofilter skip if blank
- Set Value of cell = looping value
- Picture Problem
- Macro to Delete Macros
- Charts in 2007 - any way to get advanced choices?
- accidental autosum
- vba to save changes in worksheet but not entire workbook
- Problem charting 2 variables on separate scales in 2007
- userform time
- VBA help to count cells with conditional formatting active
- Sorting Data in Different workbooks
- Dictionary object Vs Collection
- VBA to Delete rows if
- Move Worksheets To New Files From List
- Add menu bar Error
- Help with Nested If Statement
- Active Printer Problems!
- formula returns wron result
- Drop Down Menu List to add rows
- Variable data source for chart
- merge results from multiple worksheets
- VBA - ByVal Target As Range help needed
- Filter and display only filtered data
- Populating a column in Excel from MS Word
- How to reset color palette in workbook to default colors.
- Custom Function with IF statements
- Help inserting a new row into several worksheets and copy formula
- Data Validation - Switch Between List and Decimal
- Check/Change LAN IP
- Creating a reference from 1 userform to another XL03
- Totaling from page to page or folder to folder
- Vlookup to return zero if is n/a, but adjacent cell has value
- extracting data after a dash
- VBA copy-paste problem between workbooks
- Array formula to get list
- VBA Help Needed
- How to Exclude top row of table from data refresh?
- match time in vba
- Unable to unhide worksheets
- Offset (1,2) and Multiply
- Moving random selection
- Using VLookup function
- Select all sheets except 4 specific sheets
- Conditional formatting in Pivot Tables
- Excel 2010 - copy/paste is broken - help
- Optional solutions v look up and IF statement
- Macro to Create/Delete worksheets
- Help with Countifs or Sumproduct
- Computing distances from fixed location
- cant control page break preview
- Help with searching and listing names
- Text to Columns Problem
- Extract Fedex Tracking Number
- Quick sEarch
- Loop using If statement to find three different types of data
- Empty cells =/ Zero
- Macro works for me but not for him!
- Excel Screen Display Problems
- Worksheet : Show last time updated
- Filter Question
- Using MAX and OFFSET functions
- How to transpose data
- Cell value to determine tab to pull data from in different workbook
- Crosstab Query from Access to Excel Trouble
- Countif/Mid?
- Replace macro help
- Hard time following Custom Function
- Virtual columns OR let me explain ...
- Formula that cycles through tabs
- sorting merged columns
- Blank result instead of #N/A
- Compare and Write Yes/No
- compare two columns using if function
- Add Same Letters To Column
- Dropdowns with "ALL" option
- Sorting a large amount of data
- Using Find with VBA
- Only want to Add Bussiness days
- Flowing Columns to save paper when printing.
- Need Help with Index/Match Formula that uses Column Header
- VB code to email multiple customers
- vba - excel 2010 - use macro to download pdf files, rename the files and save them in a folder
- Counting specific information within a range
- Formula to find the results.
- Conditional formating absolute reference?
- Using Conditional formatting with subtotals
- Screen Display Problems
- match function using defined range as lookup value
- Trying to understand a line of code re: Dynamic Named Rangesfrom Mr Excel's textbook
- textbox for chart axis labels resizing
- Minute by Minute Stock Prices
- Date and time calculation is giving an incorrect answer
- Can this be made smaller?
- Chart lines, same weight, showing up differently?
- maybe easy answer
- VBA code copies to relevant sheets - but doesn't copy the data validation?
- Count enique values.
- NEED to add logical values, values in the array or reference VALUES
- OLEobject..why won't it play??
- Date in Excel 2008 and 2003
- Help with array variables and keeping them synced w/ new rows
- excluding a sheet from a looping macro
- auto download file from URL
- making shapes clickable
- Help with ISERROR
- auto download file from URL
- Autofill formula down when value is entered in next row
- Array Formula Alternative Needed
- How to interpret HTML tags in Excel
- User Input as Range XL2010
- Export MSWord Bookmarks & Selected Text to Excel
- Creating an Order form for work? I desperately need help and direction please
- Removing duplicates with less elements in a row.
- Merging Cells of Equal Value
- Block If without End If Error
- Excel Database Segmenting
- Retrieve format value from a Cell
- Clearing a directory using VBA
- Pivot Table Filtering in VBA
- Need serious help
- macro copy functionality
- How to sort 'Values' in a Pivot?
- Using Excel to keep track of song usage for a church service
- combine formulas
- vba shape rotation
- Time (count) hundredths
- How to insert blank rows based on inserted number
- Automatically format only those month-cells, that are 3 months ahead of chosen month
- How to Stop UDFs from Recalculating Each Other Wrong
- is it possible with macro or formula
- What is this formula Doing
- Inserting Images into Lotus Notes Email
- Formula query
- Connect Excel to Multiple sessions of Teradata, possible?
- Sorting alpha numeric (including ".", and ",") data
- Filtering and producing a list
- Pulling data into seperate sheet (but not certain ones?!)
- VBA Enable button when ListBox item is checked
- Looking up a value within a range and returning a value
- from columns to matrix
- Need a macro to keep track of files in different folders
- week on week spreadsheet help
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.