View Full Version : Microsoft Excel Misc
- Bob? Code to Post?
- Pivot Tables
- Combo Box Resizes when clicked ... why?
- External Links - Embedded Objects?
- Combo Box Resizes when clicked ... why?
- Copy worksheet problems.
- full path name in footer
- Formulas don't claculate
- Advanced Filtering
- Save function adds a 1 to the end of a file name
- AUTOMATED COPY from one workbook to another
- Ranking in Pivot Tables
- Power Point
- Re: sales forecasting
- Area code funtion help
- Positioning a MsgBox
- Preventing invalid worksheet names
- Problem with opening a file
- SUMPRODUCT
- number changes to date ... how do I change
- Preventing need to hit Enter twice in UserForm
- counting frequency of text string
- datenretter dringend gesucht!
- Syncing Horizontal ScrollBars of Two Excel ListBoxes
- Comparing / Finding text in Lists
- Copying cells
- Double line tho centre of cell
- CSV - preventing autoformatting
- Add current row to another Worksheet According to combobox value
- Excel/Outlook integration
- Week Number
- Search in multiple columns using VLOOKUP?
- 'jumping' a specified number of rows
- Auto Volume
- Cells which don't scroll
- Double Clicking to go to precendent cell
- Conditionally inserting image
- Combine VLookup and MAX ?
- Transfering data from another Worksheet
- Windows in Taskbar Problem
- Minimize Single Window
- Make A Set Of Date
- tmp files - millions and millions of 'em!
- List boxes in excel forms
- Importing text more than 65536 having delimiter functions
- Excel
- File Date-stamp
- Euro symbol will not display correctly
- Duplicate Entries
- change font for drop down box
- Keystroke for formula
- vba question
- Securing a cell.
- Comment Box Keeps Showing
- Problems with INT()
- Windows XP Home and Office 97/Excel
- Workbook protection with enable macros
- Excel 2002 Problems
- Excel 2002 Problems
- how to change Save As default directory?
- override 255 maximum character length?
- Econometrics
- Charting
- Excel 97 problem
- Creating Dynamic Range - Missing Last entry
- Help with J-Walk's Menumakr
- Selecting A Range Of Cells Depending on Start And End Date
- Re: Rearranging cell data
- Can border for mats be locked?
- Indicating selected cell
- pivot table subtotals
- Error Messages
- RE: Rearranging cell data
- Restricting Multiple Inputs to a Range
- merging 2 columns, multiple cells with text -- possible?
- Trouble sorting with result
- Excel 2002 Problem
- Matching numbers in a column
- Select Worksheet Without Using Mouse
- Excel VBA - Display Selection Criteria on Report
- Displaying multiple Excel 2000 files on taskbar
- Format decimal values
- combining several excel files into one file on same worksheet
- Rearranging cell data
- Creating a ComboBox
- MS Query not finding network Access db
- Excel - wont open file URGENT
- Return Value from Match and Double Lookup
- Supressing a leading zero>
- Text wrap in merged cells
- Backup file in Excel
- VBA Percentage
- Recalculation upon opening a workbook
- Excel gets hosed after I look at print preview
- Show two fields in validation
- Merging 2 worksheets in the same workbook
- Excel slow saving documents!
- Published spreadsheet to web - cannot open
- countif
- Excel 4.0 Macro help files for Excel 2002 do not work
- Formula to return the name of a tab?
- Random Audit Help
- Changing of Cell protections after saving Excel File (2002)
- Autosave feature
- Detecting Page Change in MultiPage
- Need to get Excel toolbar icons
- Autoupdate Charts
- scrollbar listbox
- Selecting "Territory" in a column
- multipule instances
- Exporting from Lotus 123
- EXCEL ERROR
- Short Key for Selecting Tab Sheets?
- 24 hour clock
- how do i rotate a 3 shift 200man schedule
- Put column values in single quotes?
- Name Manager Version 3 Beta 2
- converting .rtf info to excel 2002
- Number Formatting Dollars to Cents
- File not saved in Excel 2K
- group of numbers
- count of autofilter 'choices'
- If/Then statements in Visual Basic
- Printing discontiguous ranges
- Seperate Text
- drop down options other than combo boxes?
- Excel 2000 ActiveX Controls disappear
- Banner Heading
- capture/maintain information in summary/charts
- Making range names "local"
- Backup file
- calculating time
- Links - Use Network Address???
- Re: single cell calculations
- Enter Key won't return to beginning of next row.
- Deleting rows with 0 value in Column X
- Re: pldt.xls HELP
- Excel & PDF
- Enter key will no longer return to begining of next row
- List boxes - Are sub lists possible?
- Automating transfer of data in cells
- Not showing blank cells in user form list box
- Defaults to year, rather than day
- Trouble accessing this NG
- full excel sheet size in htm?
- Control, Alt, Delete won't work!
- Upper Case
- Formula for calculating # of days between dates minus a particular date if present
- adding dates and times
- Re: Zero's represent empty cells when paste linking
- VB 6 - Purchase of
- date and time calculations
- Concat two cells with an LF.
- Forms / Command Button Help
- Excel won't store username in change history
- where to find cartoon of Charlie Brown
- SUMPRODUCT...using (RANG)<>
- Where can I find cartoons of Charlie Brown?
- What is <>
- Intersection of two lines
- Data Validation
- limits to amount of text in a cell
- "File Format is not valid" message - Excel 2000
- Disregard... File Format Message
- Hide sheets?
- CELL FORMAT
- Need help writing a Formula
- Excell Stops Calculating
- Fonts
- Automatically entering date or time in a cell upon entering
- renaming sheets-urgent
- Missing toolbars
- Excel Opening problem
- Using fill color in a logical argument
- Excel Auto Formatting Help
- Paste Value
- Code number
- vba needed
- DSUM Problem
- Lookup with two values
- Mailmerging Using Excel as Source
- Sorting data in Excel
- assigning value to a letter (Excel 97)
- Slow reaction when inserting new lines or copy & paste
- DATA LABELS IN EXCEL GRAPHS - DATA NOT SHOWN ON GRAPH
- cannot access anything in excel
- Trendline and 3-D chart
- Automatically Starting a Excel Addin
- mail merge
- "-Column search
- cannot see rows
- Feet and Inches
- Fill Series - Advanced technique required!
- excel
- Using VBA to copy a chart into Powerpoint
- Formula for competition timesheet
- Unable to calculate STD DEV for any value with 6 or more digits to the left dec.
- Circular References and Visual Basic Formulas: Trouble Opening Workbooks
- Excel Formula - Between Worksheets
- printing error
- Using variables in Excel 2000
- Grayed Button
- copying data from one book to another
- beautifying CSV files
- Web and Excel sheet
- Copy/Paste macro...with a few twists
- Worksheet 'shape' (#columns by #rows)
- autosave issue
- Unifying data from various Excel files
- Parameter criteria in MS Query to bring in all items for a single day
- Converting files
- Pivot table calulation
- Cell reference in macro
- Importing Tab files
- Updating Worksheet from Userform TextBoxes
- Track Changes In Protected Shared Workbook
- AutoFilter on Protected Worksheet
- Turning 1 into One
- Excel & Word auto selection from menus
- inserting circumflex above character
- formula help for making -/+ in a cell
- Symbols in header/footer
- Chart - stopping line from plotting when there is no data in cell
- Date and Time Calculations
- File size and data loss compare
- Re: How do I write code that will comprise a big range of values?
- Retrieving Data
- Linked Cells
- Publishing quality output resolution
- Excel Training recommendations
- DSUM Criteria HELP
- Random File generation when saving
- Sorting multiple sheets at once
- Repaired file
- opening attachment sent from excel spreadsheet file to outlook express
- Format Cell Formulas
- Auto launch custom toolbar
- Data Source for a Range
- Scheduling an excel file to run everyday
- Catostrophic Failure
- Repaired File
- worksheet protection
- Add-ins
- booking form
- Preventing auto-formatting when Replacing
- OT: Google search add-in for Word?
- Running an excel file with macros in browser.
- Database as source
- Page Numbering (ie Page 1 of 3)
- Combining multiple cell values with "hard" carriage return separating each
- Excel math functions not working
- Auto Caculation
- Re: Formatting Dates
- Importing an Excel spreadsheet into Powerpoint
- #NAME
- Removing Links
- Can you conditional format bar and pie charts in Excel 2000?
- Updating Vlookup chart.
- Re: Excel won't let me insert rows
- Conditional Formatting
- Excel "Shortcut Keys"
- Re: Deleteing Macros
- #NAME
- Move row to a different worksheet when criteria is met
- #name
- Can't install upgrade
- What processor(sys requirements) should my computer have to run the following:
- Conditional Formatting
- Invert a column of numbers
- VB password breaker?
- Wrap Text
- EXCEL MACRO DEVELOPMENT
- Importing Excel list into email program?
- Re: Date Range in Data Form's Criteria Screen
- Print Range Scaling in Access
- Re: Custom AutoFilter limitations in Excel 2002
- How to automatically move to a new cell...
- Eliminate #Value! in fields
- Pivot Tables
- Input must be last entry + 1?
- What's wrong with the RETRY button on data validation?
- Question on custom commandbars
- Excel menu taskbar disappears when using a powertoy
- Userforms and Inteli mouse scroll functions
- hidden column
- showing total of 10 digits.
- CSV in Word==>Excel....?
- Excel formula not calculating help!
- password protect/hide custom views
- Highlight a row
- Using names in named formula
- Formula "Change" Problem
- Not getting messages
- Date in text format
- Almost have it just need a little help to complete
- HP IPAQ/Excel
- Visual Basic - Properties password breaker
- Re: Character limits in a cell
- Hidden Rows in Excel 2000
- Duplex printing in Excel 97
- Fill values for formula
- Mathmatical formula help needed
- Most recent values. Help plz.
- How to install a workbook as a shortcut on the desktop programmatically
- Conditional Number Format
- Run mackro before close
- How can I increase the number of characters allowed in a cell?
- Sum Formula
- Excel wont open
- Merging text from various cells into one cell
- Need a little Macro ...
- Pivot Table formula
- Working with imported data - file size etc.
- Comment messages are "squashed"
- COUNTIF with 3 exceptions
- hyperlink trouble
- Move folder in XP
- Print Preview Freezes Excel
- Clickable button on worksheet & hiding question
- quick way to combine 2 files?
- ignore this - test that couldn't go to nntp.test
- ODBC Connections In Excel
- Problem with creating two variable data table
- Excel And Stored Procedures
- How 2 Reduce Worksheet Size After Deleting?
- Creating chart with two variables and related trendline equation
- Cell formats
- Covert PDF into CSV/Excel format
- 1024 char cell display limit
- Maching Condition
- Works XP to Office 03
- Print ranges on one page
- Parsing cells
- creating form in xl.
- Clicking link minimizes Excel
- How do I stop a Textbox in a Userform converting numbers?
- Linking sheets = Problem
- vlookup with more than 1 condition
- auto filter
- ignore - another ef test sorry
- linked workbook
- Re: Cell References
- Excel file extensions
- Paste Special Formula Only
- Preventing changes in the Options
- column inches
- Remove Page Break In Excel 97
- 100% cpu when modify subtotal components
- Protecting a Cell
- Excel Display Errors in file
- password protect
- Scenario Pivot Table[Urgent]
- Wrap Text
- Auto Correct Formulas !?
- Input Box with Validation
- Hide/Unhide Sheets
- No maximize or minimize controls on Excel Window
- Excel on thin client
- Excel Spreadsheet
- how to concatenate a newline?
- Re: numbering sheets in a book
- Code Bloat/Growing Excel files?
- Code Bloat/Growing Excel Files
- RE: Protect worksheet
- Maximum characters allowed
- Mysterious File Corruption
- Excel export CSV - chngs text to numbers
- .XLL Add-In Question
- SUMPRODUCT question
- formating formula question
- Importing macros from Excel97 to 2000
- shortcut not working
- excel 2000 drawing icons are graied out "dont work"
- Run Time Error 7
- numbering
- Removing formulas and keeping results
- Link path issue: users in different versions 97 & 2002
- Mail Merge
- Larger View on Starting Excel
- PathName
- Printing Multiple Pages
- forecasting amortization values for 1 year(monthly)
- Sorting Data in Protected Sheet
- Avoid weekend formula results
- Landscape macro
- PivotTable: Customized Calculations
- Lost "Fill Handle"
- Changing column from upper to proper case
- Custom View - VBA to Modify/Save a view?
- disable auto-creation of email hyperlink?
- Like data
- Help Request
- Coping Color to Another Excel Version
- getpivotdata
- vba: userform text box...set default text to a variable?
- Forced print margin
- Worksheet Data
- Wooksheet setup
- Converting a column of cells to change the text to be capitalized.
- VBA password recovery?
- Sub-menus for Right Click add ins
- custom data validation
- Repeating Random Number
- Attempting to open Project VBA--"Project is Unviewable"
- Saving in 2003 Excel
- Excel and Quatro
- printing 2 pages in one A4
- CVS
- printing excel 2 pages in one sheet
- How do I move a decimal over two places?
- on tab out
- Mouse problem
- Help Request #2
- .tmp files
- large view
- placing a reference to a cell in a print header
- How does Excel work on a Network?
- Questions about excel on a network
- opening Excel files from Explorer
- Can't see my file
- Adding List boxes to pivot tables
- Keeping task pane open
- Selecting cell ranges only with text using a macro
- Digital certificates
- Format (excel 2002)
- Excell E-Mail
- E-Mail
- Only want part of worksheet
- Upper() in VBA
- Total by Name
- Conditional Formatting
- Page setup for multiple worksheets
- Un-install Off. Proff. / Excel 2003
- random numbers / superbowl pool
- vbCancel to exit Sub
- Excel stop responding when I save
- merged cells and text wrap
- Word+Excel - merge
- How to protect cells?
- Macro Error, annoying plz help?
- How can I Freeze a graph?
- Insert a 'tick' symbol???
- If value = 0, cell is blank... how?
- annoying problem with excel
- Curve Fitting to Data
- VLookup?????
- mouse problems
- Find function in macro cannot find value
- Drop Down List Question
- Title Rows printing
- BOB? Craps Help!
- Can I save only one sheet of a workbook and leave the rest unchanged ?
- Program Error -- EXCEL.exe has generated errors and will be closed by Windows.
- Date formatting
- Rows reverts to zero height
- Help with IF Function
- PROBLEMS STARTING EXCEL
- sort vs. print
- Command Button Problem
- Drop Down List Question!
- date format
- Missing data
- publishing
- Help with a formula
- Merging Data in a template
- Copying One Worksheet to Another and Maintaining Formatting
- Date formatting again!
- Drawing Addins
- Controls error
- Entering users names in shared workbook
- please reply
- Date Format Error
- Report Manager Add-In
- Calc tax
- Cell change on User Click
- copy formula
- Macro for selecting data to sum using a fliter over 50 sheets
- Latest version of Excel that will read Excel 5 files
- Moving Works Spreadsheets to Ofice Excel 2003
- Update pivot tables after running ms query
- Downloading Excel 97/2000 Viewer
- Cell Protection - How Do I Prevent Input
- Problems with cell references
- Read only
- Cell color change referencing the date in designated cell
- TIME....again
- Many Rows = Many Column Values
- line
- Excel lookup - Index/Match/Indirect help needed
- unexpected behavior
- Creating a Gant Bar in a row for a task
- Not quite what I was looking for.....
- More that 256 Colums?
- Convert time to Seconds
- hyperlink
- Formula HELP!
- problem opening workbook in Joseph Rubin's new book
- Moving complete row from one sheet to another
- Excel 2000 error in Poisson function
- Run Maco when workbook is first opened?
- Excel/Handspring Visor/ Time Sheet/ Hot Sync/ How to
- quotation marks
- Protecion
- Moving Average
- Looking for some help.... How can I do this in Excel?
- Filter more than 1000 unique records
- Copied data not treated same way as typed in data - can anyone help?
- FIND function trouble
- Printing many charts on one page
- Excel embedded in web browser
- Text Import Wizard
- Links in a spreadsheet
- Read-only in explorer
- xls files that will not open
- Counting Numbers
- Next Empty Row
- Excel Formula
- Need more columns in Excel!
- Excel workbooks have blank pages and loses data.
- Return a value based on different conditions
- Vlookup follow up
- Date of a movie due back
- delete and move to left ....
- Need to add to current formula
- always last active cell
- Finding the sum/ average of non numerical values?
- Hide Cells
- Office XP: Excel & Word slow to open files located on a Windows2000 Network
- form question..??
- No file functions at upper right
- backing up Excel macros
- Forms-clearing
- second() format
- Conditional Formatting dates
- Calc'ing Age based on two dates
- Converting seconds to days, hours, mins and secs
- cube
- Need more help please
- Allow user to drag and drop without mucking up formulas
- Formula, calendar of duties
- 2 sheets on 1 paper
- Pivot tables
- Ranking and sorting
- making a two position custom toolbar button
- Filtering based on a filter
- Pivot Table based on date
- range selection address
- Using Excell 2000 to do a bulk mailing in Outlook 2000
- Merging spreadsheets
- Re: How to fix a list with swapped column data
- Excel Update Links Message
- Converting xls files to quicken
- Save book as CSV
- formatting time
- Excel forms command buttons
- Separation of time (duration) in to separate columns
- Is a 3D SUMIF formula possible
- spreadsheet
- Pasting drawn objects has problems
- Excel data problem - need to create day by day process chart
- Copying an Excel 2002 Table into Word 2002
- Linked Spreadsheets Grandfather Name Sticking
- Warning Messages
- Calculating Manually with a querry
- daily report
- Opening dos programs
- Is it possible to use a vlookup looking up peoples names
- How Do I Pass Data Between 2 UserForm's
- Problem with PageSetup & Printing
- Excel 2003 pivot table date group
- Change Formatting of Comments on Cells
- How do I select the date portion of a datetime field
- Extract Comment into a cell
- Tough one - Conditional Formatting
- Sort
- Excel Pivot Table
- RowHeight Macro
- Re: Save vs. Save AS
- Formatting help
- Creating a Macro that will Pull Emails from Outlook
- Page break
- page break
- Spreadsheet (Macro) glitches
- A document with the name "xx" is already open......
- Excel 97/2000 - Autofilter - Top...... or how will I get the right date !
- Re: Save vs. Save AS
- Spacebar
- CountIF based on multiple conditions
- Copy Worksheet 2 into Worksheet 1??
- formatting combo boxes
- refresh offline cube
- Worksheet_Change Function - Conditions for execution
- Cannot access read-only document 'filename.xls'
- Creating a data entry form
- Mail Merge Excel to Calendar Format
- Open workbook is invisible unless in full-screen mode!?
- Use arrows to navigate
- Search Preferences Don't Save When Changed
- BOB? More Craps Help
- Object Library Not Registered
- Data query drive error
- Compile errors when starting/stopping Excel
- Using COUNTIF (specific cells over multiple sheets) … can anyone help?
- exel
- Evaluate a Range
- Widths
- Cannot Sort: Help Please
- Formula help!
- Copy Paste Without formatting
- Excel files opening problem
- Excel files opening problem
- importing data from webpage and using it.....
- counting checkboxes
- mysterious edits
- Find and Replace Help-Values & formulas
- Find & Replace
- cell comment
- Countif with 1+ specifics
- Exporting data in Excel 2000
- Sheet name problem
- Macro to select all and name range
- Resize rows in a protected sheet
- Macro Trouble
- Excel Number Formulae
- Comparing Excel Files
- Changind Default Number Format
- no response from worksheet
- Wrap list of numbers to same page
- compare columns
- Find "Time" Formulas?
- Searching Multiple Sheets
- Delimited Files
- Null Fields / Mailmerge to Word
- formula- sum?subtotal? issues
- show comments next to line item
- Selecting data to the left of a specific character
- excel for teacher's gradebook
- Filtering data within macros
- Default Watermark
- resize a check box
- Help with Excel formulas - example attached
- Select/highlight alternate cells
- Using Excel error #N/A in a formula
- Strange behavior of the alphabetic sort order
- ISBN #'s starting w/ "0" are deleted, how to format so "0" stays put
- Open File: Sorting of folders problem
- probs with devising quote system from master list of products
- Renaming Active Worksheet
- Formatting drop-down menus
- Custom Footer
- Can't open Lotus .123 files
- Retreiving top 3 MAX values
- Open worksheets in same Excel instance
- Extract Hyperlink
- Formatting cells from internet
- replacing "-"
- Grouping and Protecting worksheet
- Size of Report Mysteriously Increasing Daily
- Working Weeks
- Input Box to rename a Sheet?
- Microsoft Excel ASC II Text Files
- cells
- Cell word wrap.
- excel error?
- Re: #N/A message
- Re: #N/A message
- Excel 97: Exporting Cell values to text files.
- prevent copying cells
- Map Feature in Excel
- Re: ALPHABETIZING SPREAD SHEETS
- Trying to get a function for a whole column...
- How to prevent users from selecting protected cells in XL97 ?
- Data from Access query to Excel
- Excel Sort
- timeline
- Autocomplete
- Excel opens but an error message appears
- Spreadsheet Templates
- Alphabetize Letters in Excel 2000
- Spreadsheet Updating Takes Too Long
- Vlookup
- When Excel Opens it Starts with Book2
- Printing Orientation
- Help Please in Summing
- VLOOKUP
- Month Formula
- moving a 2 words to a new field
- incremental file name
- Apostrophe's
- Graphing question.
- ALPHABETIZING SPREAD SHEETS
- Passwords
- frozen graphs
- formula error
- Multiple formulas
- Excel find and replace within a range of values?
- Re: Postitive to Negative numbers
- Re: Postitive to Negative numbers
- How to select same ranges in multiple worksheets?
- Excel file
- Data entry from website
- Calling a Public Sub inside Excel from Access
- Object Library Not Registered
- exclude value from formula
- OWC10 spreadsheet component question
- Dates of Birth and ages
- Re:Count number of columns
- Automatic date entry upon cell completion
- names
- formatting: highlighting, wrap text, etc.
- #n/a
- Help does not allow entry in Answer Wizard or Index tab
- Help does not allow entry in Answer Wizard or Index tab
- Help does not allow entry in Answer Wizard or Index tab
- excel e-mail file
- Corupt excel file ???
- Error Message
- Sumif based on 2 conditions
- 40 characters
- Obtaining variables during a userform_initialize event
- Email Attachements Don't Open in Outlook
- major trouble
- Printing in mirror images
- Adding Excel to XP home
- Excel will not close
- Another date handling question variant
- excel 97 to excel 2002 conversion issues/solutions
- Need to export Excel into Word
- I need some help using a list.
- MS Query Edit
- Text cells converts to dates
- Change case for all text in cell range
- Excel 2003
- convert number of seconds to date
- CLIPBOARD
- printing sheets
- Gridlines when printing
- Excel VBA / Data Sorting / Maniputaltion
- print icon grey out
- Counting items within time ranges and containing text
- Using a function result in one cell to change a format in another cell
- Summing same sheet $A$1 in multiple workbooks
- Problems with Controls Embedded in Worksheet
- Counting occurences of strings in a coloumn
- Punctuation in Excel
- How many actual days left formula
- merged cell wrap text autofit issue
- Excel background
- Is this possible
- VB code
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.