MrExcel Message Board Archive

  • Find Data, Copy Data, Paste Data (IF)
  • Loops and Tool Boxes
  • Filters with choices based on previous selection
  • Superscript.
  • Error on sumif formula that links to another workbook
  • Dividing cells
  • Array: {=IF(SUM(IF(O9:V9"A",1/COUNTIF(O9:V9,O9:V9)))=1,"ok",
  • charting
  • Enter a formula in VB
  • Tab stops between form controlls
  • Delete all comments
  • Filter and select rows
  • user-friendly data-entry
  • filling in dates with out weekends
  • Lookup across worksheets
  • Validation.
  • VB line format
  • path function?
  • converting date to string
  • Moving Values in one Column????
  • Excel Macros to repeatedly graph price charts
  • 2d array transposing
  • Changing font color based on content
  • 41111111 etc. error
  • Greyed out sort command
  • to name the point in a scatter plot
  • Date or Calculation Problem???
  • Macro question - copy / save excel to excel
  • Insert a column into an array formula?
  • Need to total a large spreadsheet using sub-totals in one co
  • how to close personal.xls -- how to close excel after a macr
  • Combining Data from multiple workbooks into one workbook
  • trying to learn vba
  • same prob as before with date to string
  • need help with this code==SOLVED
  • SLIDER
  • Find the Temp folder from the system settings
  • Average rows and place that value in a new column
  • duplicate rows delete
  • Locating errors in macro code for dummies (like me)
  • DATA MATCHING
  • find value and selet entire row.
  • Adds macro to every save
  • Formatting a negative percent
  • Excel Viral scans
  • Match cells in Column and Row and display data....
  • COUNTIF
  • Calculation of past due Principal & Interest
  • Data
  • Stupid question but i forgot how to deal with it...
  • stupid question
  • Chart
  • Record Highest Value==SOLVED
  • Match Values
  • date in filename
  • SUMIF OR SUMPRODUCT
  • How to best summarize data
  • locking text boxes in Excel
  • MAC woes
  • Print Macros
  • Removing Cell names....HELP!
  • file format is not valid, Excel 97 sp2
  • page numbering
  • Ampersand in Footer
  • 3 columns of info with several row, need to delete duplicate
  • concatenation for four or more cells
  • Formula help Please!!!
  • Duplicate Value
  • another date format question
  • Pivot Table Borders... Keeping borders when changing page fi
  • Question for NateO
  • How do I change a range?
  • restructuring database
  • utilizing multiple worksheets for lists and one for report
  • Imbeded IF Statements
  • Line auto count formula HELP
  • text line shows as all ####
  • Create new Sheet by Macro
  • Get external data question
  • is there a way to find an empty cell
  • Test for selection
  • Date
  • copy selected columns to a new spreadsheet....help
  • Heading From The First Column
  • can I open excel workbook as a HTML/ASP page
  • Printing in Excel
  • Validation Prob.
  • What is the command to switch rows and columns? N/T
  • To the poster XL -- -- a numerical analysis question for UDF
  • Parcing Street Addresses
  • VLOOKUP? MATCH? HELP!
  • "IF"-type process in a macro?
  • Ranking Data
  • Counting sort of
  • Columns and Row Numbered
  • Is there a formula to move a cell up if text changes
  • Repeat Sheet headings on each page
  • Consolidating Worksheets
  • Protect data being pasted over protected cells
  • advantage