View Full Version : Excel Questions
- Iterations/circular reference - #REF
- How to Exact E-mail ID's from MS Outlook Inbox and Outbox
- Adding Sequences
- open sheet and activate macro straight away
- close a tab in chrome
- Using Sumproduct with dates
- Headers and Footers Remove
- VLOOKUP - combine 2 cells in table array
- Deleting a cell when linked?
- Find Phrase in a cell and add it to another cell
- Splash Screen in Excel... Help
- Select and Replace help needed
- help with vlookup(ish) problem please?
- Copying lines if Data between spreadsheets in the same workbook where a cell starts with 'XXX'
- RemoveDuplicates: Removes non-duplicates..
- Setting Focus on a user form
- VBA - date format
- Cells with many characters
- new window should not open
- Hide rows where value is #N/A
- Leaving worksheet need to check if Combo is populated
- looping through userform controls
- Remove Duplicates with semicolon seperated
- Broken Menu from Addin
- Pull quanity based on date range
- Controlling Userfrom Check Box With Variable In Function, Office 2003
- Find item in a list relevant to a given label
- urgent - keyboard shortcut to re-size a form in vb?
- Using two equations in one cell
- Streamlining recorded code
- Data Entry VBA Form
- Excel should indicate an individual's birthday with color
- Group by syntax
- Worktickets to be saved
- Count 0-9
- Vba code for each loop
- Looping through columns
- flexible sheet reference in formula possible?
- How do automate a Macro?
- Creating a dynamic graph in excel 2010
- NETWORKDAYS Formula
- Generating all part numbers for a particular supplier?
- VBA SUM selected Value
- For Loops
- Find and replace with 1211 variables to check against
- Currency settings across a whole workbook
- 2nd Attempt: Auto color a cell and count based on multiple conditions.
- Inputting Individual Cell References into an Array
- increase cell by one every 5 rows etc
- updating multiple ranges
- I wish to make a pre-defined text box appear dependent on data entered in a cell
- Popup Box / If Statement?
- Listbox Values Extraction
- VBA loop - find help
- Counting With An If Statement
- open workbook and check whether worksheets exist
- Help please to remove row if cell empty
- Think I'm being silly
- Exit Edit Text from TextBox
- Faster if else statement
- Auto copy a row to another worksheet, then check the sheets for duplicates
- if state or vb to copy/paste a range of cells
- Using VBA when printing to include a "staple"
- Workbooks.OpenXML and xsl:include
- Sumproduct
- Macro to delete rows where Column Z has the value 'T' but leave column A
- Hidden File Names Visible in Backstage
- How often is my excel file opened?
- Counting the First of Repeated Values
- Formula to list unique values from 2 columns
- Quick VBA code help
- Repeating code a set number of times
- Identifying Duplicates that are not exactly the same
- Navigate to a Chart
- unique tooltip based on selection in a listbox (userforms)?
- SaveAs method not working properly
- vlookup formula
- search names...
- 'Object Required' VBA Error
- Break-up times
- What does this mean? =IF(AND(OR(T2=B2,T2=C2),A2>0),A2, IF(A2>0,6,IF(J2=0,-1,0)))
- Add Username
- Average 10 positive number
- Setting a range
- Code sorts but is slow
- Repeating Graphs
- A little complictated loop/find problem
- Number Formatting Issue
- Interest to be paid calculation help
- Formula to count Sales Accounts
- Combine text in multiple cells macro
- Reports to be split but on same spreadsheet
- Avg excluding 0's and grand total on Pivotable
- Need help with date identifiers
- Autosave after cell increment
- How can you create a pivot table that ignores "blank but not empty" cells?
- Duplicate declaration in current scope (deselecting all items in Pivot Table except one)
- workbook file size limit
- VB Code for Defined Name
- Retrieving HTML tags and attributes
- Macro to update #s based on amount selected
- AutoFilter VBA
- Max-Min Calculated Field?
- Copy sheets based on user entered number
- Pivot tables do not display
- CONCATENATE, TEXT(Date) INDIRECT, different Sheet
- Help with formula creation
- Comment Data
- Datavalidation
- VBA Specify where to place created chart - Last Row
- Task Pane - Disable in 2007
- Time log formula creation
- SUMIF,INDEX or Macro
- Value of cell in row based on last non-empty cell in another column
- Pull information excluding blanks and specific word
- Excel 2003 - VBA is there a way to add a color gradient to cells
- In-cell chart with a picture
- Two dates and text in one cell
- Run Macro from Ribbon X call back
- Graphing last row and select 3 over
- VBA code in PPT 2010
- Nested IF/OR Statement
- VBA to shows sheets if condition met
- Right Click problem on protected sheet
- Suggestion for efficient posting
- Column Graph question
- Update Links Button
- Excel (visio?) Question
- Userform Validation
- Finding range of partial match hits
- VBA - Value lookups
- Delete all sheets after a certain sheet
- Excel on SharePoint - Count visitors
- Count Unique Values with Multiple Criteria
- Easy Excel question - paste visible cells Excel 2010
- Click here to bring up message box
- Save User Data in My Add-In
- Userform, finding referenced cell by category and date and adding value to worksheet.
- help in creating this macro/formula
- Help!! unprotect active workbooks
- Enable copy/paste doesn't copy
- Blank Dates out in a Workbook
- How do I accomplish this task?
- Subtracting Dates
- Problems with calling dll from vba
- Help with a logarithmic x-axis problem
- Need the current week Friday
- Adding a sheet reference to each range in a union
- Defined names after sort
- Pivot Tables - keeping columns and rows with no data
- Comparing one table of date ranges to another
- Formula for extracting the last part of a cell listing
- need to edit the field prior to writing to excel
- UserForms & Command Buttons
- Weited Avg exlcuding negative and zero value
- Add Picture to Image Control
- Find/Replace Info
- Insert Weekday Workbook Macro Amendment
- VBA excel to Outlook contact properties
- Embed Excel Workbook
- Is there any benefit from the leading "+" in =+A2+B2
- Macro with autofilter
- GUI'S and VBA Calculator
- Problem downloading/opening Excel file
- VBA/SQL query parameter from one specific column.
- Counting Days
- Copying cell contents
- Sort Function
- Return MIN value of all cells with certain text in cell to the left
- Find cell from combobox and write to referenced adjacent cell
- Simple Question
- NO Gridlines as my default in Excel
- gernerate random numbers 1 to 25
- Lat/Longs
- SUMIF and DATES
- Search column for value
- CountIf (Words) - Filter problem
- Replacing F2 & Enter Function
- Type mismatch error
- Decreasing Percentage Formula Question
- VBA help-Duplicate data
- I think I need a macro
- VBA - Array Trouble
- Exporting Worksheet Data to .CSV
- VBA find
- Cut and Paste from WSh1 to WSh2
- Array formula syntax
- If the text in b1,c1 or d1 is contained in a3, then enter the contained text from b1:d1 into b3
- VBA top border on row based on row number
- color part of string only
- Return value with multiple conditions.
- Unreadable content fix
- Pivot Table question
- Extract Last Number in Text String
- helping scaling down small code...
- Copy determined columns from source sheet to destination sheet in particular order
- how can I check the excel compatibility in VBA
- Error File Not Found olepro32.dll
- Help - asap
- Excel Chart - Time in X-axis
- How do you drag cells in excel to auto fill formulas when you want to change from horizontal to vertical
- Simple Create Line Graph using VBA
- VBA - Compare the data across different sheets and put into one sheet
- Ranking based on number frequency
- Sumproduct or something else? (Excel 2003)
- Formula and function help required urgently
- Help adding multiple email addresses by clicking cells
- Match Function with "<=" as the match type
- Retrieving filename and changing format
- Create next value in sequence IF number match
- Transpose data from Horizontal to vertical
- How to use Option Buttons without a Command button too?
- Importing a text document and not enough columns
- function frequency
- formula help (just not sure what ALL help)
- compare values from same columns in different sheet
- VBA code that deducts a qty by cell ref on multiple sheets
- Open Extra Attachmate from excel vba
- VBA selecting cell within a matrix
- excel chart update
- link work sheets
- Formulas
- Improve the coal face efficiency
- HTML Macro Assistance Required.
- Improve the coal face efficiency
- Code to "match" & "paste"..
- Calculate Accelerated Depreciation Value without Circular Reference
- Report File Size in Excel
- Deleting a file from VBA
- In need of a vlookup/VB script please
- formula or vba needed ?
- Performance question - retrieving file's modified date
- Sorting dates in a listbox
- Pivot Table and Macro. Row disapear.
- Find a string within the value characters
- VBA Error - Object not supported
- Disable a macro button in Private Sub Workbook_Open()
- Selecting a range
- Dynamic range over several columns
- copy rows to worksheet if col = x
- Compare date within 2 sheet
- vlookup throwing wrong results
- Sum the total value for each row at that column
- Not on screen but in print
- Locate CSV file with Open File msg box and Import Columns from CSV to worksheet
- Stuck on this at work please help :)
- COUNTIF/SUMIF Query
- Conditional Formatting on two columns to ignore *
- Several Toggle Buttons that conflict on De-selection
- Conditional Formatting - If first Character is Zero
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.