View Full Version : Excel Questions
- Word VBA - shortcut keys suddenly triggering a rogue dialogue box
- WorksheetFunction.CountIf, with non-numeric
- Help required to Convert Numbers to Hyperlinks
- Automated data transfer with date
- Timed Macros
- Multiple Criteria, Multiple Worksheets, Multiple Workbooks!
- Lookup from SQL table
- Date Formats to be corrected
- Need Macro to replaces the ## with the Column Heading
- Automatically multiply cell
- VBA to identify different file suffices, but unknown file name
- Autofit merged cells
- open to specific sheet If I open the workbook
- Alert messages in Excel 2010
- Where to start - grouping etc
- Open on this week's sheet
- Finding last column before blank column
- Multiple Criteria SUMIF
- help with a task.
- Formula help
- Lookup formula help...
- Calculating future sales?
- Number in column
- Can You Explain This Formula
- problems understanding IF formula
- Cash Flow Spreadsheet transpose
- Sumproduct multiple criteria
- Macro to open template
- and and or formula on excel
- Multiple arrays
- Excel Formula Help
- Exclude from array
- Combo Box
- number of weeks into the quarter
- Merge Reports to Master Sheet that has static rows of info
- super absolute cell reference
- Inserting page sum in footer
- Newbie with text problem
- Creating a Userform to Search/Edit Worksheet Data
- IF with ElseIF
- conditional formating over two ranges
- VBA/Range
- Convert month # to month name
- VBA Error 400 with Button
- split text
- Update Links
- Pivot Table Date Range Picker
- Calculation query
- Sum using colour as criteria
- How to create multi select drop down in Excel
- Sum up Value dependant on Month
- VBA - Selecting entire column
- VBA error
- Change row content via macro
- Application Defined or Object Defined Error
- How to write a macro to change data source of a pivot.
- whole numbers not decimals
- list
- erratic decimal points and rounding
- Copying text string from a protected cell
- ISBLANK /MATCH array formulas not working...
- How to Select Multiple Sheets in Excel
- open a word doc
- Unable to Assign Macro to Button
- help! compare cells and conditional deletion of row
- Events stopped working after moving the sheet to another workbook
- 2 VBA Issues w/column size and return to A1
- calculate a range
- Cell values of Multiple sheets into single sheet
- Hyperlink with CTRL
- Simple Formula
- formula needed
- Printing frozen panes on all pages
- Excel 2003 Macro's with two excel Sheets
- get filename of pivottable
- retain chart settings
- Populate cell with text if cell is not blank
- find function eroors
- help with range(cells(x,y),cells(z,y))
- 1st / 2nd / 3rd Days of the week
- Hiding & unhiding data dependent on selection
- multipage and combobox
- VBA Merge cells based on Different Cell Colors in the same Row
- Extracting Row from 2d Array
- Split the worksheets in two different Floders
- IT guy needs help to answer Find & Replace question
- Bold row if duplicate data in column H above
- Upcoming due dates
- Problem with OLE automation and excel.chart.8
- Variable Workbook name in formula?
- VBA for extending formula
- Problem with the range format
- Help with conditional formatting
- Football Statistics Yardage
- How many "," in my string... Is there a function for that?
- how to add a col in excel programmtically?
- Convert data From Vertical to Horizontal Format
- filter..Month in VBA
- Need assistance calculating Percentage on a spreadsheet
- traversing directory tree
- calendar
- How do I hide all worksheets that are NOT selected?
- Another Simple Excel Problem
- Prevent user from accidentally running a macro more than once
- Calculating future value with compound interest
- If statement returns correct value when true, but returns "false" when false
- Text to Numbers
- Text to Excel Conversion
- Weather Data Average Macro
- Need Help Excluding Sheet from Form
- Data Validation - Month List
- Index criteria
- Look up function? Or IF?
- Help with formula for calculation and lookup
- Format Pivot Reports for Distribution
- Need macro to run on all sheets not just active.
- Paste Values issue
- Excel formula help
- Userform Textboxes
- Stopping the computer lock
- Change value of cells
- Macro to update most recent x months in pivot table
- Conditional format formula
- If statement within Hlookup
- What is wrong here with code
- VBA Array Plots
- Multiple Conditional Formatting Help - VBA
- Userforms and Sharepoint Websites
- Edit a macro with another macro?
- Football Form Table
- Recommended Skills for an Analyst
- adding text to a formula result
- Data validation/merged cells question
- Copy/Dragging Formulas in VBA
- selecting cells
- Find if based on two criteria with offset function
- Excel setting
- search string function
- Email Macro
- KeyPress concept
- Deleting/Inserting Row Takes 3 Seconds Per
- checkboxes vs radio buttons
- Changing a File Name and where it is saved
- Record Macros to run on all sheets?
- Excel previous selected worksheet
- Problems with 64-bit Excel 2010 and API Calls
- Auto-population
- Date Conversion Issue
- Userform VBA Calculations
- Trying to Find specific values in 'other' worksheets
- Macro to open password protected files
- Remove every 2nd and 3rd row
- File Attachment Macro Question
- Subscript out of range
- Transpose rows of data to single row if they share something in common
- Just started with excel and cant get this to work.
- Keep Value in Cell with no Formula?
- VBA: Copying Filtered Data if non-blank
- pivot table styles applied during a macro not saving
- Help trapping a runtime error VBA
- Lock one or two columns only?
- not counting weekends
- Macro Needed
- Macro to copy all worksheet data to a summary worksheet on the same file
- Help with Filter, copy and paste keeping formatting
- If and Then with Loop Macro
- Count Duplicates of Visibile cells in a column
- saving a dynamic range as a bmp file
- Userform - Autofill
- VBA for wordfile
- Auto Close Excel Workbook when Inactive Period Expires - Problem
- Converting a column of data with varying digits
- data replication
- Odd loop for data
- Transfering data from userform to worksheet
- How to Delete UserForm and Class Modules
- Need Chart help: Time Value on X Axis
- Edit an existing query from an outside source from within Excel
- FileSearch or file picker
- Table lookup formula
- Advanced filter
- Average problem
- Restraining the size of formulas
- Calculation Help after Copy and Paste
- absolute link to another unopened workbook
- How to make it add up after copying ....
- Ranges used in other workbooks
- List and Name Manager with Date Dynamic Validation (?) or Auto Generate
- Quick macro question.
- Non-contiguous ranges
- month, year and date are coming wrong
- Daily task - tracking totals
- Excel PowerPivot Relationship Problem
- Is there a way to SUMIF based on Color
- What isn't 2003 compatible?
- Conditional Formatting
- or statement
- Clear contents code for partial workbook
- Finding the average if values are weighted
- A Lesson in Counting needed
- Macro to open workbook from a specified location in consolidate data
- remove hidden characters in Excel
- Removing rows that contain a certain value
- Row Patterns
- Name cosolidation
- Compare two numbers separated by a dash
- Rolling daily weighted average shares outstanding
- Workday
- Using varibles and object references in Userforms
- Deleting Blank rown in a column
- Centralised Macro Control
- VBA select date and the apply conditional format
- Checking every row
- Encountering a run-time error 424
- surely there is an easier way....
- Excel error compile procedure to large
- Need help for this formula to call out a box in excel
- Pivot Table Sum Column Sorting Help
- Macro and Function problem
- Loading pictures from already populated image control
- Streamline VBA code
- VBA to Delete Empty Comments
- MacroProblem-Receiving a Compile Error on UserForm
- Transfer fixed width data from excel to text file
- Difference in times not calculating correctly
- VBA to set form scroll bar control minimum using another scroll bar
- Call a specific validation dropdown list based on another validation dropdown list
- Odd Problem during Excel Spell Check
- Changing cell reference
- vba coding
- Finding cells with values
- Extract date from cells to right
- VBA search confusion :S
- Cell entry determines if a figure is negative
- Data Validation in Range
- Vlookup Help
- Look up value
- Select subset of data
- Windows 7 issues
- help with mulitpages and ComboBoxes
- Splitting text and reading parts of it
- How do I select and move a cell using the keyboard only
- Make vba project unviewable!
- Values Unrecognizable After Update Userform
- VBA: Find cells that are not empty and copy to Textbox
- Which Procedure was I call from?
- Hrs & Mins format
- VBA compatibility from Vista to Windows 7
- Excel VBA Now + TIME() ?
- Formula Required
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.