View Full Version : Excel Questions
- Excel & mp3 or wav
- Selecting several worksheets by position
- Large Excel File
- Comparing Arrays
- Probably an easy question (I hope)
- Macro need to download share prices.
- Sum if numbers are red
- Code Help
- Hiding and Unhiding Rows with VBA
- Macro to perform vlookup and run 'if then replace with' on neighbouring cell
- #DIV!0 Error help
- Pie of Pie chart with percentages (Excel 2008)
- New Member - Help Sorting and Displaying
- vba based on date and vlookup
- Position comment directly underneath active cell
- Chart ranges using Dynamic Range (defined name)
- count all the sub data
- Maximum Date in a variable range
- Macro code to find and color code Saturday and Sunday totals
- Calculating certain rows
- Copy row to new sheet
- Vba
- Wanted: Macro, for each sheet, copy Cell A1 and sheet name and write to Sheet1
- assigning a value to multiples based on a condition
- Excel recovers corrupt file and bares all?
- Sumproduct not working as desired
- show #n/a as 0
- How to select a column, starting at row "n", but selecting to the very end of the column?
- Referencing Question
- excel processes
- Conditional formatting
- VBA date format
- if formala with between needed
- Excel 2007 Worksheet Appear like Powerpoint Slide
- VBA loop question
- Can a formula return the cell reference of a vlookup?
- Sumproduct - Add Another Array?
- Locate rows by critera of multiple columns
- Nested Formula
- Sumif accross multiple worksheets
- Access to Excel
- Deleting Text Boxes with VBA
- Hiding or Showing Sheets Based on Criteria in a Cell (or two)
- Find cells with certain font color and change the color
- Listbox - Array
- Quick & easy - hide a worksheet based off a cells content
- Countif, or nested IFS
- Trying to show files in a folder in a listbox
- If Statement to return previous value
- Referencing a sheet in Excel 2003 vs Excel 2007
- Table Gained Points Record
- HELP PLEASE! Selecting Multiple Array of Sheets Based on Multiple If Statements
- Graphing Time Duration
- Reference A Tab Name in a Formula
- VBA Code Modify Excel Sheet
- Runtime error on Workbooks.Open Excel 2007
- Working hours between two dates excluding weekend hours.
- Excel Dropdowns
- alerts
- List what isn't there
- Question on IF, THEN formula
- having Troule Getting a loop to run
- Force pivot tabel to use same data source
- accessing excel via mobile windows PDA
- Excess blank rows below pivot table
- sort problem
- Printing comments only
- Something like vlookup but differently
- Counting the instances of one variable while excluding another
- How can I specify an ending range in a SUM function based on the #of rows?
- White Space Triggers Macro
- How to round off number after multiplication??
- auto open macro
- VBA Loop and Format HELP!!!
- I shouldn't need to select the Sheet
- Is GetOpenFilename sort possible?
- Calculate Net Present Value with VBA
- Transpose Data- range variable
- VBA code for conditional formatting
- Transpose Userform Data into Selected Sheet
- VBA Help!! Worksheet Selection_Change
- Help with cases
- Can't edit a named range in Excel 2007
- return value based on criteria
- Using TIME in excel
- SumIf with two conditions
- Subtotaling data & consolidating it
- Execute Macro/Sub in Workbook2 from VBA in Workbook1 - PLEASE help?
- Adding a Sheet via an action in VBA
- Copy Comments to Range
- Arrays, complex report or?
- Worksheet SelectionChange event HELP!!
- 2007, Not 2003 runs macro from Sharepoint Read-only file
- Average if with non-continuous cells
- Capture and restore autofilter criteria in Excel 2007 for xlFilterValues operator?
- Ranking text based on values
- Formula not copying in conditional formatting
- Way to search through webpage via VBA for word(s)?
- Sheet copy, numerical rename problem
- Column to Row formula
- Active cell color code tweakage assistance
- Folder Permissions Probelm - Please Help
- Add stuff together
- VBA Question on Pop up Windows...
- Dynamic Average or Rolling Average
- VBA & macro
- Macro / formula for pivot table drop downs
- Macro needed for a clear command button
- Hide section of Vertical Axis
- Macroname.Macroname Problem?
- navigate with macros
- Using a tabke to factor in as oppose to formulas!
- Pivot Table sums of two colums based on conditional filters
- Multiple criteria filtering
- composite bar graphs
- Formula for Comparing Two Columns & Producing a Percent Total
- Sumif ?
- Identify if text field is upper or lower case
- Use excle formula to select high value inventory for count
- Creating Variables from a Recorded Macro
- Object File
- Auto Filldown
- error 2046, running access macro from excel
- Bar Inventory - Beer Question
- Date format
- relations between sheets
- Why can't use excel built-in function?
- Copying formula, keep one value but not the other
- How transpose 1 dimensional string array within vba
- Excel Macro to Unprotect/Protect Password Protect Rows
- help with showing right data in cells
- Auto Filter seach for Not Null values
- Insert Blank Row After 5th Rows
- Urgent Help - Formula
- How to amend a series in a product formula
- "Public" procedures in worksheet module are Private?
- Need Help with a Macro
- dropdown menu macro
- Copy/Paste same text in "x" amount of rows based on the value of cell
- Macro Help
- Conditional Formatting advice requested - Red, Amber, Green
- Can anyone help with complicated VLOOKUP/IF issue, please?
- Up to seven IF's
- Excel newbie needs help please
- sorting the autofiltered range
- Blank Userforms
- 16 Digit Problem
- Personal macros
- VBA Listbox
- drop down lists
- Sumif on part of date cell
- VBA Help?
- Is it possible to get a macro to do this for 300 excel files?
- odd object = nothing
- Going Round In Circles
- Drop down issue
- Sumproduct with multiple criteria
- Open existing worksheet in a window
- can any one help me out please
- Stop Macro from running if fields are blank
- Multiple Look up returns header values
- Sumproduct + sumproduct
- Error 3709 connecting via ADO to Mysql from Excel
- Number as text problem
- reducing digits without rounding
- Counting the number of Rows
- Wildcard SMPRODUCT
- simple select form
- Convert To List
- Filter then send data to a continuos lis
- Adding Months to a date
- macro to find first blank cell in a column cut the value from left adjacent column
- clear the focus in listbox
- Cumulative Commission Calculator
- How to Flatten formulas?
- calculate cost for shops located in different zones
- Macro To Change Properties of A Drawing Object
- Create macro to send data to a continuous list
- Error (identifier not recognized) for a simple macro...
- Assigning password to individual macros
- Stuck!. Inserting custom user form into worksheet
- Date Format
- Advanced Filter (Unique records only) Probles
- WEEKDAY function does not work in all regions
- how to autofill as previous value
- Force Hyperlinks to Open in Browser...
- Excel Macro to rename 20000 files
- Font size in comments
- Find two numbers for a given number
- Paste special values only problem
- UserForm "If...then" Help requested
- Comparing Pivot Tables
- Simple Vlookup Help
- In need of a Excel 2007 Formula Expert
- Macro button to cut and paste special data into a seperate continuous sheet
- need a box with option buttons in my sheet
- need a box with option buttons in my sheet
- Conversion
- Auto add to validation list
- Copy Paste VBA
- subtotal 109 with criteria - not working
- Data patterns
- Calculate Percentage ONLY when 2 Conditions are Satisfied
- Changing analogue time to decimal expression
- help adding scroll bars to input boxes
- Cell double click
- Build a chart where data is not next to each other possible?
- Need to remove all hyperlinks and Pictures
- Sumif w/ ColorFunction UDF
- Listbox Writeback
- vb code to create a border ?
- Help with VBA worksheetfunction looping
- Omitting certain cells
- command to delete all rows in multiple worksheets within a workbook
- Moving average using different worksheets and files
- Games PLayed in Football Table
- copy trend style from one chart paste in another chart (Is it possible?)
- Get Address Parts from MapPoint with VBA
- Pivot table help
- Indirect Function advanced
- Time function question
- VB Macro to capture mouseclick on excel sheet cell
- Show All in Pivot
- TextBox Object - Retain Name when copied and pasted
- VBA Calculation Question
- countifs complications!
- Rank conundrum
- greater than or less than formula
- Blanking out the na()
- Copying data using a loop
- Issues with IF AND formulas
- File Becomes Corrupt After a Long Macro is Run and File is Saved
- TODAY function
- Problem with Complex retrieval formula
- Change name of named range across VBA code
- Sort is sorting but not perfect...need some help
- Help with IF formula
- vba - automate (avoid) pop up boxes
- Sorting a Pivot Table After Changing a Calculated Field
- What's problem in this simple code.......
- multiple vlookup question
- what is wrong with my formula IF(AND)?
- IF() Need 64 nested functions.
- SaveAs static copy of workbook
- Calculate percent change between last row value and previous value N rows back
- Conditional Formatting
- sheet has to be activated for cop?
- need help on a string formula/code
- AutoFilter+total cost
- Filter question
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.