View Full Version : Excel Questions
- Formula Knows Username
- permanently filter out cases and analyse data on a case-by-case basis
- Changing Destination of Rows
- Automatically updating data from one file to another
- Copy formatting when referancing another cell
- Excel Crashes in Pivot Tables
- Excel Cannot complete this task
- countif ( and
- Data will not refresh
- Sheet Designed with shapes in HTML Style
- Help with a complicated problem in calculating data inside Pivot Tables!
- Date picker questions
- Excel Deletes previous contents of cell when it is activated
- Hiding "#N/A" on VLOOKUP
- Unique Data Extract from a Filtered List
- Advanced Conditional Formatting
- Help with code: Excel to HTML
- conditional formatting and change tracking in excel
- Border Macro Needed
- sorting by last position, not first
- Find user name for VBA
- Formatting a Cell base on a lookup table
- Dynamic watermark/background image
- Delete Complete Row Based on Matching Cell
- Pivot table data gaps
- Index Match Help
- On Close Code
- Shared workbook and macro
- Help with vlookup?
- Pulling a specific amount based on two variables
- VBA to colour Cells...
- A "Good" Process Bar
- Combining a SUM & TEXT formula
- Dynamic Calendar
- Is it possible to "join" two workbooks to compare data?
- VBA Average Calculation after userform input
- Adding "SUBJECT" to Email hyperlink
- COM Add-ins dialog: custom CommandBarButton
- Set default zoom size when workbook is open
- WorkSheet_Change Array
- VBA runtime error when sorting Listobject
- Case Statement Help
- If, then help needed with matching please
- Sum a row starting at match in another row
- Check to see if cell has certain conditional format using VBA
- Test on sheets names
- need help not good with excel
- formatting comments, vba, next line?
- Unable to set coloumnWidth property of range class
- Extract data problem
- Freeform Shape and Excel 2007
- If Then Else Formula?
- Errors - Erl() always line#0 how to troubleshoot? fine source of error?
- Compare One Cell To Mupltiple Columns
- second lookup help
- In VBA, check if first letter is capitalized (urgent)
- Assigning macro to checkbox without using the checkbox's name
- permutation problem
- Need Excel Expert.
- combine worksheets
- Formula needed - Matching numbers & calculating
- School Grades spreadsheet
- =If with other functions
- Random Results From Gambling Strategy, Expected Value/Growth?
- date ranges and multiple string equations
- .Copy Destination:= and pastespecial
- freeze rows
- Run-time error 13
- Remove blank array elements so list doesn't have blank rows
- Pivot & Remove Duplicate cell over multi columns
- Command Button to transfer data
- Date Display
- Formula requirement
- Can't precisely set chart size in Excel 2007, are you kidding??
- Copy data into new sheet, and link that data to old sheet.
- Indirect Formula Ref#
- Vlookup with condition
- code to rename sheets
- VBA search blanks error
- Links inside a word document which is embedded in an excel doc.
- VBA Calendar
- Outlook Reminder
- Macro to display sheets names
- If/Then Statement - do nothing
- Create new worksheet based on a template and criteria
- Problem with formula
- Criteria match
- problems with formula for columns
- text box calculations
- Problem
- How to use Goal-Seek or Solver automatically
- Find a cell value in last sheet.
- macro save worksheet as pdf with same workbook filename and location
- Insert Image & Keep Image Name
- using macros to permanently filter duplicate data...
- Recordind date when cell data changed
- Either or formula?
- VBA Tricky populate unique values to listbox
- Reminder creation in excel
- VBA code for calculation time advancement bar
- Type Mismatch - Am I going insane?!
- Vlookup
- Freeze Pane Line From VBA
- Make a formula out of text
- Whats wrong with this chart ?!
- Adding Elements to ListBox
- Fill Right not increasing Column Value
- Formulas
- Excel 2007 Filtering Coluams
- Note Pad to Excel
- UserForm Close Button
- Manual Calculation
- SQL Query Parameters
- Counting number of dates within a date range
- named ranges problems
- Compare lists
- Limit Scroll area error for different screens
- Large Cell Issue
- Mrs
- data from 3 different file into one sheet
- Enable micros in excel 2007
- Calling an xla from macro
- Inserting Flash in Office2007
- Select a dataset and arranging it to generate a graph
- Logical formaulas please help..
- Short cut to remove colour??
- elp with counting the number of rows matching 2 criteria please
- VBA Compare list in 2 columns
- insert new rows below the data
- Path
- Need to replace last digit with character
- Compare 2 sheet
- Questionary macro
- msoShapeRectangle background image as another shape object in the workbook
- Set a Range from a Worksheet Formula
- Import and Add with a With?
- Check character No.x in a string is "A"
- How to make appear a cell value in user form ?
- Open Source et al.
- Colour alert in excel after a date??
- Array Formula Help Please...
- Only The yellow please
- Auto Fill
- IF & Lookup help
- Extract data from a folder of spreadsheets
- Weird User-Defined Function Problem
- If then with and or criteria formula help
- Separate an address string into parts using VBA
- Paste from clipboard to active browser
- VBA: How to start a list from the top
- Get Range from Cell Value in VBA
- Range naming question
- Highlight Row
- Fixing formulas when inserting columns
- Clear Cell Contents based on Cell Value
- Phantom Formatting Ruining My Formula Results
- Sort Dates...entered using a custom format
- sum different number of cells in a column until the sum equals a fixed value
- EXTRACT, MID, Find,
- Keep cell formatting after sort
- Trying to Improve my Formulas...
- Excel Header & Footer
- How do I sum multiple occurances of same value
- Changing or, rounding numbers to a specific Number, making .5 to .3
- Use Solver to solve maultiple equations in VBA
- Replacing Strings with VBA
- Need a simple formula
- Separating numbers from text
- Moving a worksheet object after last...
- Sumproduct with criteria
- Need Code to Copy Paste Based on Des.
- Find previous occurrence of a text string, not last (VBA)
- Change Number Formats
- Match With Condition.
- Information Box
- Questions About Pivot Graphs
- Use Cell Value Sheet Reference for sum function
- Going Slightly Nuts!
- Sort wont hold on formula column after external data refresh
- Average Times based on Day of Week
- type mismatch: runtime error 13 vba
- Pictures to chart depending on criteria
- calling a macro using a string variable
- Macro to copy paste based on description?
- XML import problem
- Interior Color Index
- Input Box with 3 Buttons
- how can VLOOKUP return multi-columns?
- Conditional Formatting
- makro
- Suggested VBA Code To Minimize Pivot Data
- Selecting Specialcells in all sheets
- VBA Collection Object Question
- Summarizing stat totals across 10 different sheets
- Consecutive Minimum Values?
- Userform opens with black background only for one user
- 2 Added to Pivot Table Data
- split cell postcode
- Validation Loop
- Can't get listbox which displays rows in sheet to add texbox value to selected row
- Macro to find low numbers but there may be dups
- Simple Change in Code
- Fischer's Exact Test Formula
- Inserting row after change in date
- Data validation/Auto filter
- calculate profit/loss
- Pivot table filter
- Sum/Avg Values from multiple sheets into 1 totals sheet
- Substituting data in irregular pattern
- Pivot Table- Multiple Column Fields
- please help macro fans!
- IF calculation help
- IF Then with multiple criteria
- Can Excel be made secure?
- Formula Edit help
- Formula for time ranges
- excel formula
- Please edit this macro for me...thanks everyone!
- Sumproduct datatype error
- Dynamic Graphing - I'm stumped
- Find today's date between two dates return cell info
- Using Firefox for HTML
- Run Marco
- Range issues with ADO
- Add WS Names to Dropdown box
- Hiding Entire Rows based on first Cell Value
- Combinations to get a desired number from a given set of numbers
- Creating a range based on an outline objet
- list name driven off a specific cell
- VBA macro for generating all combinations from 5 lists
- Add to PrintOut function to specify layout, paper size, etc.
- I just want to select one cell
- Need a pro!
- Using split function in vba
- Best way to Categorize data?
- formula for +- range not working
- Break Chart Link To Data Source
- New line character
- Hyperlink to Cell on another sheet
- VBA to compare colomn data
- If any cell in column "X" has a value of $1,000 or more, and the value in column "Y" says "No", highlight the cell in column "X" red.
- Steps for creating custom buttons on custom toolbar
- Hiding Cell Range
- Merging Data with Similar Entries
- Excel / Word link in VBA....?
- VBA Create Folder in Lotus Notes
- Month Sort of OLAP Cube Pivot Table Labels
- Hiding columns based on cell values
- Consolidate help
- Matching and replacing data in two spreadsheets using VBA
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.