View Full Version : Microsoft Excel Misc
- 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
- Re: assigning multiple text values a numeric value and summing a range
- Re: Excel / "Find All" button
- Sort by last digit of cell
- Re: Macro to count business days
- Re: Rounding Up or Down
- Re: Print Ranges (group mode)
- Re: PROBLEM WITH COUNTIF TO REF. ANOTHER WK SHT
- Re: Update the contents of a cell triggered by system clock
- Re: program speed
- Re: Extracting Sheet Name from Formula in Another Cell
- Re: identify sheet?
- Re: Shared Spreadsheet #NAME?
- Re: Excel memory characteristics
- VLookup Returning N/A - Formatting Problem
- auditing limitations?
- Re: Extracting Sheet Name from Formula in Another Cell
- Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000
- Formatting issues with downloaded spreadsheet
- Re: Auto Recalc
- I need to get across an excel password
- Re: Updating contents of cell based on System Clock
- Excel 2002 on a Terminal Server 2003
- Re: SUMIF with more than one criteria
- slow scrolling in excel
- Re: Pivot table show detail to keep format
- Re: Pivot Table Auto Refresh and Auto Flow to columns
- Re: Another Hyperlink Question
- Re: Adding Rows together
- Virus scan
- Mail merge to excel
- Insert File Properties
- How to populate a bunch of cells at once
- Retrieving date values
- concantinating two columns and adding a hyphen
- Macro to hide rows
- RE: Display Leading Zeros
- Thanks, Chip Pearson
- SUMIF with more than one criteria
- saved over a file
- Re: Excel Header different on page one
- Excel 97:Still need help increasing characters in a text string
- Macro Error: Unable to get Var property
- Re: Excel Header different on page one
- Re: header front page different
- Re: Converting text to date
- How to dynamically populate series for an XY chart?
- non empty cells - or hidden characters
- Excel Header different on page one
- Calculating a deferred annuity
- Self-Resizing Formulas
- Re: Validate a Range of Cells
- Excel - and the MS Windows Task Bar
- Remove personal.xls from xlstart?
- .xls files opening in IE rather than xls
- Mileage report for US and CAN rates .. help !!
- Data Filtering:
- sumif problem
- dates issue in excel
- Change seconds in hours, minutes and seconds
- Wild card formula
- Deleting Duplicates, Sorting, Etc Macro
- Re: Excel Header different on page one
- Re: Hyperlink
- Re: recommendation
- Attaching to secured Access data source via Excel
- Re: program speed
- Re: Subtotals
- Re: Subtotals
- Re: how? can i activate the maximize and minimize an form.
- Font changes automically to AlternateGothic2 BT
- By VBA , how to select the first visible cell (of first Visible row ) in filtered wor
- Lookup a sheet via a cell's data
- Echo Back the Cell Location
- sum a range and then test its result ?
- Macro problem.
- Macro coding
- macro
- mcro coding
- Taskbar group close
- Cell Formatting After VLookup Is Done
- Problem with 2 levels of subtotals
- How to sum up one column depending on two conditions?
- UserForms
- Pivot Table Show detail to retained Pivot tables formatting
- comment's position
- chart axis title
- HELP!!!!!!!!!! VBA charts
- Worksheet for Consolidating various Party Account
- Powerpoint value in Excel
- When file is opened a tune plays
- How can I reduce long calculation times on large sheets?
- Excel chart help!!!!!! Please!!!!
- Excel conversion problem
- Automatically add 1 until a number is found
- when inserting a hyperlink the view is shortened with ././ at the beginning
- Looking for sheet to handle MPG, etc
- Changing cell location with a formula
- Office 2003 updates
- excel question
- Printing Hidden Worksheets
- Re: Adding Rows together
- Link Excel to Access
- retrieving an old document
- Re: Excel Active cell query?
- Re: Splitting large spreadsheet
- Re: tick box
- Commision formula problem
- Excel to Outlook Copy/Paste Problem
- Re: go back in pivot tables
- Printing Visible Sheets in Sequence
- Copying pictures from windows explorer into Excel 2003
- Re: STOP THAT!!!
- cell reference problem
- Re: copy until blank found
- Copying from one workbook to another, without taking the name of the 1st workbook with it.
- converting lot of microsoft worksheets to separate workbook
- Split Name Field in Excell
- Re: Subtotals
- Set default values marco
- Extend Formula Results
- excel spreadsheet
- excel spreadsheet
- Re: Protection
- Word Table to Excel Sheet
- Stuck spreadsheet
- Buttons
- Read-Only
- Save single worksheet as new workbook
- Setting range in a column where data ends
- locking cells
- Highlighting with an IF statement or using Cell Format
- Re: 2002/2000 Long load times
- vlookup help
- V-lookup and format
- Re: SUMIF help- 'criteria' doesn't allow formulas?
- Header/Wrap Text
- Re: SUMIF help- 'criteria' doesn't allow formulas?
- Missing Gridlines...
- Missing Gridlines...
- Problem with Excel opening multiple documents
- Formatting Text
- Consolidating buttons
- Define a date as "savedate"??
- Re: SUMIF help- 'criteria' doesn't allow formulas?
- Re: [URGENT] Line Graph
- ODBC add in
- Re: Out of Memory
- Missing Excel Files--- PLEASE HELP!!!
- Help -- Missing Files
- Password protection
- Re: Autofilter help- doesn't allow formulas in its criteria?
- Using Pivot Table with VLookup
- sumproduct question
- Re: Shared for some and Read Only for Others
- Re: Format cells so they display numbers as negatives
- Format cells so they display numbers as negatives
- Properties - Summary --> Changing Company name in Excel
- Re: Shared for some and Read Only for Others
- Copying a sheet, macro button #'s change
- Shared
- Shapes
- month-date
- Modify header/footer for workBOOK
- Protection
- Excel cell divisions
- Separating data
- Re: Format cells so they display numbers as negatives
- display counts AND % of row totals
- Date not recognized in Excell 2000
- Lookup a value across sheets
- what is the best way to do this?
- add a negative symbol
- Re: worksheets and workbooks
- OFF2K3 SP1 Then @ causes hyperlink???
- SUBTOTAL Second Count / sub-count of Filtered Visible Cells
- Time Formula Help
- Macro to extend a pivot table range
- Pivot Table - Can't uncheck values
- Re: Nested IF Formula
- Re: Nested IF Formula
- file format not valid
- Re: Copying a sheet, macro button #'s change
- Re: changing number of undos available
- Microsoft Map
- Excel Help
- macros and if statements
- Solver Add-in
- Cell Echoing Help in VBA
- RE: Validate a Range of Cells
- Formula Bar Missing
- font color for negative numbers
- Conditional max. number
- Excel gives error when closing down
- Clipboard usage
- page margins
- The options turn to grey when I open excel files at IE
- Tab into specified cells
- Macro for Checking Acct No with Acct
- Same heading on every page
- Hide colum
- Lock row
- Autofilters not working
- Add new XML element using Excel 2003?
- Showing A Cell Value In a Floating Window
- Tabbing to specified cells
- Number Display
- Showing the nth figure from a list
- General Functions
- Product/Price menu
- Changing of Macros
- Import calendar data from MS Outlook
- ODBC Select Data Source
- Macrochanging(with sample)
- #N/A
- Conditional formatting / formulas
- Range Names changing by themselves
- Sorting by multiple names in excel
- Message box with multiple buttons
- Changing default spreadsheet margins
- SP1 for Office 2k3 (good or bad???)
- Printing different worksheets on different pages
- Finding the range of non numeric cells
- CommonDialog Problem
- Hide Macro
- personal.xls ?
- schedule
- comma's in a formula (esp an array)
- Re: Skipped Town
- Re: Gridlines / No Gridlines
- Re: comma's in a formula (esp an array)
- Skipped Town
- Re: Gridlines / No Gridlines
- Re: Skipped Town
- Re: Gridlines / No Gridlines
- Query between Excel and Access
- This is driving me NUTS!
- Pivot Table Help
- Multiple queries require many logins to same database
- 2 x work sheet change????
- Re: Need to search results of formulas, not formulas.
- sorting
- Alert Save Message
- files opening blank
- Consecutive MSG boxes
- cell colour
- formula to Adding to working days
- Need to delete duplicate rows automatically
- Formula - lowest number from 3 columns
- Using the mouse scroll wheel to scroll sideways
- Publishing a worksheet to web
- starting a cell with a /
- Remove "automatic links to another workbook"
- Common Dialog Problem
- Re: xml schema update
- Automatic Data Sorting
- Excel 97 macros won't run in Excel 2003
- changing add in "odbc" setting in excel
- printing forms with excel
- Copying Pivot Table to new file--why does it still refer to original file?
- simple combobox code
- Re: formula to Adding to working days
- Forms Design
- making a form
- Analysis toolpack add in
- Summing columns
- Pivot Table Error-"Microsoft cannont make changes because there are too many..."
- How do I name a column?
- Access to Template's Linked Data Sheets
- Re: Cell Margins
- Re: Cell Margins
- E-mail notifications
- Special characters in titles
- Hidden Module
- colorize celle from a range of date
- copying floppy disk to CD
- Inserting static date/time
- Problem copying pivot table
- DELETE ROE???
- Pivot Table - fix column size
- Excel to XML
- File too large
- How to create list from 4 workbooks based on 1 criteria?
- tracking changes
- Mischievous buttons!
- auto hide row
- PDF file import
- recording totals in another workbook
- excel web query
- copying up to blank cells
- What is the easiest way to remove duplicate entries from a list
- Help with VB codes and Validation Data
- Is this possible.
- =c1=c2 gives number instead of true or false?
- EXCEL 97
- Re: Aligning a graphic in the footer along the left edge.
- Cookies
- Excel Newbie-Simple Question Regarding Numbers Formats
- Converting Worksheet to all 'Upper'
- cookie info
- Excel Database/Pivot Table Issue
- Search range of numbers for amounts that total a given
- Template
- removing automatic link
- excel
- Counting a specific character in columns
- Excel 2002 File opening problem
- UNICODE Export with different Separator?
- Who can explain this LOOKUP formula?
- Sum of mixed leters and numbers.
- RE: Combo Boxes
- Hide row
- date to day of week ignoring blank cells
- Protection - Allowing update links & Auditing
- Excel spreadsheet template
- Print worksheet if...
- COUNTIF using multiple criteria
- workbook header
- display information based on cell input
- Excel Finding instances of a value in defined range
- text import wizard
- List folder names within a directory
- Can I do this?
- Month end report ? expansion...
- ADDED DIGITS WITHOUT TYPING THEM IN
- HELP! Importing a word doc into sub tabs of a workbook.
- Worksheet functions
- Password to activate macro
- Hiding the Blank Cell in a Drop Down List/Combo Box
- grouping and outline
- Compare worksheets
- Linking /Copying Autofilter Arrows
- Override Save Button
- help parsing an address
- linking several data sheet into one master workbook
- Path Name
- Excel File Portection/Password
- macro to open file in read only
- Re: Help in Transpising Multiple Data Selections
- Re: Excel; How to Create Automated Master List from 4 Workbooks?
- MS Office 2000. Excel. Question on cell formatting
- Re: Help in Transpising Multiple Data Selections
- Can't open more than one Excel file.
- What is the best way to do this - 2nd try
- RE: row size
- tick box
- Long txt data import in cell
- Sorting Dates as Numbers
- Max rows reached?
- Permission to use object denied.
- Re: Consecutive numbers
- [GROUP]
- Re: Convert numbers to true text
- Re: Convert numbers to true text
- VLOOKUP question
- Re: VLOOKUP question
- Excel Worksheet Cell Formatting
- Number notation
- Limiting a Button to a single workbook
- Limiting a Button to a single workbook
- Re: Countif and < and >
- getting around a popup window during a macro
- Display some text as a PERCENT
- CONVERTING 1-2-3 WORKBOOKS
- making a macro run first thing when opening a workbook
- Show leading 0s for binary formatted cell?
- way to track formula result changes??
- data validation not enforced with a named range source excel 2002 sp2
- [URGENT] Linking Dates to a Data Worksheet
- validity of a cell
- Re: file name
- Sharing a Workbook
- Excel warns about macros, but there aren't any!
- cell color does not show
- Printing to different printers
- Customize Pivot Table Toolbar
- Macros between 2 MS (or other) Applications
- Excel; How can I use Query to create lists from separate workbooks
- How can I automatically create a master list from 5 worksheets?
- unhide rows and highlight automatically?
- Global Footer Options?
- excel with project embeded in it
- Enter key not working in Excel
- IF OR Statement
- IF OR AND Statement
- Remove checkboxes
- Change of Colour to a cell when "Warning" is in that cell
- Sorting rows without messing up cell references??
- How do I convert month name in month number?
- sort by date problem
- Three Column Lookup-Use Match and Index?
- Re: Saving to Space Delimited File (.prn) - Excel 2000 vs 2003
- Vlookup and sorting
- Formula Problem
- Lost workbook
- print area
- WAV Files
- 'Name box'--increase width
- Adding Office odbc add in
- Sum entries between dates
- Can I edit a web query?
- Pivot Table/Chart Grouping
- Excel Reader/viewer
- Removing Data Validation
- Linking Excel Workbook to PowerPoint
- Linking Excel Workbook to PowerPoint
- Class not registered
- Criteria Serach
- carriage returns in excel
- Where's the Macro!
- Current month question
- Linking/refreshing data across worksheets
- How to increase font size in combo box
- Average
- Excel Challenge (prize - she keeps her job!)
- Advancing A Number With The Push A Button
- Combo Box
- Roundup, Roundown to a specific digit or number
- RE: Sorting in Dynamic PivotTable
- RE: Data duplicating on paste
- RE: Delete Rows from Protected Excel Template
- RE: Import Image Problem (Invisible)
- RE: Purchase Order Template Numbering
- Conditional fomatting
- scheduling
- Additional Conditional Formatting Question
- I guess this is something to do with "match".
- Times to Decimal Hours
- Formula Problem2
- selection of cells within column while keepning same order
- Excel hangs when creating pivot table
- Help with text
- help with formula please
- #NUM! error
- keyboard problems
- Word Document
- overwritten excel file
- Frequency
- Non-contiguous ranges for chart
- Addition problem
- help with % formula
- Help to add Format to VBA Code!
- convert cell content to html automatically
- If/Then Matrix? Can Excel do this?
- Turn off Exponential Notation Part 2
- Adding numbers in columns with letters
- Opening Excel to a particular worksheet
- time entery to the cell
- unhide rows adn columns
- Control toolbox objects
- Excel Grid to Template/Form?
- Rounding Help Please
- Excel percentage problem
- vlook/Match/index
- Excel VB Windows XP and 2000 problem
- Matching
- Maximum file size for excel documents?
- Need a Little Macro Code ...
- Moving hyperlinked files
- MSGBOX that shows cell data
- Permission to use object denied.
- PivotTable and PivotCharts
- Directional keys act like page up or page down
- apply mark up to block of cells
- Problem with recent Drop Down List Code
- Pivot Table Query
- Run macro based on cell value in worksheet
- Re: calucalating cells not responding
- Macros - Hiding actions
- Slow VBA Code
- sphygmic file
- decimal & percent format
- Re: Categorize entries
- Lookup
- Lookup
- copy 1 column from another spreadsheet
- Lookup - Formatting of numbers
- Macros to Browse for Files
- COUNT: Counting the number of times "X" comes up after the occurrence of "Y"
- Excel Pivot Table - Calculated Items Problem
- Re: Floating numbers to a specific cell?
- Question on defining a name
- Changing -> File, properties, Summary (A Repost)
- Re: multi user problem
- Changing cell colour when cell selected/de-selected by mouse/arrow keys
- Excel Help for Fantasy Football
- extracting info from multiple sheets
- pasting column and row width and heights
- using countif() to parse string
- Chart Y-axis definition. Limitation for Maximum characters ?
- Re: Copy, Paste special (Value) Very slow
- Excel; Can I Filter based on a cell value?
- A Turing Machine in Excel
- Class not registered
- Portrait only printing in Excel
- MACRO FOR PRINTER
- MACRO FOR PRINTER
- max text characters in pivottable cell
- Can data validation also autocomplete?
- automatically update data validation selections
- statistical analysis
- Statistical symbols
- If statement - or a better way?
- Addition to Subtraction?
- dot product
- Strange Problem Excel 2000
- Solver Question!
- Re: Disaplay Sheet Name
- Re: Disaplay Sheet Name
- another cell linking question
- Missing sheets
- Linking to a specific sheet in HTML version of excel spreadsheet. ?
- Re: Move data in a column when the date above changes
- formula to change when filtering
- Re: Entering date without year
- CELLS
- MS Excel data to Laser Label sheets
- Cannot Choose cells (or ranges) after column S
- Re: Disaplay Sheet Name
- timesheet formula
- Excel VBA - Highest Value and Second Highest Value
- Re: Margin Setting
- Re: Margin Setting
- Import data from FileMaker
- What does the [Group] in a file name mean?
- plz help:- a simple macro.
- conditional formatting ?
- conditional formatting ?
- sorry for the duplicate posting
- Annoying Macro Message
- Data Validation & V Lookup?
- recommendation on book
- Counting number of characters in cell
- help needed on multiple option buttons
- Excel Number Format Codes
- Multiple input data , multiple output data
- Excel recently used function is greyed out
- Use defined names in VBA?
- Getting Bug-eyed! Macros no longer run properly when workbook is opened.
- Research Pain
- My worksheets appears out of alignment
- Worksheet alignment is out on pc
- Text format
- Changing Case
- funcres.xla
- Inclusive number of days and running total
- Printing EXCEL in PRE-Press inviroment
- Excel formula help Quering 2 cells
- If Statement
- Linking To Autofilter Arrows
- More conditional formatting
- Marco with autofilter
- How do I link text and a formula together?
- Worksheet Size
- Transpose
- May I link two workbooks together.
- right click with mouse doesnt function in graphs
- if color then formula in cell
- Happy Face Graph ... Is it possible?
- displaying sales order equal to user input
- Date problem
- converting dates
- minus hours
- Right click errors
- Fixed Column Width
- Upgrade from Excel 97 to 2003
- Error occurred while loading sheet 3011111111111111111111111111111
- Hyperlink help
- Always negitive
- Write to Cell in Excel from a recordset : limited amount of caracters, WHY?
- please help
- checkbox whithin a cell
- file corruption
- Re: Links to worksheets from a table of contents
- Save values and formatting but not links
- alternative to INDIRECT reference
- Transferring Macros
- Cursor Malfunction
- Excel 2000 Web query imports incomplete hyperlink info
- Removing Blank Cells
- Can't open files on a network share by double-clicking
- shade every other line
- Virus infected e-mails from posting in this forum
- Forms
- Displaying Leading Zeros in Cell
- Producing Documentation
- More of an accouting question than an excel question but I'm someone here will know.
- Re: Embed Colors/fonts/format
- Auto fill cells with dates, exclude weekends?
- Re: Double quotes in VBA string
- Re: Double quotes in VBA string
- Excel 2003
- SUMIF on Date Range
- problems editing legend on a pie chart
- borders?
- Function help needed urgently!!!
- Function help needed urgently!!!
- Results of a formula to be Number instead of formula
- Formula Questions
- create dynamic range for chart
- Graphs help
- Trying to figure out subtle IF command
- timer
- Re: copy and paste multiple selections
- help with formula figuring %
- removing comment indicator
- Custom Formatting Help
- Too many different cell formats
- Please Help! - Class Not Registered
- How do i set the default for all worksheet printing to be gridline
- Print Rows at Top only on some pages
- copy vertical data to horizontaly
- triggering a macro by workbook_close or workbook_open
- MS Access and external data
- Wingding Font List ...
- removing space
- Graphs
- "x" v.b.a. code entry question
- hide printing
- Custom formatting
- Tab sequence or direction.
- FAXING EXCEL FOLDERS
- Too Many Custom formats
- Applying BreakLink Method for all sheets and cells
- Re: Print Preview Mode - Generates extra sheets
- Fonts in Excel
- Engineering notation
- SAVING EXCEL FILE AS .CSV
- Changing a symbol every time
- MTD Formula Help!
- formula fill
- Find lowest 5 values in a list of 10 - 150 lists involved
- Data Validation
- clocking
- Re: Numlock plus key types a v
- HELP ME! :o)
- Re: copy and paste multiple selections
- degree symbol
- password
- Eliminate page breaks between worksheets
- Re: copy and paste multiple selections
- Copying an If Formula
- Quick help please! Converting seconds to hours and minutes.
- Using Autofilter on a protected sheet
- Formatting Dates in a sheet imported from ACCESS
- MS exploere question:open link in new window
- Macros to select multiple sheets to make simultaneous change
- last cell
- Adding path to footer in Excel 97
- how to sort the data display order of multiple chart
- Splitting up a Cell's Contents
- Comments
- create a link between workbooks
- AutoSave Add-in Not Loading-2nd request for assistance
- Date query "Excel VBA"
- maximum charachters in cells
- Opening a unicode CSV file from Excel
- Excel web query returns no data
- Zip Codes 5 digits only
- macros command for excel dialog
- Problem with external data web query
- Closing documents in Excell & Word
- Watermark
- Syntax error text in VBA
- Excel 2003 Maps
- lookup in vba
- Duplicates in multiple files
- Inserting a formula into blank rows in a varying range
- how do I turn off an Automatic Scientific Format
- Automatic removal of rows
- Reminder OKonly button when spreadsheet opens
- Keyboard shortcuts
- Deleting conditional formatting
- Ampersand and %26 in Hyperlink
- Footnote in a Formula Cell
- Counting cells based on color
- Automatic creation of Hyperlinks
- Formatting sheets
- Reversed-out text
- Validation
- Conditional sum
- worksheetfunction
- Dropdown box
- Column E cell contents added into Column D contents (not overwriting data but mixing)
- text gets cut in cells
- cal number of days
- Re: Moving text from a column to a row
- Re: Moving text from a column to a row
- Copyrighting an Excel worksheet
- Re: Changing to 'Proper' Case
- Re: Changing to 'Proper' Case
- Re: Changing to 'Proper' Case
- help with adding rows
- Re: No RETURN() or HALT()function found on macro sheet
- Re: calculating dates
- Mouse Scroll In Excel 2003
- Re: calculating dates
- Workbooks do not open
- PLEASE PLEASE HELP ME... i think its autofill .. not sure
- Re: Sum of even rows
- Re: Sum of even rows
- USING "PRINT SCREEN"
- override a cell
- How to Organize 40+ Worsheets?
- Re: Excel draw object
- text gets cut in cells
- Re: Adding custom format
- look up
- Formula check
- make 2 cell in once
- Re: Validation - Another ?
- Re: Validation - Another ?
- VBA code for a toolbar button
- Excel 2000
- making 2 cell in one
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.