View Full Version : Microsoft Excel Misc
- VBA Book
- Re: Download from Web Application to Excel 2000
- Sum Range 1 when the elements in Range 2 are found in Range 3
- Small Business Financial Manager
- calendar
- can I install Analysis toolPak into my Excel 97?
- Download from Web Application to Excel 2000
- Formula that link worksheets
- Average Age
- "file cannot be accessed"
- ????
- Code Modification(From previous post)
- averaging a column
- Re: Vlookup won't work for me... Aiiiiiiiiiiiiiiiiiiiiiiiieeeeeeeeeeeeeee
- Re: Hyperlink
- Converting imported data
- Re: Conditional Format for External References
- Validation Rules
- SUMPRODUCT function
- SUM PRODUCT Function
- Vlookup won't work for me... Aiiiiiiiiiiiiiiiiiiiiiiiieeeeeeeeeeeeeee
- XIRR non continguous
- Matching columns of data
- Vlookups to Excel Version 3 files.
- Reference between sheets
- data sort
- Excel tutoring or reference book on line
- Disappearing macros
- Re: Print areas
- Re: projecting an expiration date
- Relative refs for external data
- formatting text in cell
- using excel form to be filled in with data from sucessive worksheets
- Excel sorting
- Insert Symbol
- help with excel ...
- vlookup to another spreadsheet not working
- Problem opening Excel documents
- Re: vlookup to another spreadsheet not working
- current date in text field of an input box
- Contacts from an xls file with Name & Number
- Stupid Macro Question
- Excel Filter
- Re: Conditional Format for External References
- Link cell wiht comment-pop up message
- Linking numbers into the fields
- Turn off Clipboard pop up window
- Re: Conditional Format for External References
- Rentacar in Spain - Carhire - Publicidad
- Re: projecting an expiration date
- Conditional sum: different worksheets
- Sorting by count and state
- Re: Find & Replace " * " with " x "
- Search/Replace to Insert CR (Alt-Enter) into text
- Slow File Open accesst to files
- Error message on Excel startup
- Prn file
- Preventing deletion of workbook
- Needing formula for percentage of an amount
- Re: Find & Replace " * " with " x "
- disappearing macros
- Date
- Quick question...
- Image in header
- Comparing first and last names in two lists
- Comparing first and last names in two lists
- Comparing first and last names in two lists
- Comparing first and last names in two lists
- Comparing first and last names in two lists
- Office XP - Saving Excel file opened from Outlook
- copy & paste
- Autofill
- Quattro Pro Converter
- Quattro Pro Converter
- XML and PivotTables on Excel 2003
- xml document format for excel
- 64000 Blank Rows in a sheet?
- Quattor Pro Converter
- Quattro Pro Converter
- adding more columns
- Copying Data from the Web into Excel
- Quattro Pro Converter
- Re: Macro
- HELP!! Header thats not a header
- Quattro Pro Converter
- Re: Operator for "between"
- stop macro recording button missing
- Easy Question - Cursor Down
- Quattro Pro Converter
- Auto height rows - cells are not merged
- Using text in place of values
- Relative vs Absolute References (VBA Code)
- Printing on landscape but comes out portrait
- Office2002 issue on Win ME
- Compile error in hidden module: Autoexec
- 30 Day Rolling Average
- THANK YOU
- Excel Viewer
- Can I "sign" my own macros? or some other fix for the message about security and macros?
- Background Page Numbers
- Import Data From Access
- Enter Times In Conditional Format
- convert table from WordPerfect to Excel?
- wrong justify cell format option in excel 2003
- Breaking up a column
- Re: How to save versions?
- Looking for a function......
- Re: Excel XP - Formulas including cells in Pivot table
- Auto start a macro
- How to find link in worksheet?
- Linking to an Embedded Graphic
- Hide Formula
- footer or header
- Fixing 1,000s of links
- Date format mm/dd/yy to dd/mm/yy ????
- How do I count ???
- Pictures & Excel
- Change 'save as' default folder ???
- import data
- Pivot Table
- How to sort a table with only formulas?
- Only do a formula if cell is occupied
- group cells....
- I know you're trying....
- joining or merging data...
- Organising Worksheet
- data validation from other file.
- Sub Totals
- Replace function
- Macro question
- Excel Opens Numerous times
- Can't flip a spreadsheet upside down.
- Trying to aggregate weekly data into monthly average data
- Copy only sub-totals lines
- Is there a "SetFocus" function in Excel...
- Re: Subtotal formula
- Formula Help
- Can I print the File Properties?
- Copying a template to another PC
- Sorting worksheet tabs
- How to run Word macro in Excel macro
- Add - in numbers
- Saving book without formulas
- excel 2002 auto-save
- Text to numeric issue
- I need help with Excel - Adding dates
- Multiple Excels
- Excel file crashes when opened for certain users only
- Re: Subtotal formula
- Pivot Table - AutoShow Options - Field Properties - Top # Totals
- Can't open Excel in IE 6
- Is it possible to make Labels from Excel?
- limited number of worksheets?
- File Importing
- look up question
- Opening a Workbook
- Removing Hyperlinks
- Auto Save Add-in For Excel xp-2003
- Find Links
- Header Date
- Searching the web from Excel?
- formula display
- Removing Links?
- can't sort a column in a spreadsheet
- Excel Help-IE Script Error
- Delete Custom footer from Menu
- double clicking icon no longer opens worksheet
- Draft Watermark on my spreadsheets
- need a little asssistance :)
- How to calc. Inflation in a spreadsheet
- Auto open
- Solver for Scheduling Optimization
- Linking an embedded excel spreadsheet to a datafield in the source Word Document
- formula
- why does the excel print button under file menu keep greying out
- Help with a barcode scanner ?
- Linking to a Shared Excel File
- VBA Q
- have 3 pieces of data in a cell seperated by a comma. How can I isolate the middle piece of data?
- Graph Y Axis ...
- drop one score, average the rest
- Spreadsheet
- Determining new category number
- Cannot paste contents to another sheet
- copy and paste
- Excel File Edited and Saved in Word
- Find the first open cell in a row
- I need to install an add on to excel
- vertical slider - navigation question
- Excel Spell Check
- I dentifying the furthest digit back
- Excel 97 worksheet with macros won't open in Excel 2000
- 2 VBA Q
- non-numeric fields in pivot table
- how to turn off "smart" formatting
- Execute VB when Excel is Activated
- runtime error
- Convert Soc Sec Numbers to numbers
- text spacing problem
- Excel 2000 to Excel 97 macro problem
- Counting text strings in columns (Excel 2000)
- Code execution has been interrupted (Excel 2003)
- Puzzeling Subtotals.....
- Excel copy and paste
- 4-same-lines-in-one-graph
- Delete Rows Unless
- Disable Save As
- Office XP Subscription
- Re: limiting excel sheet to certain rows and column only
- Error message when copying sheets
- Suppress blank workbook when opening Excel workbook from Windows Explorer
- Multiple results from If or Lookup...
- Pocket Excel Merge Cells
- Inactive Links in VBA Help Files
- Domain name msoffice.com.xx (Is it legal?)
- How do I open .123 (not .WK?) files ?
- Reading data from cells on a worksheet into a textbox
- How not to draw cells with formula but no value in Excel charts?
- @Today Function
- Worksheet function "YearFrac"
- SUMIF function HELP
- Error opening an excel file with the same name as an existing file
- Exiting file without Excel default interfering
- Input Button Command Question
- Pivot table grouping dissappear after data refreshed
- Setting print areas on many sheets
- average of non blank cells
- Delete Empty Rows
- Records ending in a "2"
- Conditional formatting "kept constant"
- VBA - Excel setup
- Change Keyboard Shortcuts
- Convert word to excel
- Time and date problem
- Printing & Formatting issue
- Worksheet COUNTIF function and AutoFilters
- excel 'file format is not valid'
- delimiters
- Hard Code to Date Formula?
- Already Open Warning Message
- Sorting
- Incorrect Raw Data Format
- Dumb Question About Time and date
- Moving or copying worksheets
- Macro - Changed text colour to white
- Importing
- Merged Cell Check
- IF Statement
- Hide toolbars when file opens
- Linking Excel to Word
- developing a spreadsheet model
- Can't open spreadsheet from website
- custom view
- Date formats in input boxes
- how do you colour alternate visible rows only
- excel chart animation
- Excel (Report Manager)
- Using Dates in an If Statement
- Making a list formula
- Fill down
- Cannot save a file that I create
- Invisible Excel sheet
- excel list
- Auto Email from Excel
- Print Areas on multiple sheets
- Can't modify parts of a worksheet
- cut & paste to comment box
- Not what I needed
- Accessing pivot table's data
- Re: Can't modify parts of a worksheet
- Re-post: Conditional sum: different worksheets
- worksheet protection
- Re: Can't modify parts of a worksheet
- Opening max excel in ms excel
- Limiting Printing to certain sheets...
- Simple data form
- last newsgroup is message 10/3/03?
- Text Manipulation
- Context menu
- Merge and/or export data on excel spreadsheet
- "No more new fonts" error message
- wrapping and auto row height
- If formula question
- Microsoft Map object
- Save custom formats & make available from toolbar?
- 'advanced filter/unique values only' inaccurate counts
- Having trouble with extra rows at the bottom of the doc
- Spreadsheet Assistant Bookmarks
- converting macros from excel 97 to 2002
- Formula help
- Memory error when copying rows
- Pivot Table Integrity Problems
- Sum, when data in adjoining column changes
- Visual Basic macros in Excel
- Locking cells
- open attachments Excel program xls
- Deleting new window created
- spread sheet blank
- Managing multiple print areas
- Linking forms and worksheets
- Using Dates and Numbers
- Date and Time in a cell
- Excel gridlines disappear at random
- Import
- Running Macros
- How to update advanced filter automatically?
- linking to Named ranges
- Can't find file when it's right there?
- Text box is displayed when cell is activated
- reformat text in a cell
- Using "Tools - Options" doesn't work
- Excel viewer 100 % cpu
- removing macros in Excel 97
- Sorting
- Conditional Concatenation
- Updating Stock?
- Re: excel divides values by 100
- Re: Excel 2002 Alt+Tab Function
- Excel and Lotus Notes
- Re: preventing text input in cell formatted as number
- Trouble with vsearch function
- Office XP Excel 2002
- Linking to other sheets
- NETWORKDAYS function
- Protecting certain ranges
- Any good books?
- How do I not specify the sheet when defining names?
- tab
- Save custom formats independantly of workbooks?
- OOPS! I didn't save...help!
- Printing Page Numbers
- Equating a Percentage to a Number
- DG Open slow to open other directories
- Opening disk containing Excel worksheet
- How to create a drop-down list
- Check workbook open or not
- Limit to graphs in excel??
- How many graphs can I have in excel?
- Adding up values in a textbox on a form
- Creating cell links between workbooks
- Check register template
- xy scatterplots
- Excel Formula Help
- Depleting list
- Making an entry in a cell change the name of a sheet
- Check these internet package for MS Internet Explorer
- Add-In for PivotCharts in Microsoft Excel97 (Urgent)
- Excel & Access, Please Help
- Excel Values problems
- Question of handle negative inventory
- Required Input When Certain Condition is Met
- Pivottable help
- Shade alternate VISIBLE rows only
- Oracle UTF8 character set data displays incorrectly in Excel 2000 SP3
- count conditional format
- Before using Excel's t-test, how to know if the data is nomal distribution?
- cumulative curve
- Hyper-Threading Technology for XP with Excel 2000
- Excel Pivot Chart Problem
- deleting link external source
- Make exactly same color
- Excel takes 20 seconds to open
- "Max. number of fonts exceeded"
- Forms
- Date formats
- large file
- Multiple worksheets opening.
- Lookups
- Pivot table and manipulation
- lookup a date from an array of date ranges if conditions are met
- Workbooks for different versions of excel
- Screen does not move when scrolling in Excel
- howto find excel files that includes macro
- Macro repeating
- display a drop menu with options.
- Validation List(No blanks)
- Creating nested IFs with variables?
- deleting duplicate cells
- more help
- Last Cell Return
- clear Archive Attribute of source file on Save As action
- Name Boxes
- Copy any ROW that has RED background to Sheet2
- Named dynamic range, COUNTIF, and advanced filter
- paste spans several cells
- Need some direction
- Run Macros
- V-Lookup
- Printing to a particular tab within a Excel worksheet
- Formula Bar in Excel 2003
- Help!! Need Recovery!
- using IF to select 2 different formulas
- Excel 2000 gotchas
- Trying to link data with validated cells
- Anchor a Filter Switch?
- conditional formatting
- How to have 2 Excel instances open at the same time ?
- Basic data filtering in Excel 97
- Excel 97 and Excel 2002
- How to run a Macro from a cell formula
- HELP: how do I convert a list of state codes to written states? Also..
- Clear Sheet2 before copy
- Re: convert Excel document to HTML
- How to Extract Data
- Lock tab names for sheets?
- Adding Data and a Running Average
- Rounding numbers to nearest 0.12
- expanding cells
- workbook opens as system file
- OT: Excel with Binder on XP?
- pasting exact cell references
- Please Help Running a Macro from a formula
- Random DSUM table values
- Forms & Worksheets
- terminal server printing problem
- keyboard shortcuts
- Set Workbook Password - Excel 2000
- auto recovery
- Taste security update that came from the MS
- run time error 429 Excel 2000
- RE: 5 min to open/close a particula file
- Help with Data sorting - macro?
- printing a form
- creation of bmp files
- File Icon will not open file
- Help!!!
- Creating Excel chart where each column contains a range of values
- Margins do not fit page size
- format cells
- lost file! help!!
- Understanding the logic and Syntax of Excel Functions
- help
- Look at internet patch
- HELP! finding highest values within data
- protection of pivot table
- Expiration dates
- using find function after freezing panes
- Excel & The Web
- Read Only .xls Files
- Inventory by location list question?
- Prove these correction patch that came from MS
- Is this form developed within Excel
- Excel (2000/2002) Slow to Save files with Many Worksheets
- Adding Formula to Existing Cells
- Formula stopped working...
- Printing with formulas showing??
- Help:Macro to copy Excel values between worksheets
- Macro to copy Excel values between worksheets
- Automatic printing
- Converting Excel 97files to Excel 95
- Help with multiple Ranges
- Create macro for GETPIVOTDATA
- Excel file on web
- Insatlling French HELP file
- RE: Try on this update
- Removing everything after a character
- Mailing spreadsheets
- Simple Printing Question
- Problems with dates!
- If it returns #N/A, making it return 0
- Help with time formula, Excel 97
- Excel Date Conversions
- filtering lists?
- Validation list functionality!
- Try corrective update that came from M$ Corp.
- Algebra within a cell
- Specifying end of day as a time value
- Pivot table with % of total?
- Tie Breaker selection
- Formula for Calculating # of Days
- Thank You note to Peo Sjoblom
- Try on this correction pack which came from the M$
- Linking many EXCEL tables into a long WORD document
- Can't find spreadsheet
- Conversion of excel document
- Can not see any worksheets
- sum of dates
- Cannot open excel files or any ms office files
- Formatting long numbers accurately
- Opening an XL file
- Form sample
- jumping cells
- Excel 2002 save problem
- Wanting duration for video
- Using find- doesn't always seem to work
- Showing Links
- excel window size doesn't "restore"
- excel 2002 files not saved
- Carriage return in textbox
- Excel Links and Network Issues
- About Excell Macro
- Get rid of horizontal scrollbar in listbox
- Copy Header and Footer Contents
- FW: Use that critical package that comes from the Microsoft
- Splitting up bad data
- Take a look at that internet pack
- Formula to change text format to BLOCK CAPITALS
- Uppercase Formual - Converting Text
- missing columns
- Solver
- checking number of character in input box
- how to replace format
- lookup value & formatting
- "Publishing" excel file to peer to peer network
- Document not saved
- List Box Functions
- Auto fill error
- Excel 2000
- Date
- entering 0 to a range of data in a column
- hyperlink in middle of paragraph
- template downloads
- Excel outline and protection
- Grid Lines
- Dats Errors
- Print areas
- A daily computation formula?
- Row headings
- text is deleted from delimited file?
- Re: Count Unique Items Using a function
- Re: Count Unique Items Using a function
- VLOOKUP across multiple sheets
- Re: Count Unique Items Using a function
- Blanking cells with formula errors
- Very slow calculation
- Can't close with title bar
- Avoid drawing blank values
- Data analysis help needed
- SS#'s lose lose formatting in .csv
- A spreadsheet model to estimate waiting times?
- How to remove carriage return
- Writing Letters from Excel
- How to merge a worksheet in mail merge on Excel 2000?
- Simple display problem...
- deleting duplicate files from Excell
- Lookup help
- Row headings on RIGHT side
- convert # of columns into a single column
- Help! Trying to consolidate...
- not allowing to do cut (CTRL x)
- Auto Fill Options
- change column names to letters
- problem using the Checkbox Function
- Replacing \r\n
- Update Button
- Excel Driver login failed
- IF then problem for beginner
- Data Analysis Plus Add-In
- formula for cell plus x amount of lines
- Text to Columns...
- Edit: deleting duplicate files from Excell
- Adding cells that already contain formulas
- Add new symbol to Insert/Symbol List
- Excel2003 filter mode count
- Parse Data
- column width
- Editable Excel Spreadsheet Online?
- Group lines with bracket
- Excel on a web page
- Countif in pivot table
- Conditional Formatting in charts?
- Internal heap space in Excel 2003 ?
- refresh embedded worksheet size after update
- MS Word Mail Merge Wizard and Excel
- printing problems with spreadsheets
- Data Validation List
- time conversion
- Importing into Outlook 2003 from Excel (ss created in Office 2000)
- Can you place a combo box in a custom toolbar?
- Run out of columns
- Workbook protection help
- missing toolbars
- Regional settings: sensitivity?
- Excel 2003 Client Safety Options
- Why are their 65,536 rows in an Excel spreadsheet?
- Summing Short Time data type
- how to go to next row?
- default template location
- If & Find Statement
- Scrolling problem in MS Excel / Word under Terminal Server.
- Excel 2000 printing
- Send to mail recipient - 2002 question
- Saving backup workbooks
- Countif with two criteria?
- Re: reading .wk4 files
- Print Macro - footer specific
- Solver, Macros and Range Names
- e-book on vba
- if statement
- Refresh the pivot table automatically
- Ecel (XP) formatting
- if statement using alpha characters
- sort/extract strings with similar format
- transfer of cells from a worksheet to an other excel document
- Microsoft Excel Pivot Tables
- IF statements
- Spellchecking in Excel???
- numbers translated in letters
- can not see all the printers
- more than 65,536 rows
- Need help with VLookup
- introducing words OK, doing cuts NO
- "Too Many Cell Formats"
- Sumif with two criteria
- How do I call a HTTPRequest "GET" ?
- View Locked Cells?
- dd/mm/yy to mm/dd/yy
- Sheet Reference
- Prove these security patch from M$
- Is it possible at all to send EXCEL data within a network?
- VLOOKUP to return subsequent values on same criteria
- adding a graphic using a conditional
- cell formating
- Join Worksheets as in Access
- Toolbar preferences file
- Excel 2000
- UK Postcode Separation
- How do I link an image to a cell?
- IF Statment......Again!!
- Can I have the value of cell entered into another cell on a particular date?
- sharing macros with other users
- Combine Formulas
- Using Excel to model multi-dimensional system with Solver
- calculating the sum of the max 4values in 8 rows of data
- .prn print file
- Filling in Zeros
- Appending spreadsheets
- IF statements
- Minolta-QMS 2300 DL; Print Smearing
- Minimize/Maximize, Restore Window buttons do not work
- Count coloured cells
- removing items of exact liknesses
- Create a Form in Excel
- Take a look at these patch from the MS
- Excel documents displayed in taskbar
- customer header & footer
- Macro help needed !
- Re: Convert Lotus 1-2-3 to Excel in a Batch
- Re: Convert Lotus 1-2-3 to Excel in a Batch
- Re: Full Path Name in Footer-dynamically
- Saving as a text file with quotes AND commas
- Re: Splitting Columns
- Drop down list question
- Re: Splitting Columns
- Cell Not working
- File with packed-data
- FORMATTING USING DIFFERENT COLORS IN ONE CELL
- Dollars times hours
- Excel 2003 Memory Limits Up
- Personal.xls opens on startup...
- Conditional Formatting - possible in a chart?
- Ever Present Decimal
- Gridlines
- column labels
- ListBox Controls
- Field merge: Access to Excel
- Check out pack that comes from the MS Corporation
- excel sheet disappearing in IE
- Where to buy Excel 2000?
- conversion formula for TV Frame rate's
- Excel
- protecting formulas w/o protecting worksheet format
- Excel Date interpreting problems
- OLE Automation and Chart Location
- Import Excel to Access
- Tabling
- formula help
- Find a cell that matches the value of another cell
- Adding Functions perminmently
- Excel - Add Lines
- New LINEST For Excel 2003
- Re: OT: Microsoft Security Bulletin Release - November 11, 2003
- statistics
- creating a formula.
- "Too Many Different Cell Formats"
- change all to UPPER
- =[cell] returns 0 if blank - help!
- Find range of numbers in a column.
- Taste internet update from Microsoft Corporation
- Excel Icons
- Uppercase text to Proper text
- Can't change default file location
- Having a custom toolbar open with workbook
- Conditional Formatting of #n/a result
- Excel printing problem in remote location
- Can't insert column; keep receiving error message
- Moving between cells
- Add Ins
- looking up a cell via a formula
- Jumping to a hidden cell on enter
- Option Buttons
- Multiple Tabs viewable - same workbook
- circular reference
- Use critical package which comes from Microsoft
- Conditional formatting if cell contains certain words
- Combining Two Range of Entries into One
- email attachment
- Macro to highlight every 2nd row
- Show the Worksheet Tab Name in a Cell
- Calculate fees based on the percentage given
- highlight color using keyboard(shortcut)
- Sort, Subtotal, Sort
- If function help required
- AND conditions before summing up
- mail merge labels from excel database
- Pivot Table using multiple workbooks
- cell formats
- Array formula challenge
- using variables to select rows
- book query
- List of open accounts with Pivot table
- Protect cells from Move
- short cut for excel.
- automatically create another spreadsheet from template
- excel formula question?help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- Excel - Embedded links change when file is reopened
- Spell check & custom dictionaries
- Office 2003 Question: Auto Fill
- number format - align decimal point but not minus sign
- Drop Down List in Excel 97
- Excel Maximized Larger than Screen?
- Visual Basic command to write sequence
- how can I do a lookup into another sheet?
- Print range
- Printing 2 ranges at one time
- problem with numbers in vlookup
- Spreadsheets printing as a mirror image
- Mirror image printing
- Cell Ammendments
- Locking Formulas/accessing values in Excel??
- LOOKUP problem
- Protect sheet
- Forms controls
- Excel file name
- Exact match in vlookup
- large excel file
- Re: Change default number format
- Re: Change default number format
- Cannot get rid of startup sheet !!! HELP !!!!
- Double Numbers
- Finding missing numbers from a list
- headers in Excel
- tab not tabbing to next cell
- Null Value - $1,000,000 Question
- Cannot see all characters in cell
- 1 + 1 = 0
- Date Sorting
- Conditional formating
- Columns in Excel
- Compile error
242
vBulletin v3.0.5, Copyright ©2000-2009, Jelsoft Enterprises Ltd.