- 0's getting truncating during Import
- Using an IF/THEN from across 2 drop down (combo) boxes???
- Fill Series Across Multiple Workbooks
- AddIn - Calling functions from VBA
- Filter data per function
- sum total
- Access Records into Excel
- Mail Merge Question
- Help - Excel 97 Macro convert Text to Number
- Filling empty cells with contents from another cell
- ty paul b and dominicb
- Plot rate of return
- Plot rate of return
- How to Disable the Little Auto Fill Dialog
- monthly subtotals
- Splitting Cells
- Help: Can't display contents of Adobe Acrobat Document in Sheet
- deleting empty spaces
- Look-Up Table Tutorial -or- Better Idea to Solve Problem
- Populating Excel from CSV
- How to calculate Date & Time differences
- formulas
- How to ignore negative numbers
- Add button to commandbar to all workbooks within xla
- Trace Dependents
- Printing
- Pivot tables lost in Excel 2003
- get figures into right colom
- Show me cell comments ONLY when cell is selected
- Macro to Copy & Paste a Excel file
- help with syntax for if and statement
- Squash Ladder Help
- Printing Document Properties
- VBA: BeforeClose + SaveChanges := False
- Hyperlink problem 2003 to 2002 and 2000
- Tutorial for programming macros and functions
- Filtering problem
- Re: vba ping
- Hiding Rows and dealing with superimposed image on worksheet
- Excel File Takes Too Long To Open
- preventing Excel from changing number formats
- delete empty rows
- why csv fields converted into dates
- Filter result
- question on view
- Sort Alpha by last name with first and last name in one column
- I'm stuck on a circular reference
- How do I link to other pages within the same file?
- using a number to select a cell
- Taking a cell from sheet 2 to sheet 1 (newbie here)
- Increase value of number in formula/using named cells. And use ofIF sentence
- Calendar going black...
- Hyperlink lost when workbook closed.
- Can you control the size of the formula bar?
- Dropdown governing a column?
- Free Excel Materials
- Displaying pathname in the header
- Copying data without opening the workbook
- Sorting by Birthday Anniversary
- copy values generated by conditional formula in one sheet to the other work sheet as values
- Formula Problem
- Named Range Problem
- Defining Column Widths
- Please Help Formula
- Average A10:A20:A30 etc... A990;A1000
- Clipboard taking screenshots instead of copying
- Stamps
- How do you lock rows for scrolling ?
- auto archiving functions
- How to create a formula where a letter equals a number, i.e. Y = 1
- Excel Question - Office XP Upgrade
- Sumproduct additional criterias
- To Keep Only A Tatal Amount, But Not Keeping The Whole Sheet
- Will a formula do what I want?
- find column with text data in row 1
- Re: Will a formula do what I want?
- Continuing file corruption
- Creating Permanent Macros in my workbook
- Formulat to lookup using 2 values
- Help tweaking a formula
- Hiding a sheet from view
- Data Tables - Location
- Hyperlink in a macro... Not taking my variable...
- Permission to use object denied
- Lookup in raw and column concurrently
- Count Cell Range
- RE: code execution has been interrupted
- What is best way to determine whether a value exists in a column of values?
- Charting through Worksheets
- saving variables with a name on each sheet
- notes
- Tally
- Re: Tally
- Can't open XLS file
- Update Links Automatically
- How to append text to cell data ...
- Formatting and Grouping Columns w/ Merge Cells
- Conditional Formatting (How to format a range depending on another range)
- Average of a changing numbers of cells???
- Formula
- Delete duplicate rows from a list in Excel
- Excel macros page breaks but not on row 1 and column value in footer
- Add new col event?
- determine which column has a value
- Moving down two rows when Enter is pressed
- Combo Boxes Hyperlinked to Worksheets in EXCEL
- Another simple "average of..."?
- Web table to Excel...
- PMT
- How to calculate how many cells have a value of less than 3?
- Re: setting a range dynamically
- having a link within a link
- Pivot Tables for Beginners
- Protection & standalone
- sumproduct
- findin values
- Using a range as value_if_true in IF function
- How to sign macros and functions
- Weird problem saving a file
- SUMIF formula
- Data Validation Question
- tempate question
- How do I create a custom calendar?
- VBA function in Excel Optimization
- access a cell in a range
- formatting question
- html filter for 2003
- Problem copying and pasting formula
- Summing cells values based on IF formulas
- Changing name in link by using replace all function
- Any way to get around the number of columns limitation?
- sort and then insert rows help!
- Ask the user
- exporting simple html
- Adobe Conversion
- The REF error upon removing interdependent row
- linear increments
- AutoFill
- filtering
- macros
- Trouble printing zipcodes that begin with zero
- How Do I Trim and Format This Text?
- Combining cells
- Help with lottery project plse
- Specialcells
- How to copy the hyperlink of a list of cells in another column
- CNTL+ Does Not Insert Current Date
- Loading files
- Macro to insert cells and copy/paste data
- New Problem
- Need Help Removing Browsed Pages From Edit Hyperlink Box
- An easier way ??
- Sorting imported text
- How to create combo box on whole column fastly?
- Excel: Combo Box
- Losing last digit on 16 digit number
- Deleting Check Boxes
- Macro to run upon Workbook opening
- Yes/No (Click button)
- Acceso Detenido a Carpetas de Windows
- Empty space
- Importing Data from Access -- Parameter Errors
- My comments have no Username!
- Saving Excel workbook in SQL server using c#
- Saving Excel workbook in SQL server using c#
- Saving Excel workbook in SQL server using c#
- Sorting Question
- Startup option
- Find certain cell value
- Buttons in worksheets
- share violation?
- Data/Sort by ROW not column
- Office Logos?
- Locking Named Cells
- Protection of document properties ..??
- Drop down list and validation question
- Lookup formula returning same value for multiple lookup values
- Group rows / columns: +/- symbol at top or to the left?
- agh form design
- Annoying & unrecognised value
- Need to Merge Two Excel Data Files
- Formula to refer to changing Column
- Append data if a duplicate found
- Returning a value
- Aligning fractions
- Darn Programming
- Help for newbie
- How to Remove Duplicate Customers in a File
- Calculating an Activities During Periods Of Natural Months and/or Dates
- how to write data and string to a text file
- IF( OR IF)
- Finding the row number of first row in a selected range
- Office XP SP 3 interfering w/ Excel
- PDF Smart Tags
- removing characters???
- Change Default Zoom
- Two columns on X-axis
- Page Setup questions...
- How to select cells (located in a column) for formulas in a row automatically?
- Changing row colors when value in cell changes
- A Date Query
- how to?
- Sorting by days
- SUMIF test for blank/empty cell????
- Determining the month name base on text in a cell
- Sort ascending, make changes, restore previous order
- Convert hh:mm:ss to seconds?
- Months
- Compounding Formula problems
- Change merge button to "center across selection"
- UnHide Columns in Excel 2002
- Date Format Conversion?
- Faxing help
- "Installation source for MS Office not available"
- Freeze top and left side
- GURUS - Chart disappearing
- How to combine 2 cells' data into 1 cell?
- time rounding
- shift
- Ignore 0
- IF or AND?
- R1C1 v A1
- Drop-down menu
- Why can't I write on the excel sheet?
- how can I check if there is text written in a cell?
- Edit ODBC connection information for a work sheet
- External data link change
- Excel 2003/MS Query - Query Defn Lost
- Excell can not access
- Visual Basic Macro to print hidden worksheet
- How to replace column letter in refferences with a function using the old column letter?
- Distributing Changes in Workbook
- Re: Wildcard with two or more criteria: pls help
- check if then else?
- Re: Wildcard with two or more criteria: pls help
- Date-orientated update of cells in different spreadsheets
- How to make LOOKUP give zero if it can't find the lookup_value?
- Compare side by side - annoyance
- Sorting
- Conditional formating, values.
- Lookup and count
- Need help (not sure how to explain in title)
- Numbering items in Excel
- RE: Evaluating text as formulae
- Summation of Rows Problem
- Evaluating text as formulae
- "Unable to read file" error message when you open Excel file that contains a PivotTable report
- Lookup and Count Continued
- I want the day of the week when I insert a date
- function to leave fractional (decimal) part
- Excel 2003 Chart Labels Not Visible
- opening a CSV file by Excel
- how do i get the hours between these times??
- Truncating cells
- Mass deleting all pictures
- Dates pre 01/01/1900
- Data Formatting Question
- Merging multiple excel files into 1 excel spreadsheet
- Date time formats keep reverting back to default
- Pivot Table questions
- Preview Thumbnail of .XLS....?
- trying to edit formula causes it to become text
- Excel Assignment, I am Lost!
- PivotTable sort on field *not* total
- Convert String to a Worksheet type variable
- Error -- Versions of Excel??
- Comparing two lists in Excel
- Charting Data.
- Excel Applications.AddIns("xxxxx").Installed = True?
- Removing " " from a cell
- Average function for more than 30 items
- Exiting a Do Loop on error
- CANNOT OPEN
- How to change column letters to correct ones in many formulas automatically?
- Paste method faile (activesheet.paste)
- How to replace a function with its result or resulting reference in a formula?
- How to replace a function with its resulting reference in a formula?
- lock cells with specific layout
- How to disable a cell . . . ??
- Use personal.xls as lookup sheet?
- sort by color
- adding data to sheet 2 from sheet 1
- Saving as an HTML
- How to see columns from which values were not returned by HLOOKUP functions?
- help with copy and paste
- Format a concantated text string
- keys don't work when sheet protected
- une erreur DDE s'est produite
- a
- HELP WITH VBA
- Is it possible
- How to create popup dialog messages
- A piece of a button remains...
- Groping & Sorting in one step
- Password Protected
- Media Player versus Windows Media Player
- Password protect cells but not the file
- Stop Automatic Date Conversion
- Add Sheet Cells into 1 sheet
- index page
- One column with different widths
- Running command line "aplication"
- 3D Graph Formatting
- Preventing excel application piracy
- Task Pane
- Disable Save & Update Prompts
- Help combining values with a space between
- Combining tables in many sheets to one
- Email hyperlinks - the inverse problem
- VBA & HPageBreak
- Problem with updating links in Excel 2003
- number formatting - conditional decimal point
- Get Range to Lookup from a Lookup table
- excel VBA
- Global setting for Protected Cell Color?
- easy way to copy RangeX to RangeY
- Sort by ... Then by
- Question with regard to Average formula
- Automatic Swtich to Manual Calculation
- A If then running count
- help
- 16 digit # formats to Exponential & rounds off???
- Wrapping text in a cell
- I want to create a Macro to extract informatin from other softwares like Chainlinx etc
- subtotals
- matching codes between 2 item codes
- Problem with the first cell which contain a large string ---help
- How to prevent Solver Results Box from popping up?
- Unique values in whole sheet
- Sorting worksheets alphabetically (in Turkish specific characters)
- ZIP CODE FORMATTING
- Sum of 3 maximum numbers
- AutoComplete works sometimes but not others
- If(countif) problem
- Unhide rows?
- Lookup selective from another sheet
- eliminate duplicate in a column
- Report Manager
- Calculate Age...?
- Range of averages
- HOW TO MOVE SECECT DATA TO ANOTHER CELL
- HOW TO SORT 4 COLUMNS
- OpenWorkbook error
- Is it possible to click in a cell and trigger a macro?
- Dependant dropdown
- Address Vallidation
- dividing money
- Excel Problem
- How to format time as in tract or lap time.
- Date function in Excel 2000
- Creating Column headers from Worksheet Names
- How do I count items based on multiple criteria from a different worksheet?
- Sharing workbook over the web
- Advanced Filter : Computed Criteria
- funtion please
- Problem with ARRAY FORMULA MIN
- Pasting into comments field?
- In need of Help
- Formula Help!
- macro to include "user select"
- Reformatting a number
- Excel Query
- Drop Down List Titles As Default And Reset Button
- Insert Question
- Need help: Conditioning "Conditional Formatting" for multiple cells
- Random shuffle cell values?
- Unable to set FormulaArray property of the Range class
- Worksheets Blank when Opened using Explorer & Networked Drive
- Select Date based on date value
- protection problem
- problem with protected sheet
- adding date in excel
- unhide fails everytime
- Rounding Off
- Working with dates
- Read Only
- show columns on other worksheet without using formulas
- Memory problems in Excel 2003
- using vlookup string in vb
- Zeilenumbruch in mailto:-Hyperlink
- Merge / Collate Workbooks into 1 workbook
- Copying Conditional Formatting Down A Column
- How do I Retain the 2nd Y-axis on a PivotChart ?
- Checking Text Across A Range
- Pop Up Comments
- assign cell content as file name
- If Statement
- Error on startup
- Cannot edit macro
- Count number of lines of text in a range/value.
- Timer function
- listing cells that have external data link
- CSVs - enforcing preceeding zeroes
- Help Importing Text Files
- Font colors
- Help with LOOKUP function
- How to expand columns when sorting
- HELP: survey data collection & analysis
- email open excel document as link
- True or False if already in column
- Why won't my sort info save?
- Hiding column/row labels --without hiding entire columns/rows
- Cannot find x, cut & paste row, repeat and end.
- SumIf Question
- add-in startup order
- Disable "files of type" combo box
- Formula Help
- When sending a selection via e-mail
- how to use SEARCH?
- Automatic VBA printing
- Help with Tab
- tri sort a list
- Undo save?
- import data from works 3.0 on windows 3.1
- Why is This?
- Date Serial
- Database query - nbr of rows returned different
- Working with worksheet groups
- Excel: Ignoring Specific data in a column
- Excel: Auto converting text to numbers
- Graphique
- Formatting excel chart in powerpoint -- size scales are blank
- non-interactive (programmatic) download & save of Excel mht as an xls file
- How is it Possible Q
- help
- Formula Help - Better than Using the IF(ISERR Method
- Drop Down List.. with a Twist
- Updated cells
- Help getting a Formula to get non ordered text in order
- TURN $6 INTO $15,000 IN ONLY 30 DAYS...HERES HOW - "paypal.rtf" 12.4 KBytes yEnc
- macro
- algorithm to divide by 6
- Formula help in Excel which is the correct way ?
- frequency of events
- Can logical function (IF) use non-numberic text?
- How to apply a conditional formula ?
- Page Break Preview
- Formula Help
- Automatic Display of text
- Keeping a zero as the first number in a cell
- Splitting a workbook's sheets into seperate files
- 2 Data Validations in a Cell
- help needed: I want to convert Scores (in percent) into Grades (A, B, C, D, or F)
- Using cell information in formula?
- disable customize option when right click on menu bar
- Excel 2002 slower than 97
- Advises about error handling.
- lookups and ranges
- 2 Data Validation.. but with a List
- Can not automate Module
- How to automatically rearrange data on a worksheet.
- Disable prompt for external query
- help with worksheet with access
- Excel ODBC Driver, Get Column Names?
- Big Brain needed to TransferSpreadsheet
- Need help with summarizing data
- Formula for adding up columns, i.e., B1:B10 + D1:D10 + F1:F10 + H1:H10 + J1:J10
- Copy and paste two named ranges together.
- Percentages Question
- Re: Excel Problem
- adding hours and minutes ignoring seconds
- Need help with an if/then formula
- Unexplained Line on worksheet
- Pivot Table Programming
- Disable Customize toolber tabs
- Re:Re: Excel Problem
- delete duplicate in a list
- Copying a DV Formula Q
- My syntax error
- Group And Sum Data
- Bypass Circular Reference?
- Excel reopens workboog after closing it.
- Excel Userform
- Conditional Cell Protection
- Need help w/ excel formula (duplicate entry)
- Matrix Creation !
- Modifying PageSetup Via VBA From Another App?
- Protection from format changes allowing form to be filled in
- MY PROGRAM
- Import file to Word document
- Question on changing the function of the arrow keys
- Help with Links
- Filtering
- Calculating a % for a newbie ???
- Forecasting
- Conditional Formatting and If Then Statements
- Formating the cell
- Help Me PLEASE !!!!
- Anybody with some free time ?
- Data format in pivot table
- Moving data from the wrong column
- Urgent help needed... Template Wizard with Data Tracking???
- Urgent help needed... Template Wizard with Data Tracking???
- count rows of recordset
- Error reference in guide
- Date problem in Excel when data is generated from external program
- How to format number with mixed number and text?
- Tune into internet radio Sunday, 2PM (est) to hear Excel tips & tricks...
- Landscape page but with Heading and Footer in Left and Right Margi
- Pivot Table Data Headings - disappear when changed
- Newbee - Replace values in a Column
- Documentation for HTML Format, Syntax for AutoSize
- decimal digits
- Sorting rows
- accessing excel combo box control data from vb .net
- Please Help - vba on word
- Subtraction Query
- Alert when consecutive numbers in a list exceed 5
- Baseball Stats question: How can I get the RBI's?
- drag and drop monitoring
- Rank with array of cells
- naming series with combination of cell references
- initial references of a VBA project
- Sort Not Including 1st Row
- UTC time to Central Time (US)
- Turn $6 Into 15,000.oo In 30 Days Or Less Using Paypal 100% Legal!!! "Noreply"
- autofit limitations?
- Data retrieval in a Matrix
- Problem With Date Picker
- Summing entire column
- AutoShapes default to "no line"...
- Time sheets
- no selections in report manager
- macro help please
- no selection in report manager
- Help...Need to modify data within a column in a .csv file
- Limited Range of Rows and Columns
- envelope list from excel
- Excel newbie question about auto inserting date
- Date Time Stamp Formula
- 4000 defined names
- countif"s
- how to use addoleobject
- Keeping a macro running after the calling workbook is closed (XL2K)
- Inserting A Monthly Calendar
- How to sum few items
- filtering and sorting in protected sheets
- Data is being duplicated on multiple sheets + [Group] in the title
- A discussion about the Undo-stack in Excel
- WHY WHY WHY??
- help with number of columns on sheet
- My Average function becomes #Name? Pls help :(
- Must edit (F2) and {enter} to get formula to calculate. Need better way.
- Bizarre Problem with Copy/Paste
- Replace C with A when C is followed by a number, but not otherwise?
- Same import week after week
- Stoping copying
- A Method of Replacing
- if statement
- Currency sign.
- Summing times
- Editing external data via ODBC
- SaveAs to a different folder
- Conditionally highlight cells or ...
- Layout of ODBC Data Import
- F2 - Select some characters - can I extend selection both ways?
- How to change cell name??(Possible??)
- Printer Fonts going mad
- Calculate Amounts for Specific Dates
- Copy worksheet to new workbook : Values & Formats
- Unremovable cell's comment
- Right mouse button doesn't work
- Cell's comment goes down when editing
- Preventing data being updated from one workbook to another
- Counting Cells
- inter-sheet links
- row height
- Wanted: Double Clicking an .xls file's icon starts a new instance of Excel
- Link a macro to a formula
- Change the value of a protected cell
- Renaming A Tab
- Excel VBA Column
- Empty Range
- How to determine the last row in a given worksheet
- substring operations
- Changing Shape colour by a click?
- Setting combo box index
- Highlighting Rows
- not allow blank cells
- ATT: Debra D; no selections in report manager
- Re: Excel cannot access "file name".
- IF(COUNTIF(Thursday,"John Doe")>1,"error"," ")
- Re: IF(COUNTIF(Thursday,"John Doe")>1,"error"," ")
- Full screen trouble
- Copied number (format as text) increases
- How to show (+) in front of no. ??
- How to see macro code of a password protected macro without a password?
- Removing Unwanted Cells
- work with IF
- Help with IF
- Cannot open excel files
- Array Formula Problem
- Closing Excel 2000 from VB (Unwanted process EXCEL.EXE)
- Q: When 0 <> 0 ?
- Q: When 0 <> 0 ?
- Display underlying hyperlink
- Color cells x5
- Re: Formula and macro
- Re: Formula and macro
- inserting "......."
- Re: Formula and macro
- Make sheet tabs larger?
- unprotect and protect within a macro
- Stumped
- problem with OnAction including an unwanted file reference
- How to change double arrow to single arrow (older version)
- Change list data
- Pasting from Word locks cells
- Formatting problem
- problems opening an url
- getting the correct average in pivot table/chart
- Copying problem
- Pivot Table refresh error.
- IF calculation???
- Re: IF calculation???
- Does Validation works for date ??
- A counting question
- Looking for a syntax list
- Creating a combined chart
- Can't Find Recently Used Files List
- conditional formatting when filtering
- Conditional formating help.
- Formatting Problem
- COUNTIF extension?
- limited No. of functions in one cell ?!
- Can't see fill and font colors
- Sharing and Solver
- ATT: Debra D
- Sum a String
- Conditional formatting of one cell depending on other cell.
- How to make a cell read only
- Can't sum numbers - Help!
- duplicate contacts
- How to remove spaces in a cell
- XL2K - can we put TAB name coding into cells in a sheet body?
- Way to change font case all at once like in a word processor?
- Accesing an Access Databse from Excel - documentation
- sheetchange
- Is it possible to assign rows for exclusion when data is sorted by column?
- How can I make row non-scrollable (the same as header row)
- What controls choosing online v. offline Help?
- Percentile: Different Result Using VBA?
- Pecentage
- Howto set Cond Form for non-blank cell
- Group workbooks on Taskbar
- =COUNTIF(A:A,isnumber) cant work
- Double clicking on a cell scrolls worksheet to the end
- refresh function
- Standard Deviation help
- excelhulp
- Linked cells in access db
- Calculating Hours Between 2 Dates & Removing Weekend Dates
- question "File -> Send To -> Mail Receipient"
- How to put a value in look up table
- Can't get Speak method to work
- Runtime error '91' when trying to exit Do...Loop
- Cambiar de numero a letra.
- how can I insert a picture in a cell
- Displaying Week End Date
- multiply cells
- Corrupt Excel File
- Headers to remian visible
- FAO: Roger Govier - COUNTIF v COUNTA
- This Might Be Impossible, But Here Goes...
- Create XLS File on Server Through ASP?
- Make audible tones??
- Embedded Word Document
- DYNAMIC RANGES
- How to transfer info automatically from an excel data base to a word document OR an excel
- Set date field year to 2005 - Worksheet function?
- Multiple Parent Windows?
- excel/word as attachment
- How do I format cells so that room numbers such as 1402, 1405a will sort correctly?
- Using MsgBox in Formula
- excel help
- celda con numero IP
- Vector addition... need help on how
- Really easy question - line break
- Dragging linked cells - A$2, B$2
- Problem with Excel and Stock Quotes add-in
- Adding a digit
- Importing Data From Another Spreadsheet
- Re: Importing Data From Another Spreadsheet
- Could not determine which columns uniquely identify the rows
- Cell formatting
- changing currency
- SUMPRODUCT - Blank Cells
- Roundup to nearest 250
- Funny lines along the rows
- How to copy and paste cells from Excel onto an Adobe page
- How do I use TRIM?
- Copy Value Function
- How to make a broader outline based on an "if" statement
- csv file
- Traversing folders and subfolders
- current date and time object
- How to sort records by color?
- Inserting comment depending on the Conditional formatting
- Subtract working days
- Re: Inserting comment depending on the Conditional formatting
- Excel 97 Window Problem
- Spreadsheet too long and too high for desktop
- adding cells in time format
- excel formula
- SUMIF Formula Help
- Re: excel formula
- How do I do this?
- How do I sort like this?
- determining bold font in a string
- Excel Help - Save Files incrementally
- unable to select a cell
- Hide pivot field button when printing charts or stop lables appearing behind it
- To merge cells
- need Macro to combine multiple workbooks into one
- Removing password protection on a sheet
- Array Formula Not Correct
- Open workbook to same page every time?
- Save Link Problem
- Creating a table
- How to set focus or select next cell
- Duplicate vLookupt entries.
- Tab key in Excel
- size of "save" and "save as" boxes
- Incrementing letters
- Sending SMS from Excel
- Linking to Sheets
- Excel Multiple Pages
- Reflecting info between an excel file and a word one or two excel file.
- Filter Dupes to a separate sheet
- Need to do a fancy string copy plus
- Total number of Formula used in a Spreadsheet ?
- Set value of drop down list
- Add comments in a protected sheet
- PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic
- Error 1004 when setting range value
- Anyone want to make some money?
- From SQLite to Excel with ODBC-driver
- Excel calculations round off error
- Getting Notepad.exe text in Excel including leading spaces
- MS Excell error
- crack spreadsheet when not the author?
- Help with shell command
- Clipboard Data Loss
- Excel 2000 Pivot Table
- When was Modal/Modeless Form option born
- Unable to Sum() Number Values
- Check column - Excel VBA
- Average
- competent excel programmer in Elmira, NY area?
- Variable option list