View Full Version : Excel Questions
- SSN's and Hypens
- De Link the excel sheets
- A simple "If" function
- degrees minutes seconds to degrees.dec (w/ partial seconds)
- Separating excel table into separate worksheets
- Clear one cells content when changing another cell
- Automated Picture Entry
- OR function
- HELP- Need to search cells with text for keywords
- Search for text in column B then select row containing text
- Option Button Rating system using a form
- Remove shapes and multiple hyperlinks
- Formula Required for Date Identification_Reply
- File Reservation -- Can VBA close this error message?
- Help edit this line
- Clean up this code
- Looping through a user selected range?
- Error with IF fuction. What am I doing wrong?
- Print Multiple Ranges
- Password related with a specific date
- Find First and Last Row with a Given Year
- using time
- Need help with averaging some cells.
- Allow only a certain amount of numbers in a cell.
- Using IF multiple conditions and making other calculations.
- Form's
- For Each / Next with broken chain of numbers
- Quick date problem
- Discount 1 Cell % and £
- Conditional Formatting - I know I know!
- Having cell return name of tab
- Random Date Selector
- Evaluation of cell true/false condition in a macro
- 3rd Party Chart Software
- FORMULA FOR COMPARING MONTH AND YEAR
- Freezing columns and rows....at the same time
- Want zero to be displayed instead....your kind attention
- write protecting a worksheet
- Importing data into excel from unix server.
- tracking changes
- VBA - 1. Do not show screen 2. Hide rows under last data
- Delete all blank cells in an entire workbook?
- Convert Last Name, First Name to Last Name, First Initial
- Counting number of month
- Nested IF statements contingent on 2 cell text items
- Filter
- sort league table with text to the bottom
- Reporting (linking) from multiple spreadsheets, VBA Code
- Basic Lotus Notes commands in VBA
- Determine combinations to get a total
- Basic Question - Can you add a custom property to a userform
- Three Easy IFs ?
- Moving contents of cells to different cells
- Sum only positive numbers in a list
- Macro Error Message "Duplicate Data Entered In A List&a
- square tab character
- Using Vlookup to get multiple results
- File locked by user who's not logged in
- Error trying to set bubble sizes
- Help with a simple IF command
- Exasperating Formatting Problem
- code not working - search function
- Another cells question!
- Text over area
- finding a range with specified data
- Calculate Error "Calc"
- Converting Date & time Data in 2 diff colums to Date &am
- Saving worksheets as htm formatting problem
- Macro to add worksheets
- Range offset in VB
- CSV imports, parse "07/01" as text, not date
- Plotting Graphs - omitting x axis labels based on zero value
- Streamlining VBA Code
- Grouping By Cumulative Totals
- Please Help
- The E mail icon
- VBA - Look for a worksheet entitled
- If statments, Tough one
- Urgent Help from Brazil
- Control total
- Conditional Fromating problem
- When execute query, cells lost format ???
- I tried IsNull or IsEmpty but not working- Help!
- excel chiinv
- Arrayformulas and INDEX
- Import a .bas file into a specified workbook.
- non-zero numbers from an alphanumerical string
- if statment formulas
- Skip "Update links" msg using VBA
- Unevan payments in a loan
- Customising A List
- add to my formula
- Conditional Formatting
- Parsing Data from One Cell to Multiple Cells ++
- Sheet Recalculation Time zzzzzzzzzz
- multiple return vlookup
- Conditional Formatting help...
- entering "" in to a cell...
- How to populate mutiple workbook
- Help! Excel Gurus!! How can I simplify this mega-formula???
- How do you make a cell's value = to the worksheet name...
- using the results of one formula in another?
- Add text to a formula
- Need help with VBA
- Insert Row and Need to have it numbered.
- Validation
- Arrays
- Problem with Dates on the Y Axis
- Look for duplicates
- Protect worksheet macro
- Average Formula
- How to create list from another sheet
- Center align a cell based on the value?
- Match & Hlookup
- Showing only Unique values and exclude some using VBA
- Is there way...
- How to create list from another sheet
- Autocomplete cell text
- Macros not working when sheet is password protected
- Associate a word with a value?
- Display characters limit in a cell.
- Format and color question...
- Using Getpivotdata within VBA
- Counting occurances of dates, and badly need help!
- Create links to worksheets using hyperlinks
- Scrolling Table
- Pivot table help
- Cell value = tab name
- Setting an Application Free
- Add "x" if customer number matches a list...???
- auto copy using macro
- Solver not adding more than 5 constraints in VB
- Using If, Then And to write from checkbox to spread sheet
- Complex Sheet Integration and Chart
- count if argument
- IF THEN Question
- SUMIF Question
- Index and Match question
- Formula to find Quantity based off two different criteria
- Formula Rounding
- Color Shading Conditional Formatting
- Copying cell data from one sheet to another
- Merge from Excel to Email Problem
- Opening and Saving .txt Files from Excel
- Making pivot table without calculation
- VBA 'next cell to the right' help
- Using Excel with Multiple Users: Sharing Spreadsheets
- Selecting visible cells
- diminishing returns
- Filtering A List Without The Auto Filter
- macro problem
- Pretty basic Form Question
- IF Function Argument Limitations - how to get around it?
- Controlling Printform
- Pasting into cells (not ranges)
- Greater than or less than in same formula
- creating cutom menus using vba
- List only uniquely different records from source range
- Macro assistance: create unique string from worksheet values
- Display a message if there is a blank row between a range
- Day of week
- ListBox - format of numbers in column Data
- How to count a column of numbers without duplicates
- Function Problem
- On Error Goto Issues
- Stacking Data In A Cell
- Track changes with macros
- Find Cut and Paste VBA help
- VBA's Line Continuation Sequence
- Sumif in VBA
- Problems with a shared workbook
- Apply simple arithmatic formula to a range
- Y-axis Label cutoff problem on plots
- Using an Average Number
- Calculate an area from a contour chart?
- HOW DO YOU MAKE A FORMULA STOP AT A BLANK CELL?
- Pie Chart Issue
- Pivot Table Preferences/Options/Defaults
- Formula Help/ideas
- SOLVED macro & dbase and WHERE clause
- Modifying cell contents based on conditions
- List of functions by number
- Lookup_value: can it be a range???
- Hidden Sheet
- F9 error message
- Prevent Cell Selection
- Prevent Cell Selection
- How to combine multiple files in to one sheet
- Matching X-axis display with data in cells
- Linked Excel graphs in PowerPoint
- Finding Blank cells in any row across a range of cols
- Manipulating Chart on a different WorkSheet
- Date of birth
- Issue emailing workbooks containing formulas
- Anyone have source for silver/gold spot that can be queried
- "Nested" List Box (Based on Validation Box)
- Delete prior rows if SUBTOTAL equal zero.
- Open Close Individual Files
- not equal to
- Password protection
- Adding a carriage return or a linefeed to a formula
- Help. Merging multiple files in to one sheet
- Fortnightly and yearly tallies
- SUMIF FOR TEXT?
- link to another workbook showing formula instead of value
- Move down one row
- Force pop-up to be on top
- Report Consolidation
- match the content of a cell from a column of data
- intersection of date range and current month
- referencing a cell in a formula via a formula
- Round up time to just the hour
- Select every n'th sheet
- Select every n'th sheet
- Sending mail with lotus notes
- Function
- Multiplication then division and the result rounded
- Import Data to Worksheet
- Input Box
- Floating Timeline Stacked Charts
- Autofilter across multiple sheets in a workbook
- Command Bar Run time Error '5'
- Exel Challenge! Categorise time by month AND by request.
- how 2 show a blank entry screen during new data entry
- When cell clicked, stays "clicked", highlights all
- formatting changes
- CONCATENATE TEXT AND DATE
- VB Code for saving a workbook with duplication prevention
- Copying Long Rows in Excel
- Help on leaving cell blank when formula refers to blank cell
- Calculate IRR & NPV
- Linking a dropdown to a value?
- Tools Menu disabled
- Add macro to Xl-file
- Creating an entry by extracting data from a cell
- CHALLENGE -- can it be done < export VB code>
- Overwrite a pop up coming up....
- Listing name and path of saved workbooks
- Run code on all sheets, except 5 sheets.
- Change Cells Colour: Range Error (Solved almost)
- problem when moving a sheet in VB to another workbook
- VBA mid string pick up variable definition
- Duplicate Records??????
- Duplicate Records????????????????????
- FreezePanes, multiple rows
- Formula Problems
- Limit the user input to zeros and ones?
- find out who is logged on to the computer
- Multiple Cell Selection
- Look-up and Insert Row
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.