View Full Version : Microsoft Excel Misc
- Clarification to previous question
- Re: Finding last value in a column
- Re: Finding last value in a column
- if zero
- Chart - Gauge like Speedometer
- code for text to columns
- Excel Merging Two Reports - Similar Fields, Different Values Question
- allow users to edit Excel over the web
- formatting problem on imported data
- Data Validation with repeaters excluded from the source list
- vlookup and text
- Auto fill criteria/questions on filling formulas down
- prompt to display password when accessing DB2 database
- Excel error message - #VALUE!
- "Remote" filtering
- Re: Format problems, of strange nature
- Need to suppress chart error message
- Select a random value from a column of values
- Viruses - Tom Ogilvy
- Excell Errors
- Whacky Cell Number Calculation
- Clarify Sorting
- Re: Help! Is it TEXT or VALUES?!
- Merging 2 files
- Getting rid of #value
- Bulleted list in excel
- Column and Row reference
- Linking worksheets in Excel
- shortcut ket to change formatting of text
- Calculate a Grand Total
- Re: Qualifier on Call
- Unique records
- Behaviour of headers
- How do i make a variable part of a formula
- Excel Question
- ÈÓã Çááå ÇáÑÍãä ÇáÑÍíã
- Last Number in Cell
- How to stop help from poping up
- Printing a long userform
- Function "IF"
- Cells format
- how to stop scrolling
- Converting negative date values
- lock xl file with pass
- sumif formula
- Unique records from a range
- linking documents so that one change n the other follows
- Statistics on Excel
- Link One File With Another
- conditional shading?
- Many IF function in a cell?
- email drop down
- round and ceiling
- auto fill formulas
- Excel Vba - Userform combobox problem
- Timesheet problem
- Pivot tables
- excel - Text to Voice
- Multiple Output from Listbox
- Re: Setting the opening document
- IF statement
- Re: Setting the opening document
- Emailing Reports
- Re: Help! Is it TEXT or VALUES?!
- row delete
- Re: how do you copy and paste the value displayed not the whole value
- Autofilter
- Excel Formula's
- Excel Formula's
- Excel Formula's
- External Links
- Excel Based Directory of WiFI Hotspots
- cell shading
- Re: how do you copy and paste the value displayed not the whole value
- Shared Workbook and Taskbar Behavior
- Searching (Find) in Merged Cells
- Column Header that moves with Data?
- Changing text automatically
- Printing Command Buttons
- help in excel
- Need help! Message--MEMORY COULD NOT BE READ
- Macros
- Adjusting column width
- Error sending Excel worksheet as an attachment
- Worksheet function--Compounded Growth Rate?
- Auto Date Population
- How to create a dropdown list that contains filtered values
- Macros on Excel
- Re: How to create a dropdown list that contains filtered values
- add-ins toolbar
- Re: Macros on Excel
- Printing Headers
- selecting and deselecting rows
- Sum Product Question
- Excel won't completely open
- General questions/worksheet functions
- Re: Adding Like Numbers in code
- Re: Adding Like Numbers in code
- Re: Adding Like Numbers in Code
- Re: Turn Text upside down
- Re: #value (for array formula)
- Re: Turn Text upside down
- Re: Adding Like Numbers in code
- Re: Can't see or edit column A but it prints- where is it?
- Re: Need help formatting rows of text within a single cell
- Need help formatting rows of text within a single cell
- Re: Can't see or edit column A but it prints- where is it?
- Re: #value (for array formula)
- Re: replacing asterisks
- Overwrite a protected Formula
- Re: replacing asterisks
- need smaller right/left header margins
- replacing asterisks
- Counting
- Good Looking? Want to Make Cash Fast? 460
- Re: Version compatibility
- Absolute address for Indirect function
- linking Excel table to word
- Re: Variable in Workbook_Open
- Re: excel
- date formatting
- shrinking my excel file
- ROUTING
- Permenantly Hiding Columns
- VLOOKUP Formula Question
- hyperlinks - file location - can I change it
- Excel Printing
- copy data validations from 2000 to 2003
- Re: showing data entries from two cells in one cell
- Multiuser accessibility
- Double Click
- File Folder labels printing
- saving Excel custom workbook as template
- Re: showing data entries from two cells in one cell
- Basic Looping Question
- csv into excel education
- Re: #VALUE ERROR
- Re: showing data entries from two cells in one cell
- Adding values in multiple columns matching some criteria
- Condtional formatting and cell refrence?
- Criteria and Autofilter
- CountIf on 2 columns
- Hyperlink too long
- read only hyperlink hangs up system
- Linking worksheets (ex. =sheet1!B2)
- Sum Value If Corresponding Column Meet Criteria
- Formula Question?
- Re: Scheduling Macros to Run
- Re: List Box Feed
- Re: Pivot tables-multiple consolidation ranges
- SORT COLUMNS
- DON'T PASTE IN HIDDEN COLUMNS
- Re: User's license for Microsoft Office XP for students and teachers-2002
- print error
- array formula for IF statement?
- ED50 to WGS84 coordinate conversion in excel?
- conditional formatting limitation
- Removing records
- Providing help for excel applications
- Lookup formats
- Excel Icon changed to different Graphic
- Data validation failures
- Excel Function VLOOKUP - ARRAY Function Error
- Excel - "window option" items in Tools/Options were dim - how to recover ???
- removing blanks
- Average & blank cells
- values can't be input into cell in Excel 2003
- Nested ifs
- Mixing Excel and Powerpoint in a macro
- Trend Lines
- Updating cells from values in a second workbook
- macro help
- Subtotal- plz help me
- Defining Print Ranges From Pivot Tables
- VBA - using command button to copy userform text boxes to excel spreadsheet
- Using Find for a wildcard
- Comparing two lists?
- Concatenate with mixed cell formats
- make a quickjump
- Problem with If statement
- Set row header?
- macro protection
- macro protection
- combobox copy
- VLookup "#N/A" message
- Select sheet to print from a drop down box
- Merging data from Excel into Outlook
- Excel drop down lists
- replace function for multiple sheets
- Excel CountIF Function
- Can't Delete Excel Rows
- mph in excel
- Re-calculation
- changing default browser used by Excel
- Sort Names -- Names, Sort
- Re: Sort Names -- Names, Sort
- Conditional Formatting
- RE: Sort Names -- Names, Sort
- Unable to delete Rows in Excel
- Two different print previews on two differnt operating systems.
- Attaching an attachment using a certain location
- Re: Save prompt when closing an unchanged workbook
- Re: Save prompt on unchanged workbooks
- comment box with date
- Re: Unique Column Formatting
- Visual Basic Error 400
- Re: Unique Column Formatting
- Lookup Problem
- Two different values in a single cell...
- next line in macros
- Re: Formula Help!!!!
- Paste as Text option is missing...help
- Re: convert text to number
- Re: record "count"
- Message requesting to Enable or Disable Excel Macros
- Re: Formula Help!!!!
- Re: Won't accept date format
- fractional pennies
- Rows to Repeat at Top
- Run a macro when cell value changes
- Date/Serial Number
- Lookup with a couple of variables
- Display standard time without "AM or PM" while entering in military time
- text to column code / invalid syntax
- Re: Copying JUST the filtered rows
- Hyperlnk to a cd-rom folder
- Re: Copying JUST the filtered rows
- Excel data merged to PDF form
- Macro to select & autofill adjacent cells
- header-
- Re: Copying JUST the filtered rows
- Scrub file part 2
- Summing Just the Visible Cells
- Convert devimal to number format
- Need Formula that Works
- Excel Worksheet Formula Question
- how to disable cell printing
- record "count"
- Right click menu gone?
- Conditonal Formatting
- macros in excel 2000
- Bordering issue- master or apply all?
- How do I find Non-Intersection of 2 Columns?
- What is this little box on my worksheet?
- Re: Formula Help
- Re: Formula Help
- Re: please help the intern!
- Excel Macros
- Inverting the contents of a column question
- Re: please help the intern!
- Auto Filter problem
- Re: Converting columns to rows for mail merge
- Duplex printing separate worksheets in the same workbook
- Million fractions!
- vba help
- Re: Protect a Template?
- Set up for table to calculate "who owes what to who?"
- Re: Protect a Template?
- Format column - problem
- File Error: Data may have been lost
- How to return to current worksheet in a macro
- Re: Converting columns to rows for mail merge
- Re: Protect a Template?
- Wrapping Text to next cell?
- email by rows
- Excel e-mails twice
- Re: [Group] in workbook title
- Column Number of active cell
- find function
- Weird Things Happening w/Excel2003
- Re: parenthesis
- To write formulas in cells using VBA
- Re: parenthesis
- Re: macros function
- Re: Assign cell value
- Re: Replaced File
- Re: parenthesis
- FIND function with multi criteria
- Function
- Macro question
- Pivot Table Custom Subtotals
- Recordset for graph data
- Re: Converting columns to rows for mail merge
- Multiple Conditions Formula Help Needed
- problem converting delimited text to Excel
- Conditional Format
- Dynamic sorting of rows of data.
- Using Queried Data alongside Manually entered data
- .xyz files
- Re: Sort Names -- Names, Sort
- Auto Save Window
- after hitting enter
- how to count cells with equal sign
- Uncollapse Grouped Rows on a Proctected worksheet
- How to compares sets of numbers
- Charting help
- Spinner Control in a Protected Worksheet
- Old Org Charts
- small printer
- How do you automatically record a revision date
- Re: Creating a pivot table for text data
- Re: Piviot Tables
- hidden/unintentional macros ?
- Inserting Rows
- Word to Excell2000 macro help
- Adding sum of text
- Shift to end of column
- IF-if the arguement is false don't return anything
- Cell with email address
- how do i autofill with, such that it has the last day of the month..
- Embed Sheet
- Extracting Email Addresses
- speech marks in VB formula
- can you help?
- using ROW in a formula
- Creating Multiple Worksheets From A Single Sheet
- MS Query - change parameter with Excel cell
- saving in sequential numbering i.e 1,2 3 etc or by date/time?
- need formula for multiple columns/rows
- Complex Network Days function & Time - Help please
- Excel Opens 2 files, I only created one?
- validating dates?
- Read Only
- Sumif / Countif Problem
- MS Query - Parameter Bug
- Table calculating multiple project hours by multiple employees
- merge or combine columns
- date or text
- Missing Excel outline
- Comparing Text in adjacent columns
- copy and paste produces a screen shot
- Startup with a Macro
- Keeping text formatting when referencing a text cell
- Re: Keeping text formatting when referencing a text cell
- change default margins
- Date Calculations
- Re: Alphabetize worksheets?
- Calculating a Date in Excel
- Filter mode Count
- Re: Alphabetize worksheets?
- Can I create a function in Excel?
- Re: Visual Aid in Excell
- attaching active worksheet to vb form
- Re: Osama Found Hanged
- Width & font of cell row/column headings
- "No more new fonts may be..."
- Sorting blank and non blank column of data
- value updates
- Using Excel With MailMerge?
- Conditional Formatting
- Re: Excel Recalculate Mystery
- Page layouts on one worksheet
- Re: /P Startup Switch in Excel 2000
- Excel TextBox Question
- Conditional Formatting
- Re: Date Formatting
- Sudden jump in file size
- Drop Down Box
- Using AutoSort to look the same date for multiple years
- data merge
- Cell selection - unselect
- Leading zeroes
- Bordering multiple pages in a sheet?
- Rounding
- Add Comment To Custom Sub-Menu
- Re: Changing the abc column headings
- Re: Changing the abc column headings
- Re: column names
- Unprotect Sheet” selection is grayed out on a shared doc
- selection is grayed out on a shared doc
- Re: column names
- Excel - selection is grayed out on a shared doc
- Re: enabling macros automatically
- Conditional Formatting
- save protection
- Use Excel for my home budget
- sum of blank and non blank
- Re: Alphabetize worksheets?
- Auto Save Add in
- sort info from a row base on a single cell value
- Expression for Conditional Formatting
- Re: Expression for Conditional Formatting
- Re: Error
- Re: Sum of products
- Re: Expression for Conditional Formatting
- Re: Sum of products
- print
- Openeing Excel File in New Window
- Creating a list
- help with lookup or something else
- Define name box size too small for viewing large formulas
- Removing Buttons
- Turn on Edit option in Combo Box
- Finding Links
- Excel: Can I extend the amount of characters in a text box?
- Doing a Query - using Excel - changing source file
- saving as .CSV file
- Pivot Table Formatting
- formula or function help
- Excel settings saved with file
- Re: Whole and Decimal figures
- Excell date formating
- Re: date conditional formatting
- Upgraded for 2000 pro to 2003 pro
- Pivot Table Field Name
- how to nest several functions together
- Checkbox color
- formula problem
- No "Edit" button in macro screen.
- Re: Excel Recalculate Mystery
- Watermarks in Excel
- Re: Limit repeat row to certain pages
- automatically insert a row below the one that's being edited
- Quickly locating duplicate records
- Re: Calculating Area of Scanned Image
- Macro triggered when Data is changed and worksheet is deselected
- "Fax recipient" missing the 'command' box
- Pasting large amount of text into a single cell
- Hyperlinks.Delete without losing formatting?
- Rounding numbers up or down
- zeros/"value" in cells messing my charts
- time and curency
- messy formula
- formula finding price based on volume bracket
- every other wednesday
- whats the best way do a link to pivot table data.
- Combo box
- Spinner Control and Protected Worksheet
- Email a single Worksheet
- Small numbers are labeled as Zeros
- By VBA, How to know User has selected one or several entire rows orther than some c
- test
- Assinging Range to mulitple selected cells?
- unable typing due to document locked for edit
- Restrict Scroll Area
- excel online
- make new table
- IF with text
- Disable automatic conversion of cell format?
- copy/paste into excel changes numbers into date format
- Save Button
- taking data from different worksheets
- Summing values in database according to multiple criteria
- referencing
- indirect function problems
- Excel spreadsheet re nameing
- excel worksheet re-nameing
- Password Needed in Visual Basic templates?
- Copy part of a cell
- Re: column names
- Conditional Cell Formatting
- Count Formula
- Increasing range for autofilter?
- Formula?
- Finding automatic links in a worksheet
- One Chart made from different worksheets?
- GETPIVOTDATA with Date
- Drag and drop pictures in Excel 2003 from Windows Explorer?
- how to reduce file size
- autolinks to sheets
- Worksheet button moves when printing
- Merge Worksheet Columns
- macros, but i dont't see them
- Alignment in text box
- Data Types
- work rota sheet
- How to get the URL from the link?
- Expanding groups in a protected sheet
- Pivot Table problem
- Disable Save unless a Macro is used
- Re: values between two numbers
- Re: values between two numbers
- Dynamic Cell Range
- Dynamic Cell Range
- Merging
- Re: Deleting sheets in Excel macros; navigating in Excel
- Re: Win32::OLE.pm and Hyperlinks
- Autofilter cells containing wild card characters
- Re: What function can I use to remove a space between text and numbers
- Re: What function can I use to remove a space between text and numbers
- Which data occurred in a certain month
- Align numbers to take up equal space
- Determine a percentage
- Display Date
- Re: text validation
- consolidating
- Re: text validation
- Re: text validation
- Printer not connected Msge
- Re: Highlighting rows
- Need macro to print sheet with multiple repetitions
- Re: Highlighting rows
- Compile Module Error (TBRun9) just won't go away
- automatic highlight of row when cell expires
- Search and replace #N/A with null
- Freeze Window - lock
- change column header name
- how to keep cell rounding to 2 places even when someone else pastes number with more.
- Replace text format
- saving a .txt file
- HP5100tn
- 2 Hyper links in 1 cell
- Question about accelerator keys
- Excel MVP
- Still needing help with the date
- Background Color missing
- Re: Entering Data in a Cell While Maintaining the Formula
- Re: Entering Data in a Cell While Maintaining the Formula
- Re: Entering Data in a Cell While Maintaining the Formula
- Difference between Dates doesnt work
- formula inflexibility
- how to merge multiple rows into one document
- excel vba-protect cells
- Circumventing Data Validation
- "Something" is overriding my Format!
- How to determine cell format in different locals
- I just got MS Excel 2003. What happened to the "auto save"....
- Unique distinct count in pivot table?
- Re: Different formula for different date
- Merging workbooks that weren't "shared workbooks"
- Re: Different formula for different date
- Re: What function can I use to remove a space between text and numbers
- Multiple Pivot Tables
- Delete empy spaces
- Website opens when scrolling in Excel
- Mail merging/importing contact data
- Inputing data
- Re: Conditional Formatting
- Worksheet Protection
- Excel Templates
- Menus, Toolbars and Keyboard shorts missing or diabled
- Opening Excel files
- Excel won't open
- Wordtip.com ?
- opening unopened workbbok via code
- a long formula, cna it be shortened
- Need help making display charts from DATABASE
- Emailing grades from excel
- error bars
- Why does / cause cursor to go to File menu?
- Help needed with formulea.
- Watermarks in Excel
- Making a Macro Run Automatically
- Add print buttons for specific printers?
- Shortcut to excel file: Windows cannot find ...
- Fluctuating Exchange Rate
- Re: Arnold Schwarzenegger Commits Suicide
- Copying with Row & Column Headings
- Fonts in Dropdown Menu
- Conditional summing - formula help
- Sharing Excel document via the Internet
- file recovery
- AutoComplete across tabs
- Pictures in headers
- hyperlinks
- logging macro
- Configure a report
- Lost Files
- Convert pdf (tabular format information) to excel
- paste/copy help
- excel
- please suggest....pivot table not getting created
- approach to excel
- VBA code to pause before printing
- why does a formula become text
- Finding unused macros
- Formula to Convert Minutes:Seconds to just seconds - Plz read Post
- Excel
- change cell from
- Suggestions on taking Excel data into Word form
- saving excel file with it's add in
- adding letters
- adding letter part 2
- formula assistance
- How do I remove what I can't see?
- Extracting Multiple Values From One Cell
- How to activate compiled HTML Help file using VBA code?
- Wrap text does not work
- Only Keep Non-duplicates in an Excel spreadsheet
- If Statment
- Enable Autorefresh Error
- Sum with Auto Filter On
- Linking headers and footers
- Userform is moveable and leaves traces of prior positions Excel 2000
- sheet protection
- Excel spreadsheet Normal Template
- Excel crash when opening file
- end of column
- Help in turning off underlining and blue font
- Quicker way of chaning Cell ref in Define Name
- EXCEL2000 - ODBC Links
- Quick creation of hyperlinks
- Excel VBA-vlookup combo box problem
- Report data needs to conform to db format
- Move a row to a different sheet, dependant upon cell value
- Extracting data from one column
- Filter
- add hours flown last 12 months
- sorting a column with number & letters
- Getting rid of macro
- Excel 2000 vs XP vs 2003
- Excel printing problem(..)
- Linking to exported tables and queries
- Workbook sheet page numbering?
- Extract Comments from EXCEL-sheets
- reading old excel files
- Summing and Counting based on 3 criteria
- re: excel 97
- Using lookup instead of if-statements, how?
- Macro help needed........
- incremental counter using VBA
- Changing the location of a file through
- Joining/appending two columns of data
- VBA help (Empty row delete; coupled with 8192 non-contigious issue]
- Newsgroup Search -- Working?
- "recently used files" not working
- Increment Count on Recalc
- Excel Problem ive NEVER SEEN BEFORE
- Linking cells to MS Project cells
- Tabbing with in groups of cells?
- "Format cells" not working
- getpivotdata multiple items
- Changing File Location on General Tab
- Is there a range function (i.e. Max(range of cells)-Min(range of cells))??
- Copying multi Check Boxes
- Text to Columns
- Printing a form from excel
- Outline question
- unable to read excel 97 files
- Mapland Excel Addin - Programatically Create 1000 distinct maps
- Revised Blinking cell- sorry
- merging list with standard range
- Custom Formatting
- Re: flexible range on vlookup??
- Last record
- How to reset Office products menu's back to original setup
- sum values in a column only for unhidden rows?
- choice to colour text
- Personal.xls locked for editing
- How to disable or remove Save button.
- circumference
- compiling tables
- testing news server
- retrieving last two digits from a date value
- Show All Commands on Menus
- Removing duplicate numbers
- Make a Macro on a Toolbar
- formula
- autofit
- Re: Copy,create another formated sheet
- no more new fonts in Linked excel graphs
- processing is slower and with more errors
- Pivots tables refreshed but not updated
- drop down button
- Re: last cell filled in n it´s contents
- Re: Rounding down Figures in a cell
- Re: Rounding down Figures in a cell
- Re: Hyperlink
- Re: adding color to formula
- Excel with Macros
- Re: processing is a lot worse, slower and with more errors
- Rounding down Figures in a cell
- Excel - Portrait and Landscape pages
- Deleting Undeletable Line?
- seeking formula
- Rotating Text
- how to format cells so that it only shows thousands.
- Drop-down arrow/menu in cell
- Report Manager Add In for 2003
- how to test code and/or run code
- Create timesheet for multiple users
- Use VBA to format cells
- Finding a wroksheet in a specific location
- Macro to look for file on multiple drive letters
- Copy appearance but not conditional formatting
- Copy cell appearance but not conditional formatting
- Automatic backup in Excel?
- MS Query loading problem
- Add entry to right mouse click dropdown
- can I do data validation based on contents of cell?
- Changing to Combination-chart from existing chart
- default date/time format
- filtering colours
- how to strip html
- Pivot Tables from imported external data
- Excel 97 to 2003
- copying information from various excel files
- Variable Ranges
- Re: stop calculating late fees once rent+late fee met
- Producing a top 30 list
- dynamic cell reference
- Using a VBA forms text box to show the filename path
- Dumb Question on Sample Files
- Export Word table to Excel
- Keep my date format instead of julian dates
- Can't update 1 out of 4 links in a workbook???
- Need help with formulas over different sheets
- Eliminate information at beginning and ending
- Conditional format
- Pocket Excel
- To use Drive Letter as Input Path in File search
- *URGENT* Corrupt Excel File. Can I Recover?!
- Changing Comments Default Position
- Selecting particular records
- print the sheet tabs
- Scrollwheel in VBA Editor
- Positive to Negative Balance
- Ilegal message
- Selecting particular records
- macro on opening
- Conditional FormattingEOMONTH Test
- Default Print Areas
- too many named ranges?
- HOw do you specify a text in data validation for cell
- Excel Templates
- Look up
- Re: SUMIF and multiple criteria
- Delete Macros Macro
- Display Leading Zeros
- VLookup for test
- Re: SUMIF and multiple criteria
- on startup and exit
- Re: Macros using loops
- function not producing cents, only whole dollars
- Re: on startup and exit
- Display Leading Zeros
- SUMIF and multiple criteria
- Non Numbers Cells
- Include Leading Zeros in Cells
- Set of numbers
- Re: Include Leading Zeros in Cells
- Rounding a result
- Display Leading Zeros
- Last Cell filled in
- SUMIF
- Count business days
- Countif on different worksheet
- Re: XL2003 Validation Input Msg Problem
- Re: Continuing a list with text and numbers
- Sum amounts between dates
- Re: Combo Boxes
- Re: Excel Templates Path Question
- Re: SUMIF with more than one criteria
- Re: Macro to count business days
- Re: PROBLEM WITH COUNTIF TO REF. ANOTHER WK SHT
- Auto-print Pivot Table Report that cycles through all Page Field values...
- Re: SUMIF with more than one criteria
- Re: Rounding Up or Down
- Re: Excel memory characteristics query
- Re: Date Formulas in Excel
209
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.