View Full Version : Microsoft Excel Misc
- Hyperlink from web page
- is xl worksheet multiuser
- Can I use 'or' in conditional formatting?
- Possible to change date format in header/footer?
- Copying Worksheet Problem
- Reverting to a previously saved version of a workbook
- Interpolation/extrapolation and lookup problem
- I can't seem to execute functions
- Zero suppression.
- result of Function to cut last 2 values out
- can not exit excel clicking on the X
- Excel : Counting on two columns
- How to turn off automatic toolbar appearance
- Accidentally Pressed Send Mail Button
- Fancy date calculation
- email Excel documents
- version of excel
- slow update on worksheets
- Date query
- Pivot Table Item Translation
- Excel/macro Formula Problem!
- Importing excel data into outlook
- Impossible task?
- Getting lots of IFs to work together
- Pivottable based on autofilter
- Re: Printing in Letter Format
- A formula that only shows the number of ex: "A" in a column and
- Personal Workbook
- Time and Dates -
- Goal seek repeated in many columns
- Sequencial dates in a column
- VBA code needed please
- excel print views
- page break views
- Using a macro on shared workbook excel 2003
- vba to check if a file on a server is currently open or in use by someone.
- Why Type "Mismatch"???
- Autofit very slow
- Formula to eliminate zeros
- decimals
- Reviewing Toolbar constantly Appears
- Sorting groups of info
- Macro - Relative Reference
- Pulling out string below certain cells using if statement
- insert or return
- Resetting Excel register to original factory default settings
- Compare Worksheets
- Scenario - Label
- Access Query Question
- Outlook contacts XP
- VBA Publications
- Re: Searching a column for info
- view
- Password Protection
- Moving Multiple Rows Between Workbooks
- Merged cells and filter/jump to
- Custom Views created in Excel 2000 not working with Excel 2003
- clusteres and stack charts
- Category counting
- Formatting PIck List
- Analyzing a string for alpha characters.
- Using Average Function
- accumulating entries
- How do you rotate a table 90 degrees?
- Re: Calculation using Time & Cost
- Tab Key order
- VBA Action on excel #Reference! error 4?
- Excel not opening spreadsheet entirely
- combining cells
- Linking Help
- Re: inserting bullet points in cells
- practical limits on Excel file size?
- Making the Comment Indicator Disappear
- Cool Template
- Saving linked workbooks to another directory
- Sharing and Security Quesition
- Protect and Share Questions
- creating sales order forms in excel
- formatting Controls
- Get external data-formats too
- Difference Report
- re: Footer character limit
- lost data
- import a value from another table according to a same cell ID
- TextBox
- Leading zeros stripped
- Convert row data into column data
- Locking rows (not columns)?
- Using the wildcard * character
- Closing Variations
- Help with referencing multiple sheets in formulas
- Format with specific RGB Color
- Excel 2002 issues with Outlook2003
- Need Help on Ranking
- Comment Fonts (once again!)
- Printing Comments
- Combo boxes
- Re: Conditional Formatting - If cell does not contain a formula
- Re: Text Totals
- Microsoft Shortcut Bar
- Nested Web Query?
- Re: Text Totals
- Re: Text Totals
- The Sum from 1 worksheet cell to another worksheet cell
- Sorting Cells Across Worksheets
- Auto Date Population
- File is too big...
- Hiding rows: meaning of dark line?
- Re: Importing to Multiple Sheets from Access
- Excel Macro Weekday / Today Function
- How do I create a hyperlink from a button on a worksheet?
- Tracking my cell location
- From Column to Row
- Default Method Of collection
- Track Changes compatibility between versions of Excel
- Lost Macro Option
- Linear interpolation between nearest values -> must be able to extrapolate too...
- Rotate XLS table
- Repeating text in Cells
- reference cell above even if row deleted
- Linking cells and adding rows
- between calculation?
- Re: text in combo boxes
- Re: Conditional Formatting - If cell does not contain a formula
- Seperating info in cells
- Conditional format
- Re: Sorting Cells Across A Worksheets
- Re: Conditional Formatting - If cell does not contain a formula
- Excel VBA "clearing house"
- How do I summarize several different worksheets into one single Table.
- Use Easy Batch Watermark
- stumped: For- Next Code doesn't work?
- coloured cells
- Keyboard shortcut for cursor
- Filtering data
- Long time to open Excel
- IE 6.0 home page
- Compile Error
- Find first empty row
- VLookUp, empty cells, and zeros
- calculations between days
- Using a calculated vale to define a range
- Printing Duplex
- re: text in combo boxes
- Forms????
- Advance filter not working
- Cell Validation Based On Multiple Lists
- Copy HTML Tables to EXCEL
- excel vba--slow worksheet
- Cell Number Format
- protect and share file
- Formula Help
- Subtract Dates
- Exporting from Excel to Space Delimited File
- Problems with reading date/time format from SQL server
- Inserting a row after every seven lines
- Copy 1 Row to Multiple Rows
- Deleting Cell then Shift Down?
- Controling space when exporting EXCEL to text.
- Need Help "0N125415"
- add up the values in the cells containing large, midcap, small cap
- multiple calculations
- time format
- Problem with code
- First Name Extraction
- Macro task
- Link to Word Documents based on Styles?
- Vlookup based on 2 criteria
- N/a Error In Excel 2003
- Extracting single data from a table
- Adding days to a date
- "Confidential" in middle of page
- A simple macro to make every 3rd row a specific background color???
- Re: Using Advanced Filter to expose rows having empty cells in anumeric field. Thanks
- Custom Formatting to Concatenate Two Cells
- Excel
- macro needed
- Sumif formula question
- Saving issues linked to version?
- Sum Function
- comparing hours using if function
- Group Time by Categories
- Two Lookup Values?
- Re: Vlookup Challenge
- Re: Vlookup Challenge
- Updating Excelsheet with conected VLOOKUP sheets time consuming
- Pivot off a pivot table
- Multiplication Error
- Re: Using Advanced Filter to expose rows having empty cells in a numeric field. Thanks
- Re: removing duplicate entries
- Re: Rounding numbers to a specific preset nearby number? Is it possible?
- Save causes Excel to stop responding
- Convert Time: HH:MM to HH and tenths of hours
- Re: Rounding numbers to a specific preset nearby number? Is it possible?
- Excel XP hangs while inserting package
- How to create a clear button?
- EXCEL TO OUTLLOK
- Automatic Updating of cells with formulas...
- Hyperlinks
- MONTH() Function
- Formatting # in one cell
- Does this require programming? If so, how? :)
- Need to Prevent a protected sheet from being copied?!?
- Cell does not widen enough
- Listing linked workbooks
- sizing graphs
- Re: Macro
- Re: View Sheet
- Re: View Sheet
- Autofilter stops working
- How to filter rows with commom Nš's in any column
- Data and Label Source
- Solver
- protect from deleting
- RE: View Sheet
- Find customer number and delete row
- blinking or flashing cell or cells
- List Box
- Associate cell with micro?
- How to Create Dynamic Range in Formula
- color of outline of active cell
- If then statement
- List Box Items
- External data err
- HeLP!!
- Obtain Row reference via VLOOKUP()
- Date & Time file was last saved
- select cells based on color
- Fill color in autoshape based on cell data
- Find Blank Row and delete all records below it
- Macros disappeared
- SumIF function
- Unprotect, refresh, protect again
- How from Word a list separated by commas convert to Excel?
- Re: dictionary
- Re: color of outline of active cell
- change caps to sentence case
- Macros with databases
- excel 2000 overide
- Re: How to create a clear button?
- julian date
- Edit Find defaults to rows
- Size of Excel file Access db exports to.
- F4 key
- Re: Associate cell with micro?
- Re: Associate cell with micro?
- Creating Ratio's in Excel
- Text to Columns on all Columns Starting w/"E6"
- HELP!!! EXCEL!!!
- vehicle maintance report
- Pivot table question
- Another pivot table question!
- Excel help2
- need help with a code please
- Data Entry
- Way to output text file from '97?
- Count the number of orders in a given month
- All Caps when data entered?
- Problems Query with MSQuery
- Pivot table calculated field using MAX of another field
- How to unhide a hidden field
- Linking two spreadsheets with different print format
- Saving a worksheet
- Splitting Cells
- Total the Value of Orders in a given month
- Finding the low value of a range of values
- Lookup value problem!!
- date
- "Too many fields defined" error message
- compiling lists
- Excel File Save Issue
- can someone please help....
- Password to activate buttons
- auto filenames
- Cells font colors
- error, chkdsk
- Form Creation To Track Investments
- Clear Cell Format
- dynamic range not working
- Bypassing macro warning messagebox
- reinstall
- reinstall
- Locating an Excel combo box range
- Compile error in hidden module
- Calculated Items in Pivot Tables
- view code & properties
- Filtering
- pivot tables in excel 2k
- Help Needed for Groups Please
- CRYSTAL REPORTS FORUMS
- If/Then Question
- Record value, drop it & record again
- "Excel VBA - msg box problem"
- Convert numbers into text (one thousand two hundred)
- I need to get Excel to check dates for membership expiration and flag member if
- Placing headings automatically at page breaks
- VBA UserForm question
- weekly cash flow template setup - Help!
- format cells for date not working...please help
- archive
- Code for making Excel beep
- Sorry
- SaveAs (Archive)
- Worksheets and Save
- Extracting Data into a table ?
- Why do the sheet tab move to the very left?
- Perpetual Inventory
- multiple workbooks with common structure
- Close the Program
- An interesting challenge....
- range changing
- Worksheet_SelectionChange goes cold
- Pivot Table - Text column
- An interesting challenge....Part Two!
- Autoshapes defaulting automatically to 3-D
- Auto email response/Help me
- Set curdir from where template was opened
- Excel File Name Auto Change after Access
- cell selection stuck on
- Re: Display Access Query in Excel
- Grid Search - range data
- ADO.NET and FoxPro OLE DB multilanguage problem
- Is there a way to control the height of a row via an excel function?
- Remove all characters but numbers
- Work menu in Excel?
- Capitalisation
- Creating a form
- Consolidating sheets
- extracting numbers from other cells (search)
- set cell value and workbook Creation date
- Window content disappears after saving
- =SUM Function
- Printing a "tree structure"
- nearest round figure
- Match and lookup data
- Linking makes sheet disappear
- consolidating workbooks
- Saving part of a data sheet
- Working with dates
- Mail Merge !!!!!!!!!!
- Is This Possible?
- Insert blank row to seperate weeks(autofilter on)
- Blank, Null, Empty?
- Excel Grouping & Protection
- Calculating Days worked in a month
- #N/A in the sum total
- Sorting Alphanumerics
- Opening XLS files from within explorer
- Pivot Table report formatting
- excel formulas
- Random Sample of Data
- Excel 2000 attachments coming as .DAT files?
- Conditional Formatting
- Increment a duplicate when found
- Gradient fill on a worksheet...
- Help: Joining Two subroutines
- Is there a better way to do this macro code?
- calculating and displaying time
- Strange Excel Behavior
- Changing Titles by a formula
- Re: Summing highlighted cells only.
- Re: Summing highlighted cells only.
- Re: Summing highlighted cells only.
- How to apply a formula accross all the rows when the total rows are too much in no. ?
- Checkboxes?
- Selecting more than 30 cells for sum
- Compare 2 arrays of data
- Color shading
- Multiple Users Able To Open Same Spreadsheet Simultaneously
- SUM with an IF
- ENTER button
- Combobox
- Can't edit Excel document in browser with macros
- Referencing between worksheets
- Same formula with different variable
- Paste-Link Problem
- save as cell reference
- Sorting rows horizontally
- displaying stats on a chart
- Re: Automatically increasing numbers on printing???
- Formatting errors w/ imported dates
- replacing #N/A values with -
- OR function
- Drop down boxes
- List Box - row hight - more space between items
- Pivot table - drag field in layout
- Confirm Delete in a macro
- can a column for 2 different words and display a number based on how many are found
- Multiple Password Administration
- locking a spreadsheet
- small problem with save as
- writting numbers
- GETPIVOTDATA excel97
- Spreadsheet not displayed - v.2003
- XL2000: Altering Pivottable Cache
- Look up functions
- Installing all excell functions ...
- Excel 2003
- More Date problems
- Sorting question: Probably not too common
- is excel multiuser?
- Re: EXCEL.exe has generated errors and will be closed.... Help. :)
- Sequential series 'check'
- Excel Question
- Swap cell contents
- New Workbook based on Template
- Conversion of Works Spreadsheet
- Pivot tables - adding data
- Help! Can't retrieve important documents
- Adding
- Adding
- FWIW
- Accidently "SAVED AS"!! Help!
- Cell Locations On Sheet (measurements)
- Initialising ToggleButtons
- Calculating variance.
- could someone help me with design of a sheet
- Datetime of Excel-document
- Excel 2000 & NAV 2003
- Microsoft query returns no data, Office 2000, Excel
- Timestamp on cells
- Match and lookup data
- Excel/Powerpoint
- Vlookup
- formatting a text column
- pivot table
- Expandable Text Boxes
- Fill Series Disabled
- MS Query - Date/Time - Need to average values for day
- EXCEL - INDIRECT (formatting the result)
- From Rows to Columun
- From Rows to Columun
- From Rows to Columun
- rows to columns
- Calculations
- Import from web query problem
- sorting data with two rows as column headings that reamian as headers
- Show Date File was saved
- Help with a date!
- Converting to PDF: Hyperlinks
- Indirect and Address Functions to Determine Schedule
- Indirect and Address Functions to Determine Schedule
- Indirect and Address Functions to Determine Schedule
- Hide many rows without loop?
- Macro help!
- Combo boxes
- Wildcards
- Conditional format grey text prints black
- Screen resolution changes
- "between" comparison operator
- matching part numbers dispersed in two columns
- drop down lists
- Count Bold Numbers in Range - multiple rows
- Excel mail merge
- Invoice setup
- Summarising data
- Vlookup
- Excel lookup table assistance needed
- Sorting with dashes/hyphens/-'s
- I need to limit the number of rows
- Column to CSV...
- Need help sorting linked cells.
- Excel Downloads
- Linking Sheets
- Re: Text disappears
- vba to show the file save as dialog box...
- Strange button and data entry
- Macro Dialog Box Drop Down Options
- dead links
- file won't open
- Double Space Cells
- Double Spaced Cells
- if, and, or "or" statement
- Printing Copies or multiple worksheets produces mult jobs
- reply back to the person who helped you
- Relate cells
- Workbook OpenText File command
- Renaming Workbooks
- Links not available
- cannot change part of a merged cell - error
- MS KB Article - 824424
- How do I get a month name out of a numerical format? (5/1/2003 = May)
- Using Excel with multiple monitors
- Invoicing
- "Too many records" refresh problem with pivot tables
- Determining duplicate values across multiple columns
- Re: Multiplying a range by a single number
- Re: Multiplying a range by a single number
- Re: filling cells
- RE: filling cells
- find and replace text
- Naming a sheet w/ data from worksheet
- Data Validation
- Get query from Access
- Drive Links - Changing Drive Letter
- Subtracting with a twist
- Lock cells but allow data entry ONLY!
- Re: retaining the current value in a cell following if function
- Re: retaining the current value in a cell following if function
- Auto recovery
- Exporting Text
- VLookup
- Re: Displaying column width in inches
- Work Out Original Value From A Percentage
- Data Interpolation
- Macros that solicit user input data
- Macros from custom buttons
- Error handler with screenupdating = true?
- Formula to big
- Re: Displaying column width in inches
- Dcount - using with dates
- copying into words
- removing hypens to make phone No. for another program
- Linear Fitting
- macros
- HELP
- Macro Help Tutorials
- Mail Merge/HELP!!!
- Cell value not recognize in an expression
- How to convert 24 hrs in a format, where i can use it to divide,mulitply etc in VBA ?
- Re: Serious Problem
- Re: Pivot Table Pages
- date formatting changes
- CONVERT NUMBERS?????
- Duplicates
- Opening Microsoft works files with excel
- XML Schema
- Finding duplicate names
- Another interesting macro challenge!
- Arrange Worksheets
- Formating of Date
- Importing .NET SDK lib in Excel
- Totaling Invoices by Date
- Command button moves during printing
- totaling purchases
- Service Call Tracking
- Windows Explorer, Excel 2000, open as Read-only
- Retaining formatting in workbook
- Custom View of worksheet in different workbook
- Drop down changes
- how to do self-defined regression in excel?
- true/false output problem
- Links
- Auto changing of Excel file name
- Cannot Empty clilpboard
- Use the "Countif" Function with a combo Box
- why my comma style icon....
- image is resized on print preview and print
- Compare columns of text
- Frozen Text Boxes
- Auto Numbering
- how to copy&paste range with formulas which are without frozen cells ($) ?
- How do you unhide multiple sheets at the same time?
- Horizontal Scrolling
- Filling down
- Data Sort
- Re: Percent change - How?
- combining macros
- Running batch files (with spaces) from Excel
- Running a .bat file with spaces in the path.
- Do E2K "comboboxes" work like in a db?
- Row Deletion
- Enable Auto Refresh Excel 2003 - Keeps Prompting Me
- Auto fill a table, how?
- duplicate data entry
- Deleting specific Rows
- Data Management
- Combo box links
- Saving module as .xla
- Time format in Excel 97
- Shared workbook.Does anyone have problems?
- Where's the Sort by New Message option?
- Question about cell assignment
- Pivot Tables question
- Refreshing cubes
- Calculation does not consider newly inserted data
- Adding the DAY to a Date field?
- Tasks in Calendar view
- Deleting Duplicate entries
- Export to CSV format
- Data List
- Look up or matching data
- Calculation does not consider newly inserted data
- Leading 0 in zipcode dropped when mail merging with Word
- Counting values based on another cell
- Excel Get Data - Unique Records only
- Outline Formatting of Spreadsheet
- delete image
- Conditional Formatting
- Losing last zero while formating numbers to text
- Math with Dates?
- Data validation
- Manually Registering an Excel Add-in
- Formula
- Splitting data from one column into multiple columns
- Macro Relative Reference problem
- Auto Filter not showing all the variations
- Copying a formula problem
- Problems using outlines on a protected sheet
- SendMail Macro
- column formula - help needed!
- emailing as attachment
- If/Then in a Function?
- Locked by User
- Make Worksheet Reference in a Formula Relative
- Julian Dates / Calendars
- Unreadable Comment Boxes
- fixing phone list
- VPageBreak
- Disappearing Columns in Excel that aren't "hidden"
- Pivot Table Help - Data Manipulation
- Formatting
- cannot open excel book
- Opening an Excel workbook from Access with new data
- concatenate or 'Replace'
- Age formula
- vlookup on cell below
- Page Setup in Page Preview
- How to Gid Rid of Annoying Links Quickly?
- Macros
- Data Validation
- Levels of indirection
- Running a mcro based on value of a cell
- Hyperlinks not staying connected
- Pivot Table Question
- Exporting with spaces
- Cell Shading / Font color not working
- LOOKUP not working
- Hiding a worksheet
- REF error message when inserting new rows
- drop down combobox
- Can I create a FORM (that I can modify etc) from an existing spreadsheet?
- REF error message in formula when inserting new rows
- sum of rows...
- comparing two spread sheets
- comparing two spread sheets
- Lookup Formula Question
- Add Button in Excell to sort Data
- Pivot table sorting problem
- Lookup a table
- Please help with a basic question! (I hope)
- #Name? error after opening file
- #Name? error when opening a file
- #Name? error when opening file
- form in Excel to save information in database
- Printing Tiles have Page 1 ... Page 2 ...
- draw a forced straight line
- draw straight line
- comapring 2 seperate workbook
- Basic Format Question
- How to name the range that has been filtered?
- Worksheet password
- How to unlock power of Office 2003 to archive, re-sort and publish
- Change "Text Numbers" to "Numbers"
- Can't record Macro
- Re: Include formatting in a formula
- Force text to extend beyond cell boundaries
- Excel is slow by loading printers
- Dynamic formats/formulas
- Insert a figure waf. IF statement
- Reference to pages in a Multipage Control
- Counting in Excel
- elapsed time v. target
- Calculate Due Date
- Position in a table
- Temp files appearing on the recently used file list
- conditional counting
- More than 8 cond. in IF-formula
- Auto-changing of Excel Files' name
- Macros and Autofills problem
- Formula problem
- Excel-Linking Cells & Formatting
- Why my Sub not work?
- Plotting a Graph as S-Curve
- excel conditional formatting with values rather than colours
- pasting formulae to entire column in macro
- Insert picture in a comment
- Locking certain parts of a spreadsheet
- Calculating Profits
- delete a row
- Corrupt file?
- Adding numbers with #VALUE! between
- Formating cell
- Portrait AND Landscape
- Excel Date - Help
- Edit/Replace using VBA in Excel
- Delete row macro
- Find File Fast
- sumif function
- Database question
- Pivot table error when trying to refresh data
- Delete row macro
- Generating multiple invoices
- Grouping dates in pivot tables
- excel vba - protect sheet so no copy/paste ability
- RE: Printing
- Re: Printing
- Re: Printing
- Excel tab as windows
- Row value zero
- Copying and adjusting formulas
- Extracting Data from a Database, but skipping rows
- Online Form which will track data entered in a database
- Incompatibility between versions and operating systems
- extracting unique #'s from a list
- Calculated fields problem
- Pivottable Uncheck All
- variation on PRICE function
- Undo a Pivot Table
- Calculating absence periods in a rolling 12 months in excel
- Increment date by 12 months
- Combining data
- External Data
- populate cell from worksheet name?
- Cell containing formula won't resize culumn width
- align numbers with comma and center within column
- Re: FORMAT via a formula
- Macro Warning Message
- debugger, how do I turn it off?
- Unpredictable Cursor Change prohibiting input
- Cannot display Excel attachment in Outlook
- Switching dates to end of month
- Worksheet event change
- Referencing Database tables with excel functions
- stop multiple worksheets opening
- Formula to Value
- Email
- Password protected
- text and data in same cell
- Adding new rows including formula
- Validating different sheets from 1 location
- Creating Button with predetermined function code in a wksheet with VBA
- auto save on excel
- Headers in Excell
- need to insert file with macro
- file size question
- excel comment issue
- Problem with toolbar area--Tough one!
- Find Ranks
- formula for money additions & subtractions
- Map in XL
- excel to access without linking tables
- Long formulas (Excel 2000)
- Running macro when starting worksheet
- Print Preview
- Conditional Formatting
- Meaning of message
- Cookies In Excel
- Summing numbers between a date range
- Merging Multiple columns into one
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.