Microsoft Excel Misc

column --> row
count for characters instead of numbers
Text Import Wizard Does Not Pop Up
Re: Opening Lotus 123 files in Excel XP
Difference in date by Month
Saving file as test file
copy and paste problem
Removal of broken Hyperlinks from data copiedfrom a web page in to an Excel Spreadsheet
FREQUENCY function with total?
Sheets
Version 2003 Fixed Decimal Glitch
Data validation with a cell value linked to the same cell.
Combobox Setup Help
Drop Down
Green Triangles in Cells
stumped due to duplicate/tie matches
Footer in Excel
Re: Hiding negative formula results
Re: Hiding negative formula results
Re: Fractions
Last Save Date
Cell Color change
Printing problem in Excel - misaligned contents
Re: Searching a workbook
RE: Fractions
Duplicating a workbook only with cell's values
CheckBox Checked Function
Formulas Referencing Pivot Table results
Calculating age
Re: How do I change the global default for BOTH date and number formats in workbooks?
How do I make an instance of a table?
vlookup
Inporting Access data into Excel
Re: help, cell formulas????
Glacial "Find and Replace"
Cant find the bugs in the code - A solution to format/paste problem
Changing the end of a worksheet (Ctrl+End)
Macro Not Loading XLSART excel
delete duplicate information
vlookup code not working right
Personal Macro Workbook
One link not working
Automatic Dates
autoformat comments to move & size with cells
THREADS/How do I respond to an answer?
conditional format sum if
Conditional Formatting
userform to 2 seperate sheets
Dropdown Formatting
Re: Freezing Panes & Data Validation
userform stopping duplication
CountIF Question
Percentage (%) sign in PivotTable... URGENT!!!
Multiple Criteria
Illegal operation and now File locked
sort, etc.
unwanted formatting changes
hiding the Data used for my drop downlist
vlookup thru multiple sheets?
Moving between sheets
making a cell blink
Excel WPS file
dates in pivot table report
Printing in Excel
Excel variable Range
Printing
Mail merge from Excel
adding an icon
Date format problem
problems with screen size
control on a user form to choose a worksheet
convert a field format DD:HH:MM to hours & minute
Forcing a search on opening a workbook.
Paste special
Cond. Formatting depending of value in another sheet
Re: Fractions
Supporting multiple excel versions from .NET
Filter
macro to delete last row in a range
deleting part of an entry
macro error
excel97 winNTmacro does not work in excel2002 winXP
Custom Lists
populate a listbox with values from rows in another worksheet
populate a list box with filenames
skipping rows with zero values
How can I compare two lists of numbers to see if they are the same?
MID$, problem with comma
Maybe an IF ??
Excel 2003 doesn't convert CSV files with commas, only with semicolons
Excel VBA: need a command to free the memory allocated to Excel
Counts showing up when filtered
Count Status Bar
Property and Project Explorer window not docking
Why am I getting a #VALUE! Error?
How to enter e-mail or WWW addresses without becoming active hyperlinks?
Disappearing Data Validation arrows
Deleting a Workbook
Macro Needed Please
Saving files
Display Array from VBA
pivot table issue -- putting data of the same code on diff lines
Code to display Worksheet names
Tip
Tracing offsets
Display Array from VBA
Counter/Incrementing
making leading zero's visible
Open excel from a website
Time Problem
Excel Font Preview
Custom sort list question
Auto Sort
mass change of numbers to alphabetic
How to preserve current selection after appl.events carry out an copy-pastespecial action ?
Urgent: Distributing data into rows and columns
Excel 97
Wireless Keyboard
SUMPRODUCT - Error #NUM!
Excel 97
EXCEL SPREADSHEET VS MICROSOFT SPREADSHEET FOR XP HOME
(User Defined) Function for Copy&Paste?
converting rows to comma delimited list
Excel XP gurus - sheet hang problem
Solving an equation in a cell
text displayed represents number...
Can't insert row in Excel
check box for hiding columns
lookup format
Re: Formatting numbers
Re: How to change the look of the selected cell
making leading zero's visible
Lockink the scrolling of a cursor in a protected sheet.
Event for pick list/validation item being chosen??
VLOOKUP from Access
printing alternating gray and white background
Excel spreadsheet from Access table + keep hyperlinks
Dates Format
maybe formula problem
problem with pivot table
VLookup
pivot table issue
Inverting Text
Personal.xls file
Date Format
Entering text in a cell.
Formatting numbers
Excel 2000 - bug with copy & paste?
File extension description
Date format in the footer
Removing personalized toolbar
Not enough resources..
changing font sizes without changing cell sizes
hotkey for browsing through worksheets
#value!
Help Creating Lists
macro: jump to cell in next sheet
Synchronizing Two Workbooks
Excel and macro in VB
How do I convert a concatenated value into a know value
Counting current form
Re: Header Width
linking Excel to Outlook calendar
Alphabetizing a List
Cell Format
Excell Value Pack
seperating data in an excel cell
using named ranges and copy with Advanced Filter
Re: why won't anyone answer my question
Exporting tables to FrontPage HTML
Change all from upper case to lower case???
Text Boxes
Deleting or editing Named Ranges
Exce; - Urgent - Run-Time Error 424 Object (VBA)
Average formular
Excel 2003
Re: Importing into a specific worksheet of a workbook.
Now()
Unable to read file.
Changing the order of columns in a custom view
Compile error in hidden module in Excel 2002
Changing the row reference in a link
Formula Help
Data Question
double zeros
Saving Fomulas only
Looking for file
Re: why won't anyone answer my question
Re: Circular Reference Toolbar Disappears
Total years mounths and days elapesed from todays date
Re: Weird Behavior in S/S
Cell Spacing Problem
Limiting Combo Box List
What function/formula should I use?
Cell to show the last 2nd Month
Generating a cell reference
"Pastespecal failed in rangeclass"
Linking Names in Worksheets to Worksheet Tabs
Spreadsheet on form
Cell Colour - Context Sensitive?
Dates forward
Excel Macro - copy cell contents to name a new sheet in another spreadsheet
Automated message
VB- If first cell with formula is blank, all cells in column returns blank.
Excel2002 named references
local named references in a sheet
Copying a sheet with namd references
2 Bugs: PasteSpecial syntax & EnableEvent in ws_deactivate
Counif using a range
Double entries
Change the text colour of a cell when opening up a sheet
Puzzler - sum of top 3 results
Unique data in column
Excel VB triggering Stored Procedures/Queries
vlookup and date values
Display the value which has the quantity required
save worksheets as workbooks
populate a listbox with values from a range in a closed workbook on a server
application.getopenfilename to open a file saved on a server
Tracing Automatic Links
converting numbers into a date
average formula
excel vba - pop up message (link workbooks)?
Multiple Workbooks / Worksheets
Error refreshing pivot table
COUNT multiple columns, numeric & text "URGENT"
Re: Splitting Cells
Refreshing pivot table
Multiple IF Functions
Grouping Methodology within a pivot table
Excel VB - Pagebreak
Naming ranges
Re: Print Revision or Last Saved Date
calculating percentage of who said
Header/footer date
spreadsheet load hang
Hiding Sensitive Information
Summing instances that are in different rows and columns
Re: Splitting Cells
Forms Combo Box
Provide space in text
I need help! How to concatenate and render the result?
Templates help, Excel 2003
Formulas
double-click in between two rows or two columns
Fill series in cells
Pop-up windows in Excel
Re: Setting target dates excluding weekends
Re: Maximum Value based on multiple criteria
Default Cell Value
name of day and date in same field
Pivot Table Query
wildcard search in if formula
Setting Checkboxes to Unchecked
Re: Setting target dates excluding weekends
Conditional Formatting
Re: Transferring totals to a separate sheet
Calculating APR for Adjustable Rates
Label of Number in a Range
Copying a dynamic range from one sheet below another dynamic range in the same sheet
Concatnating issues
Pivot Table Formatting
Problem Duplex printing
Date as Words
data may exist pop-up
Check the indent amount of a cell
VB Code for Naming Ranges
Windows in taskbar
Re: Formula too long.
File Opens Very Slowly
Copy Paste
Copy range of cells
Extract Values from a Column
Print grid lines
Pivot Table Basics
Re: Spreadsheet prints with borders-lines missing
Re: Data Validation and VLookup
using text in a formula
Re: Merge of Excel Data in a Word Document
Split cell
Want to average values grouped by value in a certian column (sql example included)
writing equations for calculating dates
Map Keys
Re: Open via Explorer
Adding on to a formula across rows and columns
Excel Query
Two documents with the same name - error
Search doesn't work
Information being placed both worksheets when i don't want it to
Re: Summing only 13 cells to left
unable to copy/paste
Automatic Backup Files
convert from excel to adobe
Re: Linking cells
Open file not showing
Having a chart creation issue
HTML to Excel
MOre...Having a chart creation issue
Custom Sort order in pivot table
worksheet that is a web page
Problem with DSUM formula
Grouping dates in a Pivot Table
Macro that creates named ranges on all sheets
Manipulating Pivot Table
Creating Formula with Embedded Variable ID
Importing quickBooks
Macro functions on exit
Listing the file name of workbook in a cell?
file monthly update procedure template
Re: Summing only 13 cells to left
Re: Summing only 13 cells to left
Changing field type
Column widths
ISBN
Excel file goes from 12 to 38 MB after "Get External Data"
Reference to a cell in a previous sheet
attachments
I need help creating a Bill of Lading using Excel.
indexing or combining the data from work books
Find carriage return character in a cell
Problem with text-to-speech recognition in excel
Sorting With Conditional Formats
SUMIF: Criteria range is from other sheet and problem occurs
Want to find max in a range then return a name from a cell
how to move records to a report database
Please help..with a formula. I don't know code.
Hide and protect columns
Watermark in background
Linear Equations
Converting results into Percentages
Address question
Summary of multiple workbooks in a directory
data validation and certain condition
extending an sum range
vlookup & inputbox
strange problem
disabling xml viewing facility in excel 2002
How to sort?
Conditional Opening of Excel file
Please help with syntax Object - Range - & .PasteSpecial situation
VBA Crashes Outlook Express
date in text string
Datamap
Crashes wirtEvent id 1000
Cells Locking up
RE: Sorting merged cells that are not identically sized
Values in multiple columns into one column
Excel 2000 crash with ActiveX component
Times & Seconds Problem
name of sheet
Where are my Menus??
Text to numbers
macro to pick last row in a range
AutoOpen embedded Word Doc
Database Query
Clipboard toolbar behavior
countif?
Cut & delete row in 1 step
Copy sheet & page settings
shortcut keys for comments
RE: Times & Seconds Problem
Password Protected WorkSheet
Excel time formats to text...
grid lines
Date in Header/Footer
Whoami
Stuck on a formula
email partial worksheet
Limited Columns
Need way to see which combinations of which fields equal given number
SUM of values within date range which equals another field
command to import a file into excel
Pivot Table Wizard
How to populate a list box using an array.
Nonrelative Sheet References
Workbook Module
Limit change to specific ranges in VBA routine
formatting worksheets
Re: formatting worksheets
Re: formatting worksheets
Excel XP Open Separate instance from Explorer
Get Cell ID (eg. H40) at the top-left of the worksheet
Changing the color of a cell
Re: Random sampling
RE: formatting worksheets
Controlling User Input
timestamp
Perso.xls in read only
Converting txt file to Excel
Concatenating fields
Form Dropdown Combo Box
Pivot Table -Want to display field rather than preform claculation in Data box
Ignoring blank cells in a combo box...
MSQuery ODBC error
Filtering a combo box
sorting in excel
picture colour degradation
Sum Function (was summing 13 cells to the left)
Re: Nested levels of fuctions
Re: Nested levels of fuctions
Re: Nested levels of fuctions
Re: Conditional Formatting
Removing non-alpha numeric characters
Re: Nested levels of fuctions
Counting based on multiple conditions including date range
Disallow Pasting over Validation
using cell's contents instead of file name
Shared workbook and VBA problem
Re: Average Formula
Validation/Duplication
Where Cursor goes on Enter
Shared workbook - active worksheet view
Blank Series in Charts
Re: using Access info in Exccel
Re: Summing only 13 cells to left
Tab copy w/charts errors
Re: Average Formula
Copy contents of cells if cell contains information
Extracting email address from spreadsheet. Pls take a look.
Blank Excel File
Re: looking for specific template/tracker
Help
Rolling Data Calculation
Find Access Database Used by MSQuery in Excel 2003
Same cell name in multiple worksheets
Open Files
Undoing after saving
capocket excel problems
Format a whole row based on value of one cell
Excel Error Message
Re: Counting Data Reoccurances
Japanese to English Date Conversion Problem
Importing TXT with multiple delineators
Re: Counting Data Reoccurances
Macros or converting Lotus 123 Macros to Excel
Reading attachments in excel format
protected sheet indicator
roundup function rounding when not necessary.
Go To Special - Last Cell
Formatting problem with linked files
Macro in Personal.xls not working
Mortgage Rate
How to suppress double quotes on save as tab delimited
how to delete a row in excel with a specific word using visual basic
anyone know how to solve this?
ADDING NEW RECORDS IN EXCEL 2000
Spreadsheet System
Change the colour of worksheet tabs
Securing Excel from being read
Multiple Worksheet Scrolling
Formula calculation question
Re: Random sampling
Formatting part of text in a Cell & shortcut copying Row hieghts
Run macro from if statement
How to Select large amount of data in a colum that equals column from another table.
Freezing panes
auto shapes for Office97
format change on Copy sheet
public procedures
Entering a continuing formula in multible worksheets.
Excel 2000 and VB6 controls
Prompt When User Changes a Cell
Inserting Variables in String
trouble combining data
find or vlookup or dlookup?
Hiding empty rows and columns
"Excel Data Problem - Space Between Word"
manual calculation
linking a date colmn with outlook calender
data in cell to open new form
3-d array function
Best way of copy range of cells without select
find Words between quotes
3-d References
Excel 2003 - File Locked for Editing
Track Changes
Writing complicated If statement in Excel
Selective Trendlines
Find function
Sheet Names will not display
Using Hyperlinks
Converting Pocket XL Files to Normal Excel
error in excel
How do I specify a formula to look in another cell for a sheet name?
tmp files created
Best way of "mirror" several cell areas on one sheet to others?
ADO to get recordset into array from a workbook
DDE Links
OLE object without border?
Bottom margin problem
Duplictes
vlookup to the left
insert new row doesn't add formula
Strange Excel behaviour for ONE user profile
How to show the result instead of the function
How to draw a object and erase it programmatically
Adding note numbers to cells
Macro, Pivot Table and varying number of rows
Imported data has character that cannot be replaced
Re: How do I get row #1 of my spreadsheet to stop overlapping the rest of my chart when I scroll??????
opening excel files
How do I get row #1 of my spreadsheet to stop overlapping the rest of my chart when I scroll??????
Re: How do I get row #1 of my spreadsheet to stop overlapping the rest of my chart when I scroll??????
Macro warning message
Calendar or Workdays in a Month
cell font colors or cell shading
Shading
Lookup unique values & calculation
Hide Zero and Date adding
Hide many rows quick without loop
Macro Problem
Color in Linked Worksheets
top ten
Re: Unlock protected cells
hide header on first page
Re: startup tab
Re: startup tab
Re: Formula changes
Re: startup tab
Re: Formula changes
Auto Saving in Excel XP
Conditional Formating based on Odd vs. Even
Excel Custom Formats
Remove Group Box border lines
data entry problem
Combine all accounts that end in D
Precedents
fixed width column export
Formula to round up
Grouping consecutive rows/columns in different groups
Rows resize mysteriously
Converting European format CSV to American
Looking for a premade workbook for expense/sales
Update cell information from a different cell
moving selected data to to other work books
entering forumla'
Move a tab to a different file
Using Excel with Peachtree Accounting
Excel VBA - Modifying the Autofilter
editing cells
Excel "Save Preview Picture" not sticking
Worksheet name in formula
Re: Update and overwrite cells
Wierd
writing procedures
Hot Link - deletion of screen tip
Data Validation of multiple sources
saving templates
skipping lines
function/formula
Unknown Error
Excel
Please Help! How to enable cell overwrite AFTER the query is created
random generate functions
Conditional Formatting II
need help logical function alternate result
Cell Matching Problem ...
Split Cells
printing gridlines
Web Pages From XL
FOOTER
Time Difference Calculation and Sum Problem
Sort--Formulas don't adjust
Revised data fails to be used by formulas
Re: Phone and ext format
Re: matching
Navigating to unprotected Cells in Protected Sheets
toolbars and customs view
Problem with columns letters?!?!
Excel Bar that looks like an Outlook Bar
Re: Please help! My group boxes won't hide.
Highlight a Cell
How to Display the Message after the completion of OS task in EXCEL?
How to Display Message after the completion of OS task in EXCEL.
How to Refresh Data Import?
File too big?
excel worksheets getting deleted in shared files on P4 - Excel97
Automated solution required
Set the color of grid depend on variable
automatic invoice tracking log in Basic Edition 2003
conditional formating of adjacent cells
Macro
Syntax advice to get rid of select/activate
Formating Form
Multilines caption on command button
How to freeze pane column and row?
Question about pasting web content and formats
Trunking help
Number of rows in a worksheet
Data Validation - Allow List - In-cell Dropdown not showing up
Long message line
Moving bad rows to another sheet
Saving Work in Excel
Auto shape macro
Short cuts VBA
test
How to use multiple if statements?
triggering a macro
formule
display time in different time zone
font size of text in a combo text box
Histogram Bin Error
Formula Help
Formula request
userform
Using Excel Options
Range name confusion
Quick hiding of rows in WS_Activate ()
Template
how to detect which macros are no longer in use?
warning message
files won't save - macro virus ??
Excel Short of memory error
Problems calculating a converted html table to Excel XP (2002)
Sort data witth blank line between entries - how?
formula / math help
Value Return with the offset(?) function
Title
Countif Question
'User-defined type not defined'
anything I can d/l to open excel spread?
Calendar Control 11.0
Entering specific data in cells.
Assign a number on a template
spell check
Create a marco to assign numbers
Sort order in different column as a numeric value
install autocorrection
install autocorrection
inserting cell data into a hyperlink
Pick Lists
Remove hyperlink feature
excel
Previous message (As per below) Need more help
3 colour in conditional format
one more text box to a userform
Click Cell for Date and Time in Excel XP
How Do i Paste thiss?
Daily Tips
Unable to Open Excel
Text cells, crosstabs? Drilling down?
Combo Box Return to First in List
Sorting pos. & neg. numbers in a cell
change a lotus 123 to a excel and have it print the right size.
Excel Desktop Shortcuts take long to open up
Hiding Blank Rows/Columns
16+ digits truncate in Excel
Forcing a line feed in a text cell?
Points Tracking
print scaling
How to hide the macro code that no one can open & see the code?
join text with date
macro for coloring cells
How to avoid Excel auto datatype formating
Date format
Hiding a column VBA based on a condition
Keyboard shortcut to move between tabs
Trim function
"not found"
Template With Data Tracking
Excel doc on the net
New Tip everytime excel opens
Clearing Cells in Multiple Worksheet
Protecting Worksheet
countif on multiple selections
AutoComplete
Sort Worksheets
Import Excel in Access
Change font size in an options button (Forms Control)
VBA Code
Help Needed...
Permanently Affixing Toobar/Macros
Assumed Decimal Places
Conditional Concatenate
How to change pivot table source database?
Spreadsheet identification.
MIN function in array formula
multiuser workbook registry?
Filtered List - copy and paste
Clear macro before save
Remove duplicate enries with blank fields
Negative Numbers Display
Macro to compress grouped rows
Move Rows with Old Date
Excel 2000 close button "X" grayed out
macros and hlookup
Re: vlookup and zero values
Need more columns! How to exceed default limit for number of columns per worksheet
11 X17 Page Setup
Why do macros disable themselves? How to reenable them?
how to address all cells in column excluding first n cells in that column
EXCEL 2000 AS A FRONT END TOOL
printing
comparing data - find data in 2 columns
Re: Need to do spreadsheet don't remember how
Re: lookup question
referencing a blank cell
unable to record macros word 97
Sort / Print only Coloured rows of a table.
Excel - Combo box location
Data from one worksheet appearing on another
CSV formatted numbers display incorrectly
Service Pack 3 install attempt - can't open excel
Re: lose data when I shorten width of columns
copying row heights
Pivot Tables
Re: grouping records in a query
Numbers to dates
can't open file
searching data
Macros
Random Selection
Printing
Remote reference when linking Powerpoint and Excel
Can you change the color of a cell?
Select range for function in a cell
Tab Names
Moving Parameter Queries
Excel Crash when choose certain sheet
2K3 Save As to 2K
Circular reference error closes workbook
Conversion from MS Works
Calculation Speed
Formula problem
Vary Color on one data series line - Bar Graph
Macro command go to last filled cell in column?
print certain rows
Calculate Year Correctly
Re: Calculation changes from Manual to Automatic
Re: Validate a unique value within a named range
Re: Calculation changes from Manual to Automatic
Multiple Users
Inserting Comment Problem
How can I round up and format prices to .95 ?
Saving as field formatted text file
Marco Execution Question Please
inserting rows using visual basic
getpivotdata
Adding Formulas to Subtotal rows
pasting data from another source into one string, not delimited
Excel wrap text problem
Copying sorksheet formatting
Re: Can I require a password to VIEW a worksheet?
Re: Sending attachemnts from Mac to PC
Using macro code to change the name of a common spreadsheet when opened
Re: Calculation changes from Manual to Automatic
Can I require a password to VIEW a worksheet?
#REF from external spreadsheets
Searching trick?
Macro code to remove the prompt "are you sure" when saving over same name