Microsoft Excel Misc

lookup data in a different workbook
Complex numbers
Re: Pivot Table totals
Re: Use text as reference
Combining Tables
Slightly Different Extracting Text from a Cell
Info("Directory")
Macro use in different location
cell reference changing when row inserted
Clearing all items in a Collection
Clearing all items in a Collection
hyperlink formatting
Print preview only showing first page of multi-page spreadsheet
Unique question...
Network Path/Excel Open Dialog Problem
column header not recognized in sort
Re: Referenced cells converted to absolute
SBFM40.xla
Hiding sheet tab names
Future Value of Increasing Payments
Switching Horizontal rows with Vertical columns
Using multiple conditions for a formula
Delete rows unless meets a criteria
Comparing Text Fields and returning a cell value on a match.
Assing a value to a cell conditional on another.
Opening Data Base as a Program
password
lists
VBA - could it override defaults in excel
Alignment in Custom Number Formats
macro help
Scoring 3 Columns
Re: Print preview only showing first page of multi-page spreadsheet
Increasing the speed of Sumproduct
Y axis labels
Multiple windows
Macro - transfer data from excel to words
Editing a shared spreadsheet simultaneously
DIV/0
Re: Making Columns into Rows in a worksheet
lost data when opening excel workbooks ; text import wizard popup
Re: trouble with histogram use
Index page
Excel - applying formulas to data copied from internet explorer
Re: DIV/0
Save As Web Page
shortcut for highlighting cell(s)
Exporting cell info into IE text box
Help with dropdown menus
Summary on one page
Hiding functions in cells problem
How do I print a spreadsheet so that inserted comments are printe.
sorting data from pull down menus
Saving Workbook in 'All Users'; 'Desktop'
dave peterson
Base a cell value on another cell's value
Excel to Quicken?
Hyperlink Question?
scrambled excel file
countif formula
Insert Menu has got disabled?
VBA for Excel
Default Formatting Settings.
Excel Fonts
Is excel upgrade 2002 compatable with works suite 2002?
Finding last row in a column
Start with the search window open
Margins in Custom Header
How to Mute/Enable Windows Sounds whilst running VBA code
Is Excel this Intelligent ?
#NA
eReference Embedding
New line in a cell
VLOOKUP & error problem
vertical line in graph
startup files
assigning a value
Automatic Sorting for a newbie
Hyperlink ("Text to Display")
Can I make "Row 1" "Always on Top?"
Merge Rows?
HELP PLEASE
Desperate help for daughter
creating a data feed for froogle
Excel auto format
Disable Print Alert
Finding Text String Within A String With A Formula
importing a text file with addresses ... looking for an easy way
Excel Help for $ ! :)
minimum function
Selecting the Active Column
Font Formatting: Superscript
Formula for deleting "
payroll template
Importing column in comma saparated values.
unprotect sheet, pssw unknown?
Return Date and Time on save
Launching Excil with default Spreadsheet
Save Automatically Every 10 Minutes or Prompt to Save
Combo Box-date format
cell reference changing
adding a date popup box
Import Data
Anyone one setup the PAYE scheme in Excel?
Password Protection
How to make Excel 2002 sp3 save a backup copy (previous state) of a file?
Formula Subtracting dates to come up with number of days
Formula puts 1 to X value then starts at 1 again
weird pastespecial (values)
tabs in excel file print in weird order
Opening workbook as sheet inside multi-sheet document
Drop-Down list
Compare cells
Ctrl Select and Copy Paste
System Low in Resources Help
I need a formula to do a league
File Size
AutoComplete in a large worksheet
Merge data from multiple worksheets
Pass Parameters in Hyperlink
Re: colour code tabs
Re: colour code tabs
Compare two worksheets
That damn reviewing toolbar
Re: Print problem with Excel
Quick Little Formula Question
Error in formula for two IFs
Is it possible to recover a file that's been saved over?
Re: How can I Synchronize Excel Spreadsheets??
Document not saved
Latitude/Longitude Conversion
find data and autopaste when found
Removing Extra Pages
protection on excel
Extracting Excel Worksheet from Word Doc
Re: Protection with excel
Re: SumProduct and 2 criteria?
Default Print Quality setting in Excel
Protection with excel
exporting categories - excel
Creating a file of Directories
Future Value of Increasing Payments
Personal and Professional Training
Reset Formula to Use Cell Address Not Cell Name
VBA Help Files
THIS SHOULD BE SIMPLE TO DO BUT I CAN'T FUGURE OUT HOW
Re: How do I disable the warning message when I delete worksheets in E
How do I disable the warning message when I delete worksheets in E
Text don't fit in a cell
Customizing Help/Office Assistant
Inserting info to be carried forward
Excel 2003, Cell Select becomes Column Select
Unable to delete files
Setting a Cell's Value Based on Another Cells Contents
Search engine optimization
Calculating Time Dependent User Defined Functions
Excel file unable to read from morning to afternoon
Now() Function in MS Query
Re: Vanishing VB
Give each value in a comma-delimited column its own row
Formulas as text or zero
Re: Cell reference doesn't change when list sorted
PivotTable report loses formatting on refresh
I'm offset by the Offset Function
Pivot table data dissappears
excel on the net
Save as html
Locating Value Pack Add In on the web?
XL 2003: Text to Values
about my disabled 5 tear old
GRRRidlines!!!
weekly timesheets
How do I obtain decimals instead of rounding?
Unwanted graphic (?) appearing on spreadsheet
Aligning objects
Midnight disappears
Clearing Clipboard in Excel 2000
Spreadsheet Review Macro
IF statement help needed
Date with Autofilter
How to Rename a module using VBA code
Excel VB or linking a database(if poss)? getting product names from their codes
opening excel is taking too long
Switching Names Around
Memory Leak when copying charts to another worksheet
Hiow to get all data in one column ?
conversion into indian rupee
Excel2000: A problem with Named Range/Function format
Linking ActiveX Controls
Check boxes move after printing
Problem with IF formula
Lost Toolbar!
csv-file-lines back to excel rows and columns - HOW?
remove from Pivot table items deleted in the source data sheet
Task Pane
How to print in a non-TT font?
hide formulas
maintaing headers in sort
find text string
Conditional Formatting
EXCEL Mask for data entry
validating macro
Hide Rows
Recognising cell values
OFFICE 2000 - Sheet Protection, CELLS.
Columns and rows are numbered
Text Entered in A Cell Sets Another Cell's Value?
Formula to return non-zero values in a list
Incorrect sort
Difference between Excel 97 and Office XP
Automating row grouping for 1200 rows
Lookup in previous year
Insert Rows between each row
Web query to return html source code?
Excel Add in Solver
Date problem
Formula
Links between sheets
excel spreadsheet to word
Mutiple Condition Lookup
Re: Module Listing
Publishing comments in spreadsheet
Making font to be in small size
drawing objects removed
excel vba - problems protecting sheet if changes made
Re: How do I use document properties in Excel Worksheet page headers
MID command
Re: How to Create a "Save Button"?
Re: Alternating Font Colors
Re: Excel Columns format
Re: Excel Columns format
Comparing 2 Excel files
VBA Help Files
Multiple worksheets - Pivot Table
Column Widths
Filltering data between two date ranges
comparing values
Excel on my Palm Pilot
attaching toolbar to add-inn without using code?
Drop Down in every cell - up to 250 rows
Min/Max-Function for Strings
Excel
text format problem after copying from a web page
Problem with time in excel
Re: Named Range Dialog box
Formulas won't go away
page header in excel
Custom functions-Reg
Converting rows of data into columns
linking rows on sheets without empty rows in between
Multiplying hrs worked by cost per hr
how do i auto delimit commas ?
Dates column Is this possible
Pivot table drop down lists
Excel 2002 - Network share - save as error
Re: Formula for Percentge of a variable
Excel - Array Formulas - Freeze - VBA Tip?
Filtering Excel Data
Active x combo box and linking
How to remove all cell shading
I won't pretend I know what I am doing
EXCEL 8.0a VBA Help files
EXCEL 8.0a VBA Help files
How to make characters small
How to make large characters in some cell range to appear small
Pivot Tables - how come they stop responding?
Sorting Zip Codes
How do I convert degrees F to degrees C in more than one cell at .
Character Returns
Re: Excel 2002: drop-down lists
Go to Last in Column
personal.xls read only opens when I launch excel
Cannot Find File error message
RE: Conditional Formatting
Re: Interactive Spreadsheet
How do I do THIS? (with img)
Re: capitalize selected text in excel
Identify column in pivot table by data name
Re: How do I search a document for an Asterisk
Option Button question
julian date
data from closed workbook password protected
Select a row, copy and repeat on the next row
VBA Help Files
Distinguishing blank cells
Re: Looking for way to get distances between street addresses in excel
Using text to colums, but need to keep decimals
I cannot send a fax from excel, I always get a line busy message.
Re: Changing Links via combo box
Re: strikethrough on all of worksheet how to remove this format for a.
Forced text wrapping
Keeping track of changes
Question on Isblank
Merging Lists
Can't open spreadsheet
linking workbooks
My task pane has disappeared!
How can I creat a combined sheet using the data in other sheets?
Disabling Right Click Menu
Task pane is gone!
Analysis toolpak addin
Sumif
import UTF8 to Excel
keyboard navigation - what action for f2?
Here is a real challenge!
Cells won't calculate
Save as Web Page
Identifying Dublicate names and addresses in Exel data base and r.
Go to macro?
lost data....lost person!
lost data....lost person!
lost data....lost person!
need help with vba, sum of vlookups
converting a number into text
Macro to save in every workbook
CSV file in Excel 2002
excel find problems
Move information from one sheet to another sheet within the same w
Character Counting
Textbox Copy
how do I copy calculations outside of a pivot table
calculate material usage
changing the delimiter while saving as txt file
using various data from a source outside of excel
Control Forms - lost a tab
Multiple criteria
Can't open file in Excel - 70MB - Options?
Re: Problem with Header in Excel
OFFSET Formula Trouble
CNA turns into CAN!
Printing on multiple sheets
Assigning month to number
Pivot Table
WORKSHEET CLOSE NOTICE
Indent formatted cell
sorting in Excel
help with formula
Re: how do i include text at the end of a formula
Re: how do i include text at the end of a formula
Excel Template Wizard?
autofill in a macro
password help
Re: SUMPRODUCT - 2 columns (one date one text)
Macros slowing down workbook
OT - FYI - XP, SP2
Moving data from 1 form to another
Counting/Adding rows
pasting info into multiple columns
emailing Excel graphs vs PDF files
Add watermarked page numbers?
Re: Printing out formulas within a worksheet
Working with check boxes
Dates
additional formula ?
Re: multiple worksheet protection?
Re: multiple worksheet protection?
multiple worksheet protection?
Get part of the Address
Maximum # of columns in a worksheet
How do I disable worksheet close method
Excel Sort Formula
Help: Multiple Transactions for Multiple Accounts
Auto refresh pivot table
changing specific excel file icon
How do I disable the workbook close method
Re: Multiple Criteria - Data Validation
Forms Toolbar-Excel 2003
Custom Views
Update Page During Hyperlink
text is being interpreted as a date
Using iterations to calculate circular references.
Administering a test in Excel
Miscelanneous
Macros for Beginners
excel vba - unprotect sheet to format cells
workspace
When scaling the page size, how do I not also scale the headers a.
Page Numbering In Excel
Any good book recomendations
Macros for Beginners
Echo off
How do I produce a mailing address list in excel in comma format?
Re: How to secure some specific cells from any changes?
Likning checkboxes to multiple worksheets
Linking checkboxes to multiple worksheets
Drop down lists and you
VBA to format Imported Text Document
Re: Format date to show day-of-year
Re: How to make date appears automatically in a column?
Re: Worksheet Pasge Numbering
Clarification
Column numbers to letters
Re: Exceeing 100 field limit with Data Tracking wizard
Auto Update Properties
Re: Format date to show day-of-year
Convert column values into a single cell
Re: Exceeing 100 field limit with Data Tracking wizard
Deleting files in a macro
Re: Print a column across rolls
Quick Question: How to come back to original cell location?
Re: Format date to show day-of-year
Can I make a shortcut key to open Excel?
Maximized vs minimized
ways to search for data...
Find vba problem
accessing autosaves after closing program?
Simple linking cells issue
Re: Format date to show day-of-year
Save As
All open excell spreadsheets close when I click on the big X in the upper right
Re: Print a column across rolls
Re: Printing out formulas within a worksheet
Re: multiple worksheet protection?
VB Macro: How to create a loop to change a number in cell
Re: Print a column across rolls
How can I get web-service data into an Excel spreadsheet?
Save As Macro?
Splitting of cell contents
Re: Format date to show day-of-year
too many formulas causing slow workbook load?
Formatting Date in Header or Footer
formula ?
microsoft excell file converter for quatro pro 7
Converting Excel to PDF w/links
Formatting &Date in Header/Footer
Excel behaving strangely
A way to remove several reoccuring lines from an import?
custom series for class schedule?
MATCH function
scanning document into an editable format
o.c.r.
Round The weekday
Formatting Zero Values
Scrolling with stationary selection box??
Sorting with PivotTable
ISError with VLookup
Custom Views For Filtered Criteria
League tables, collation and sorting.
Working with check boxes - Thanks!
how do I repeat page layout on each worksheet of a workbook?
Data List
Black lines in Toolbars
How Excel interprets exported dates from TAS Books 2?
In Excel I want to create a Worksheet menu bar to limit users to .
To Greg Wilson Re: ScrollUp & ScrollDown
Show if worksheet is Read Only or not
email using excel vs. pdf files
Cell Alignment
ExcelexporttoOutlookproblem
Xls does not appear
sort that will only contain conditional formatted cells
Calculation Problem
Adobe Writer 6.0
counting based on another criteria
How to assign index number
Workbook Page Numbering
Modified Date
formula for ranking statistics
Excel Pivot Tables
Next sequential number on a different form
UnHide WorkSheets
macros
imported records
VBA - Path of the excel file
Dcount
Pivot table "save data in pivot table" option
Page Breaks and Drag & Drop - FYI
Numeric to text conversion
PASTING VALUES
Save as webpage
Re: Macro to go to cell
Help with running a macro in hidden cells
Calculations in Pivot Tables
Sending cell contents thru lotus notes automatically
Macro to go to cell
Limiting Size of Text Fields
Custom Page Sizing
new user question - print multiple page with the same column titles
Re: converting odd formatted date to excel usable date
Copying text gives me date value.
Lookup returns text?
When I filter data, sometimes I do not get row count retrived
Dynamic range (column); include only rows before blank row above more data
How do I use the same BeforeClose event on multiple workbooks
Opening files
when making pivots, is it possible to...
when opening a mail merge document.
Re: Range Reference
Form & Data Entry set-up
Naming a worksheet after a cell valu
Re: Changing excel query db location
Repeat Page Set-Up
Default Date Format
After upgrade to execl 2003, Insert Object very slow
Naming a inserted Worksheet
Re: sum formula does not tally all values in column
Problem writing a macro to Hide Detail in a Pivot Table
Background in Chart
re:How to display a very very large text in on Excel Cell
Summarizing data into single table from different sheets
Flexible Number Formatting
RE: QueryTables/DataRange disapears on refresh or edit (Excel 2003)
limiting data in a pivot table
Re: How to display a very very large text in on Excel Cell
Re: VBA Loop Until Sheet =
Leading zipcode zero gone when saving as a dbf file
Problem when copying cells that reference other cells
Leading zipcode zero gone when saving as a dbf file
Multiple Records Into A Single Record...
Re: VBA Loop Until Sheet =
Re: De-dup'ing a list
Formatting Cell Text
Adding text after formula or function
Re: cells find
Excel and Printers with Mailboxs
text numbers as dates via OCR import
Re: Need to know how to use a combo box or other 'active x' controls.
Moving Columns to Rows
Months
dual lookup pages
The top things I want changed, fixed, or added to the next versioE
Re: EXCEL GAME
Re: converting odd formatted date to excel usable date
Excel 2000
"Margins do not fit page size" error, but I'm not printing!
Grouping by both Month and by Week in a Pivot Table
Re: converting odd formatted date to excel usable date
Matching cells
date problem--excel changing entry
drop down arrow missing on pivot table
lookup tables
Complex data organization (has example)
show header
apply same custom header to all sheets in a workbook
Excel
formatting cells to show time format
Excel 2000
Brain Teaser in Excel
Multiple SQL Queries on one sheet
Multiple SQL Queries on one sheet
Pivot Table - Try to highlight ALL subtotal rows all at once. How?
Need additional columns in worksheet
excel with another reporting tool?
how to see these forum threads in newsgroups?
User Conditional View
lost conditional formatting
text above and below an Excel spreadsheat
Converting files
How to keep a running total on a col that has frequent new entires
excel file to cd-r is read only
excel file copied to cd-r is read only
Opening Excel Files
Excel Worksheet menu bars customizing for limiting users to optio.
Range names
Auto Filter based on cell value / drop down list
Re: Changing excel query db location
Compare two lists
Sheets copying
Sortng Custom Views
Hide certain rows
Listing Unique Items
Filter
The date a cell is modified
Slow VBA macro
Excel formulas
Date problem
Search on conditional color Formats
protect document
Landscape vs Portrait
Set Keyword
Zipping Excel files
Adding a ' to the front of a column of numbers
match cells
How to delete data
files can't be open in excel2000
Font colour not being picked up
Substracting two datetime cells
Re: Force Write
Can't stop Excel help autotile :-(
column headings have changed to numbers.
Excel File
Re: Hiding sheets based on user
Excel newbie request for help (sorting columns)
need recommendation
VBA Find Method problem
Filling sliding accross and along columns
Applying formula's to many cells
Matching values in 2 Columns
why is this happening, how do I fix it?
Deleting a link
lookup value based on multiple criteria
Workbook SelfDestruct
many sheets from "master data"
Help with a combobox and array
Copy Paste turns numeric string into Scientific Notation
search feature not working
Named Formulas - restrictions ?
clear old items in pivot
Elapsed time claculations
elapsed time calc
Converting e.g. 28-07-2004 to recognised date format
Extract SSN's from a free form text field...
Retaining highlighting when focus changes
Remove the square symbol from spreadsheet
Excel cannot complete this task with available resources
Shared Workbook
Re: Import Data Default Directory
Re: copy from 150 diff xls files and combine into one
Imported formatting affecting advanced filter?
Row Height dependent upon PC's font scale
Problem with Excel 2000 Pivot Table in Excel 97
Microsoft Works 8.0 - new !
Re: Print 2 worksheets in one workbook
Re: Print multiple worksheet in one layout
Eliminating the single quote generated
Re: VBA
Re: Print 2 worksheets in one workbook
Re: row printing options
Using a named range in a Sumproduct comparison
Print 2 worksheets in one workbook
Data transfer problem
Formatting Worksheet Rows
File all of a sudden Read Only??
Calling a pic!!!!
Spreadsheet Expiration After a Given Date - possible?
Test creating a new message via Outlook Express
commission template?
summing periods
Automatic Calculation Problems
Clicking on email link opens multiple IE pages
Excel Message
Protected sheet - deleting unlocked contents
Re: macro problems
Using dual monitors.
Arrays - Constants and Variables together
Column to Text Question - Stop after one break
Is Excel a reasonable platform for this?
Re: Are there any other suggestions for weekly timesheets
Disappearing Data Labels
Comment specs
Problems with comboboxes and text wrap when publishing to webpage
Importing Multiple Data On the Same Row
Saving Excel Docs as a 'Variable' Name
Variable File Naming Using Macros
How to link several separate reports in Excel?
Re: Losing data when saving as a dBASE file
"Watermark" in Excel
How do I turn off the automatic conversion to dates?
sumproduct!!!
Run time error 70 permission denied
Filter list and have copied to another location
Exporting Excel data to Photoshop or similar?
Setting up barcode
saving the same file in different places at a time
Re: Charts - Question
Large file size even when empty?
Need Guidance on solving this problem....
Hiding (lots of) rows and columns
Working with Invoices
TBRun9
Code to delete rows not working
Default Gridlines/Cell Border Colors
HELP - Access or Excel
Method 'Add' of object 'CommandBarControls' failed
Macro "stop recording" button
Formatting excel worksheets
Creating a formula that references the formula in another cell
Conditional formatting - hide one cell based on another?
duplicate entries in rows
Text in Excel
Spreadsheets & Simply Accounting
Navigation Problem in Excel
Excel Workbook file increaseing in size
Workbook file size increasing
Excel fonts how to recover them
Pivot tables and data
Formula troubles
paste a formula to a range of cells
Run Macros at certain time automatically
right mouse button not working correctly
MACROS
Add rows to a formula when copying
macro trigger by event
AWS conversion
Text to Number - Difference between Excel 2000 & 2002
Calculating total values of duplicate entries
creating bar graph
freeze values
Ranking
Rank
Creating Toolbar on Word 2000 (Urgent)
Grouping Same Data in column
Not enough memory/Unable to save external link values
Range calculate
Getting values from closed workbooks
separate vs. concatenate
Re: creating bar graph
goto next line
How do I transpose a worksheet which contains a link to cell refe.
How do I use excel with simply accounting
Linking ??
Alining data in 2 columns
How do I scale an Excel file to fit into a Word Document?
Excel 7.0 Can't read .xls file
How do I setup a movie tmeplate list in Excel
Range names in financial projections; to enable getting data from a specific period
Add path and .xls to cell to produce filename
Auto Answering and Clearing the Clipboard
failed upgrade-old excel data wont open
launch Excel with cmd line parameters
How to change data in 300 workbooks
pivot table empty cell
2000 vs XP?
EXCEL 2002: How do I user/simulate a Timer event in Excel form
Clearing "Microsoft Office" clipboard
Excel: format each worksheet header/footer?
String, substring
Hide and restrict rows for each user to view his own record only
Print Preview different from Page Break View
Hide and restrict rows for each user to view his own record only
I need help to find...
Excel file association
Validation and autocomplete
Validating time-of-day input
Problem with mixed trend and XY chart
Retaining identical format/look after copy paste
Highlight selected row
CONCATENATE
Protection and outline
currency/number formats
Merging cells in a shared workbook......
Excel VBA / Macro Problem
SUMIF or SUMPRODUCT
Office Prank Victim
My variables keep getting reset...
excel vba - vlookup problem
Re: Copy and paste data into an object...
Automatic hiding of rows
"Your changes could not be saved to..."
check if number can be made from a combination of other numbers
Adjusting screen layout?
Printing multiple files
Nevermind, found the answer....but thanks!
Drop down menu's
Setting a default value?
Creating a header using non-contiguous rows
Obtain data from list
Opposite of a $ sign in formulas?
Search if etc
Macro to open another workbook