View Full Version : Excel Questions
- Can DSUM's criteria option use non-contiguous blocks?
- How can i protect the excel file with system login id and password by vba Code---
- Find a character in a cell and copy row contents to a new row
- Fill down formula when row inserted
- Clear duplicates in selection
- Variances within a pivot table
- Data Validation - Must be of a certain age
- Column A = "text1^text2^text3". How to make Columns B = text1, Column C = text2, Column D = text3?
- Sum over a range
- AUto Update
- Code not working
- How do I enable Toggle Macro when sheets are protected
- Slow UserForm
- Graphical editor for excel shapes
- User form issue
- Advanced Filter via Macro Button
- Scrolling graph
- Pivot Tables VBA
- Return Array from Index/Match?
- TAG to select the oldest data in a table
- How to delete rows if 2 columns contain same text
- Delete sheets hidden sheets in a loop
- Range designation
- Conditional Formatting for Dashboards
- Enabling Macros
- data column editing - need help
- Formula/Code Help (Unique Combo)
- Copy only filtered values
- Selecting objects
- SORT problem
- Identifying 2 ranges
- Problem with Excel Worksheet Protection
- Data extraction error - enter a specific number into excel if data to be extracted from site doesnt exist
- converting grams to pounds and ounces
- Formula help
- Problems download web table into excel
- Return a blank value if negative number
- Userform caption error
- Copying Charts
- Emailing range not working
- Stacked graph that doesn't add amounts
- A MAcro to Send a mail from Excel
- Referencing another workbook vba
- Count all cells that have a specific color and Letter
- Please help me change the critiria of filtering :) Thanks
- Fast Formula Needed (Frequency?)
- Using \ in format
- Code only works sometimes
- Need Concatenate formula based on Condition
- Lookup Help
- Advance Filter Column Split by Blank Row
- Automatically create Hyperlinks based upon links
- Equations in excel
- HELP - Job at stake !
- Vlookup or VB code help
- Script for adding a predetermined range
- Delete row if Mid 4 characters of cell equal text
- UserForm Issue when following link
- Simplify a If Statement
- Macro to reference an already opened file
- IF / AND formula help.
- Conditional formatting to get negative value
- VB Error 400
- UDF argument info
- Modify a Macro to only Copy a Range of Columns
- How to change color of "Diagonal Stripe 2" from "basic shapes" by value of a cell.
- embedded cell filter not working.
- Can someone explain ReDim?
- Protect Macro Sheet Info
- Please check my code. Getting runtime error 9. Subcript out of range
- Ranking Text
- Help with a formula
- Is there a more efficient way
- Min, Max and Average help
- If statement with date
- Protection
- Showing dates in Pivot even when no data
- Counting Even-Odd Numbers that are Less (or More) than a Certain Value
- converting date to formatted string in VBA?
- Extract text files into an excel sheet with position dependant on name
- VLOOKP or filter - help
- Creating a set of files via range of cell data
- Countif Forumals
- IF Formula help needed PLZ! ;.)
- Nested IF statement with multiple OR conditions
- Adding a Macro to an existing Macro
- Check Box
- multiple conditions
- Sort Items in Pivot Field List
- Help with Excel VBA project using a folder of text files as relational database
- macros returning "[EXTRACT]" instead of data
- If(Len problem or known bug
- Excel automation of Internet Explorer
- Need Help. Not sure what formulas to use
- Convert a =Sumproduct formula to a =Countifs
- Yes/No
- =NOW() v.2003 issue
- Sorting columns
- count function
- COUNTIFS - how to link range name to cell value?
- Update Sheet
- setting multiple filters
- copy formula in front of dinamic data
- Creating a range from a list in VBA?
- Returning a value from a formula
- Need help on simple macro
- auto poppulating the adjacent cell
- Macro to insert a column
- Sumproduct
- VBA scroll bar questions
- Can you combine YEAR plus COUNTIF or SUMPRODUCT functions into one conditional formula?
- how to trigger excel to populate into a cell IF x and y happens?
- status bar not displaying
- Sum Colored cells.
- Date picker initiate
- Subscript out of range
- Code Error for set myrange
- SUMIF, but adding the difference?
- Summarize Information from Multiple Worksheets
- Insert a row in alternative and update some txt on that using macro
- code error
- focus on last item in a list
- Loop thru Worksheet
- Can I change this??
- How do you refer to Embedded Controls in a Worksheet
- Borderlines to End of Text
- There's got to be an easier way
- Double Condition: what code to use?
- Text Manipulation
- Sum matching rows
- Get data from closed workbook
- Holiday Question
- Excel chart plotting, depending on weightage
- VBA Search
- auto updation without openign the source file
- Protecting Data
- Need help writing AppleScript in Excel!
- Summing values within a date range
- Can I change the label for a graph in Excel 2010?
- camera tool and draw order
- Multiple If Statements
- Countif?
- Multiple Column Groups
- Basic Question Re Macro AutoFill
- V Lookup Sum Help
- date formula help
- Find and Replace Macro
- sort
- Excel 2007, modify right mouse button
- Calculate Event Macro
- Easy Macro But Cannot Figure It Out
- excel 2003 file automatically converted to html
- Display Row Macro
- IF Formula With Criteria
- Excel Random Numbers Help
- selecting range for average after filtering
- Time Sheet - Night Shift?
- review time and associate a letter in a different column
- Error:You've entered too many arguments
- Dynamic Chart X Axis Labels incorrect
- excel question
- Vlookup for multiple check
- Ignoring #DIV/0! Error
- How is the workbook being closed ?
- Require important help i have made it 90 % but now please lookat this...
- Macro to Replace a worksheet in a workbook
- FIND/MID help!
- Dragging formula in VBA depending on the month
- Conditional Formating in excel 2007
- Default settings for all files
- Problem When Creating A Multiple Series Chart
- Using SUMPRODUCT with variables...
- Displaying only a Part of a worksheet
- Concatenate printareas
- Master Tabs
- Combine dynamic range chart and scroll chart
- Formatting Confusion
- please solve this help me
- Read lotus email with VBA macro
- Search Column A for the first instance of a word in Column B and display in Column C.
- Copy / pasting conditional formatting only
- How to add cells in column J & K is cell in column L= "Lost"
- Opening a new document with a password
- differing colum references
- Spreadsheet security
- Add active control image, depending on cell
- SumProduct Issue
- Quick & Easy If You Know
- sticking different codes togeather
- Looking for a CTRL+F type code as a cell
- Help modifying code..
- SaveCopyAs not working [Excel 2007]
- test if value is present in range
- Sorting page items in Excel 2007 Pivot
- Access Queries
- end if compile error
- Template Wizard with Data Tracking (TW)
- Countproduct ?
- Stacked column Chart
- Count unique phrase and other problems
- Using Macros in E2003 to hide random worksheets
- Create PDF file
- slight problem with this code
- Pivot table - Values
- Search and extract text from PDF to XL
- Importing external data inserts date not data
- VBA Conditional Formatting - colour
- Hex Codes, CCR Flags
- Auto Filter : Criteria is a variable
- SUMPRODUCT Help
- Auto insert rows
- =IF statement help
- Merging from multiple workbooks to one master list
- here is my file that show material receipt note i have made
- Comments or Footnotes in Excel?
- VBA help
- with selection versus not code issue
- ***HELP ! Most frequent reason based on 2 criteria***
- How to lookup and match multiple cells in a row
- Search for data by Date
- match 2 criteria returns 0 instead of ""
- Need a click on a cell to truger macro. Please help. Need help urgerntly. Thanks again
- Using VBA for Telnet
- Return text value from Col A, based on Rank From Col B
- Calculating the Difference between two date and time values
- Excel formatting cells and Outlook
- add together odd numbered cells in column, only if even numbered cells contain value greater than 0?
- Recording an answer to other worksheets
- Text Box Linking Problem
- URGENT**avoiding #DIV in array formulas**
- vLookup #Value error
- Supressing error in SumIf
- Macro for Random Sort
- Process in small steps
- F Key and Input Box
- Any way to make RIGHT or LEFT start at a space?
- Extracting start row from chart formula/data reference
- AdvancedFilter freezes UserForm
- Copying auto sum
- Use VB to copy NamedLists to UserForm
- Calculating Total Cost of a Contract Period
- VBA to merge cells
- Need a macro guru ...
- Counting Characters
- Fixed length file - field length
- Litres Per Hour
- Vba help plleeeasasaseeee!!
- Dynamic Validation list with ROW()
- Multiple IF AND formula
- Using AND and OR together in VBA
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.