View Full Version : Excel Questions
- Search Query
- Pivot Table Help
- subtotals
- Advanced Filter - Criteria Masking
- Help on a formula
- check file is in use, Then
- How do you delete event proc with codemodule?
- Sort Problem
- pulling info from previous sheet to current with ever changing current sheet
- Using Index & Match?
- averaging formula help
- Compund returns for certain date
- Unpredictable userform errors
- ADO to read from excel file; ignores locked file??
- Sum unique items
- Date changes on Figure when pasting to Word
- Find Duplicates based on 3 criteria using Office 2003
- Macro Error 1004: Application-defined or object-defined error
- Trying to sum a cell when text or a "blank cell" is identified.
- Automatic updating Sheet1 to Sheet2 with Conditional Formatting
- Making a Macro to Generate a Report
- Add if a number is negative, Subtract if a number is positive
- Filter in VBA
- Assigning place values
- Pasting a value into a cell & concatenating with another constant value
- VLOOKUP looking in second column of table_array instead of first?
- undelimiting
- Lookpup value
- Copying horizontal formulas using raw data that runs vertically in increments
- Sheet Names are changing for Portuguese users
- file size way too large
- Indirect, lookup Sumif, formaula needed.
- Keep text box at bottom of worksheet
- Extracting data from a table
- Range Selection Question
- Calender in Excel
- IF statement in my macro- what am I missing?
- excel multiplication and sub total
- Trouble importing query results into Excel 2007 from Access
- Formula to split cell data
- Index match Search
- check if recipient list contains sender address
- Auto Email from Excel using VBA
- Reference cells from 3000 seperate PO.xls to single Workbook
- PLEASE HELP: Date Formula Glitch
- VBA cacro to find next conditionally highlighted cell
- Page setup footer date
- how to build this formula?
- URG. Please help with date formula question
- Rounding formula
- formula or VB to enter a date for the most recent payment received
- Data Validation List Character Limit Output
- if intersect else intersect
- Combine Rows
- How to calculate percentage from Pivot Table
- Macro to combine 4 worksheets into one worksheet
- Chart Copy, Activate and Change Data Source
- School Exam Grades
- Hiding data in graph axis
- LOOKUP type function with 2 different values
- Formating quiestion.
- Triggering vba from a cell contents
- One click to round the number to 100s ceiling
- Double quotes character string
- A better way of doing this vlookup?
- Need help, Please.
- Formatted sheet
- Conditional Formatting a range Based on Another cell
- VLOOKUP in MACRO
- Sub-total, Grand-total with dynamic Range - VBA
- Excel Goal Seek
- VBA with pivot table - reposting. please help!
- Need an expert
- Selecting conditionally formatted cells
- replace #NA with zero in Index/Match formula!!
- Creating a sliding scale
- Automating Excel Spreadsheet
- Newbie -How do you lock a range of cells to sum when shifting data?
- Extract duplicate records
- Format number in macro
- SQL Query
- using countifs in a large spreadsheet
- Insert options on chart sheet missing
- Formating numbers with symbol in a data in excel
- Paste from clipboard to visible cells
- Add the current time to the output of a function
- how do I keep date format when using =J5&" EDIT4 01" ?
- Conditional formatting for ranges that change
- How do you get the count of commandbuttons on a worksheet?
- Insert column alternately
- Difficulty: Running macro in pw protected worksheet
- reference from another sheet VBA
- Superscript and subscript
- Creating a form with macro's
- Horizontail to Vertical
- changing cell type to integer
- Workbook Name
- Open closed workbook and copy new datas all the way down.
- How to use MID or LEFT function
- turning list into pie chart
- Using a range specified in a single cell as a chart range (no VB please)
- Color index
- Create Trouble Report
- formula from workbook to another
- Mismatch 13 error using Multiple Sort macro
- VBA - Folder relative name question
- Excel Macro
- need help: lookup multiple data!
- List Box does not take Rows input Range
- Compile error. Can't find project or library problem.
- Compile error. Can't find project or library problem.
- Calc Time
- Problem summing several variables quantities over inconsistent week lengths
- Same row with value on different column but count as one , how ?
- Phonebook dialoguebox
- Remove dots from text?
- Dependent Conditional Formatting
- Complex concatenation/string rearrangement
- automate a dependent list?
- Email sheet in excel with vba
- Help with interleaving 2 columns to 1 row with blank cells
- Multipage in combination with loadPicture
- Print every tab which is a chart (or everything but 'data')
- AutoCAD VBA functions not working in Excel VBA
- Oddity with ADODB
- Goal seek automatically for different row values
- Excel 2010 Fuzzy Lookup Add-in
- Traffic Light macro
- How to make sums for one or various criterias?
- Referencing a UserForm using a variable
- Help with date formula
- Protect Images
- shapes in excel VBA
- Find n replace
- sendkeys Shift
- word wrap in custom date formatting
- Exam grade conditional formatting
- Special Copy & Paste
- Random Formula Needed
- Nested IF statements
- Count of Charecters in a Cell
- Enable/Disable multitab pages based on matrix
- RefEdit with a color frame-type selecting tool
- Pivot table calculated fields
- How to control number of rows printed per page?
- SumIF help
- Print Formula
- VLookUp Two Possible Values
- 2 If formulas
- Retrieve Data from SQL Server
- clear cells
- Application-Defined or Object-Defined error run-time error
- Count If for Filtered cells
- Create relationship between sheets
- Prblems formatting an export
- Lock or fix conditional formatting?
- Drop down list
- Sending mail in lotus notes
- Formula not working
- Validating dates on forms
- SUMIF, does not distiguish between similar numbers
- Count Muliple Fields
- How do I read data off of a table like a dumbed down database
- Drag horizontally based on vertical data
- Analysing web log: need to calculate session times from interaction data
- VBA: Copy and Paste
- Opening Excel from Javascript
- User Forms Allow Tab Only to Move Between TextBoxes
- Dependant Validation List Question
- Protecting a range
- sum only certain cells
- Using radio buttons to allow user to select a pahse line (month)
- Vlookup for multiple values?
- Formatting of worksheets newly created by VBA.
- selecting letters from a word
- X Axis Date Labels from Pivot Chart
- VLOOKUP & MIN - need help
- How do I set up links w/ spaces in the name?
- Userform Issues
- Vlookup & countif?
- How to calculate # of days in a 30 month calendar
- worksheet change event issues
- User form Check boxes looping
- formula for growing range
- Employee, Key Performance, Spreadsheet
- Calendar Control
- Countifs
- Categorize 15000 numbers ranging from 32-6800
- "Excel cannot insert the sheets" error
- Excel - cant stop scrolling
- using AVERAGE on cells that may contain the #N/A error...???
- Vlookup, edit the result
- Insert Row If Cell = False
- VBA Compile Error: Next without For?
- Filter question
- Convert abbreviated month (Jan) to full Month (January)
- Macro to show missing numbers, Excel 2003
- Advanced Filter VBA
- Open Workbook as it's own Workbook macro
- Insert rows and formulas
- Numeric field
- Help w/VBA object interferring with Macro
- How can I amend this code to save WB in specific folder?
- If... Then with multiple actions; not working!
- Referencing Ranges Regularly
- Sumifs with multiple criteria
- Sumif woes
- VBA check for Sharepoint folder exists on one machine, doesn't exist on another (both have access to site)
- Allow change to text but do not allow insert/delete rows
- 2 Optionsbuttons how to write to cell
- Macor to update Chart Data Range
- Macro Stops
- Filter sort question
- Paste Values, Formats into new worksheet.
- Formula Help
- Rerun all functions
- Question about conditonal formatting!
- Disable then Enable Drag & Drop - on Open and Close...
- References to linked pictures
- Function to get selected slicer options.
- Extract Numbers from Cell Convert VLOOKUP formula to VBA?
- Open workbook but nothing appears
- To copy selected columns to another sheet
- Which is better for a search form - a popup User Form or a standard Worksheet?
- Add White Space to End of Text String
- Help with Defining Dynamic Range with VBA
- Grouping a column and finding count of each entry
- Name of Sheet in Formula??
- copy and paste macro
- On Error GoTo (Name)
- Average Formula based on year, month, day
- How do I fit IF(ISBLANK) into these formulas?
- Syntax ?
- How do I ensure data is entered as mm:ss.000
- Creating a new file and naming it with text and cell reference
- Is there anyway to automatically convert 1 into 1st, 2 into 2nd, and so on
- Variable length averages
- Combobox's In a Userform
- If/Then Print Selected Page
- Need Formula to calculate KPI score
- Copy local sheet to network book
- Conditional Format VBA question
- Enable userform controls based on single combo box validation of 3 ws values
- If error finding and saving to desktop path
- Conditional Formatting in a Chart
- Data Validation
- Programmatically Adding Buttons to a Worksheet
- Macro: Change chart source data without using Activate
- Grouping in Pivot Table
- Securing the Author
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.