View Full Version : Microsoft Excel Misc
- Can a variable (date) be used in a SUMIF formula?
- Data Set Frequency
- button help
- Random selection of cells
- Hyperlink problem
- CANNOT PROTECT
- Formatting text to Conform to Standard Entry
- Cell sizing
- Excel Drawing
- Pivot Table?
- Re: Unable to open file in excel... Document not available in Word
- Re: sequential numbers
- Excel 2003
- Re: sequential numbers
- Work Sheet Tab
- Excel vlookup problem
- Starting Excel from file Help please
- Using <Ctrl>-Click to open files
- Starting Excel from file
- Solver in Excel97
- Excel 2000 Crashed on PDF Conversion
- Macro - Copy from one page a return to starting page problem.
- Single sheet with multi column spacing
- Re: can I extract numbers to excel from acrobate
- disable vs enable macros
- Excel Columns Display Right to Left
- Excel - conditional formatting - highlight subtotals
- User Access Restrictions
- 2003 Excel Macros Run Slowly
- General Discussion Group Questions
- Can't turn off "Automatic" update on links
- Adding an Active X control to a cell
- REQ: Need help with function...
- ColorIndex property stopped working
- Command Button Protection
- Dynamic graph turning static
- Dynamic graph turning static
- change background color of row until condition is met
- Calculating Hours
- Conditional formating
- General Number Format
- Printing issues (VBA)
- Exporting to a unicode text file
- Moving data
- Need single column/row of numbers to print down then across pages in order
- Drop Shadow Problem
- Excel - Retrieving data from .dat files
- Unable to Display the "Format Cells" Dialog Box
- Print Button help
- If Statements that return blank values
- Access Database Conversion to Excel Database
- Inserting space between merged text
- Toolbar Opening Multiple Files
- Re: Group collaboration????
- Re: Auditing does not show blue lines
- financial excel formula
- How can I replace ~ characters with nothing?
- Pick a # by Rank within a Range?
- Print Buttons
- how do i run excel 2002 form in excel 2003
- Auto insert date problem (TODAY() or NOW())
- Folder name in footer
- dropping leading zeros on import
- Number fields
- Cell bordered without printing
- Halting code
- Select case help
- worksheet references
- indent in a table
- Stopping automatic change to date format
- Hot keys
- Excel 2002 vs Excel 2000 pivot table
- Running Word Macros
- Creating other file types in macros
- Re: Auditing does not show blue lines
- PDF To XLS
- Calculated Fields in Pivot Tables
- formula problem
- creating Pivot Tables in Macros
- Getting a chart on the web
- formatting cells for dates
- Excel spreadsheet notifications
- Keeping only actual data in the Pivot Table's choice button
- hotkey combo for "paste special, text only"?
- Big mouse pointer size in Excel
- Removing duplicate cells/rows in excel
- Numberformatting (Amount)
- Excel (Office 2000) - problem with formulas becoming too long when copying
- arrow funtionality in excel
- Problem when printing from Excel
- Comuting someones age
- Protection with macro & paste
- Hyperlink
- Can I stop scrolling at a certain row?
- Excel freezes: From Palm to Win
- Character codes
- Spreadsheet validation
- COMPARE IN EXCEL
- is there a code that could place a space
- Lock formula to cell
- VLOOKUP & table array selection
- excel printing
- Problems with Advanced Filter in Excel 2k
- Organizational Chart
- FormIDEA reviews ?
- Confirmation Pop-up
- VBA counter
- Sum range of cells with VBA
- One-to-Many Connector in Auto Shapes
- send to from the file menu
- Counting Checkboxes
- Re: Unable to open file in excel... Document not available in Word
- windows display
- Named cells
- could someone plse help me with this formula
- Excel subject line
- Pivot Chart: Can Page Fields Interact?
- Being able to search what a formula produces
- Start UP File Location
- Change Format
- Change same cell in multiple files.
- Re: Rounding spreadsheets
- Simple Macro to copy each row in the database "X" times? (Excel 2002)
- freeze pane
- Enable Macro Won't Go Away
- Multiplying cells
- Re: How Do I Check The Contents of A Range Name?
- Excluding hidden columns and rows when copying to another workbook
- Column width totals
- list box font size
- sumproduct function combined with named range?
- Keep user from moving across sheet
- excel macro on startup from DOS
- Header & Footer
- MS "Query", MS Excel not playing nicely
- Converting Microsoft Works files into Excel 2000
- Excel 2002 cannot copy data from website to excel
- Compare side by side
- VBA for each sheet in book
- Drop Down Lists
- Odbc
- Only allowing certain users to access my Excel spreadsheet
- Importing from Access to Excel
- Protecting Workbook Data
- Reverse filter?
- Round a number
- Excel.exe application error
- File format not valid
- Double opening
- Tracked changes function misbehaving
- Help with VB Code
- Upper case a worksheet
- Smaller workbooks?
- How to print to a csv file?
- macros and links
- Excel 2002 configuration
- Re: How Do I Check The Contents of A Range Name?
- merge and center
- referencing cell contents, after deleting and shifting new contents into cell
- Web query link to sheets
- Help with renaming data in a new column
- performing a calculation on a time range within 1 cell
- Formulas that won't formulate
- Rotating/sorting data
- Excel worksheet saved as web page--trouble printing
- Lookup Functions
- Print pages in collated order
- Re: Problems with Import from Access
- Error Message
- Data Validation - List - Miscellaneous
- alternate headers and footers
- complex reporting
- combine worksheets from 2 excel files
- combine date and time cells
- VB in Excel 97 to Excel 2000
- Formula Question
- Excel Fromula writer? Cubic formula
- Conditional Formatting
- automate the macro to reponse to prompts
- formula question
- Unable to read file
- update record in database
- Ron Bovey re: "Trim Selection" in ExcelUtilities
- Links update.
- Formulas using dates, pls help!
- Duplicate worksheet
- Excel 2002 Command Button
- Australian Telephone Numbers
- Cell Format Issue
- Automatically Resizing Listboxes
- Wont Auto Recalc
- 32 mb file!!!!!!!!!
- List Boxes
- MVP's?? Excel 97 AND Excel 2003???
- Excel to Word mail merge problem
- Conditional format
- Column headings in Excel showing up as numbers, not letters
- Repeating cell-contents
- Format cells with dates
- Open workbook doesn't save data in editable copy
- Naming Cells
- excel function to call solver (VBA Macro)
- Compare and Merge
- Deleting rows in a workbook though all coresponding sheets
- Print same column headings on each page
- Password
- Excel VBA - running a different routine based on value of cell
- Overflowing text.
- Re: Rounding spreadsheets
- Macro text input
- Changing to new dates
- org chart
- Formatting negative numbers
- Linking a cell and a sheet name
- SMALL Function question
- add 1 leading zero if missing from a text
- Way to have rows automatically colour to separate data no matter how they sort?
- Array formula based on Chip Pearson's lookup data samples
- Changing the number format
- creating a shortcut in module
- CSV formatted text file to Excel
- Excel97 - Template XLS to actual XLS without Macro's
- how can I email the results and aviod getting an "Update the sheet?" message?
- lookup i think!
- excel files
- excel files
- Formula - pass and fail
- Testing
- Formula - Pas or Fail
- Entering Lengthy Text Info in Excel
- save graph to bmp
- collate alwyas ticked in print dialog
- MVP's?? Why is Excel 97 VBA much faster than Excel 2002 VBA
- Rounding
- How to hide "Get Started windows"
- Bringing up Old Files in Excel 2003
- Taking Data in Excel and Putting it in Word
- Creat Schedule
- excel sheet hidden
- Excel - Virtual Basic problem
- Subgroups in Macros
- Text
- opening files
- Extract similar values
- accessing excel files
- How to rename a custom menu
- Sharing files
- printing blank worksheet
- Excel's RAND(): Freezing & De-Freezing?
- opening a filedialog window
- Excel Label Printing Problem
- Multiple files
- CountA
- Opening file causes bogus err msg that file is already open
- Excel printing problem
- Edit a web query in Excel 2002 that runs a dialogue box for the user to input the name of the city.
- Consolidated pivot tables
- Linked cells with patterns
- Paste a picture
- Macro help
- Auto Fill
- Workbook default for borders
- Superimposing Page Numbers On Worksheet
- Creating Reports in Excel
- KEYBOARD NOT WORKING
- Insert Object when condition met
- Xl2qif Program
- Printing lables from excel
- Error message: No more new fonts may be applied in this workbook.
- COPYing the content of a cell to a graph as Title
- Writing a multi-function macro
- Excel Program
- Change Copy to what?
- Protecting workbook on open
- enter text 2 cells same time 2 different sheets
- How can I use a cell reference in evaluation criteria?
- refer to a vlookup value
- problems opening excel shared workbook
- Printing Problem in Excel 97
- How do I keep pages from loading at startup?
- Unsaved data
- problem opening excel file from disk
- Setting the rowsource of a listbox
- Excel 2000 Spell Check
- Autoshapes - placing on screen
- help need to match a string
- how to get rid of read only
- Auto-import word tables into excel?
- Opening file to a certain worksheet
- compile error in module
- Picture / Image, behind data ????
- invalid link error
- Using cell reference with scenarios (What-if-analysis)
- average formula help
- Picking Teams
- My entire worksheet is behaving like a button
- How to change size of bars in bar charts?
- Macros
- Excel Menu problem after Scanner SW install
- Spanish row = L vs. English row = R
- Replace text after punctuation
- move row data to columns
- Excel and Word - Second Post
- determining macro status in a cell
- Folder name in templete footer
- problem opening excel files from my documents folder
- Removing pennies
- Re: Automatic Links
- Excel files/data to C program ?
- text <-> number conversion
- Cannot open Excel 2003 files using excel 2000
- Tab (Sheet) Name ?
- Re: Menu Bar
- is there any way to STACK the page tabs?
- Problems with mail merge
- File shows locked and opens as Read Only
- Formating one cell reading date from another.
- Disabled macros
- Is there a way to insert a control into a cell?
- Macro to pop up a legend on screen (of sorts)
- Triggering AfterUpdate Event
- Shared - The file is locked.
- Cell Range problems
- Seperate email addresses?
- Repeat cell-contents
- Counting Cells with formula
- overlapping sums gives incorrect results
- How long will LOTUS 123 be supported by windows?
- Converting Minutes to Seconds
- Carry Forward Totals
- Protected Sheet Disables Autofilter
- Formatting problem...
- Last name of person in spreadsheet "True"
- Pivot Table Question
- Pivot Table Refresh Speed
- How to format a range of numbers (single column) to time format in MS Excel
- sort by subtotal values
- Search for Password Protected Files
- Excel 2003 footer font won't take
- smart tags in Excel 2002
- Month and Year
- Servers and Excel
- Excel probelem!!!!
- Formatting & Checking Text in a cell to ensure a minimum length of 30 characters
- deleting cells from a calculation...
- EXCEL VBA/CALCULATION - Adding Totals From Selected Cells...
- Hiding Formulas in cells
- Gridlines:Changing
- Help with MM:SS Format
- Option Button - macro
- Normal font
- RE: Last name of person in spreadsheet "True"
- changing calculation mode (xlCalculationAutomatic) w/o showing workbook
- General Mail Failure
- Printing data double wide
- Printing data in 2 columns
- Merged Cells and not printing all content.
- Macro to undo filters
- Formatting
- Prompt user to Open file in VBA
- underlines
- Import file directory
- All Caps
- Cannot print titles (top row) even though worksheets not grouped
- Worksheet to Word?????
- Missing Microsoft Word 10.0 Object Library - Tools Reference Error
- Sorting & retaining cell format
- is this a bug? macro? virus?
- Missing Microsoft Word 10.0 Object Library - Tools Reference Error
- Creating an Email Distributions list from a file
- Exel 2002 freezes when opening sheet
- running a specific macro on opening and closing a workbook
- edit the build in headers and footers
- Re: Footer printing
- How do i work out what each one has worked ?
- Changing cell data
- Explanation of Code comments
- Copying a Worksheet with a Chart - Extra names
- Excel-merged cells cutting off text
- How do you make a page break happen after every cell...copy?
- Draging to copy cells
- Copy and paste when using subtotal
- put multiple database info into one file
- pasting ranges, but not with hidden columns or rows.
- The use of A + when referring to a cell
- saving excel 2002 file in Pocket Excel
- linking to external file based on cell value
- Fill Handle
- Cannot open file
- Addin Issues
- Random numbers with bias
- Rounding Format
- Default Style
- Sounds with Excel
- Sub: finding a precise value
- Flash display of chart
- PDF ?
- Options reset to values of most recently opened workbook
- Path and filename in every Excel workbook
- Change the characteristics of X Axis
- That old Invoice toolbar in Excel 97's Invoice Template
- How to automatically jump to the formulas origin
- filedialog problem
- Excel Columns
- Error: 514: Transfer Palm to Windows
- Re: Cannot empty Clipboard
- Tabs in worksheet
- Unicode support
- Excel 2000 - Removing phantom links between workbooks
- Tarcing links in a workbook
- Change default comment font
- excel problem
- Fatal error situation in Excel when trying to closing files which is an email attachment
- SYLK file format
- removing blank cells
- Pivot Limitations
- Excuting a macro within an "IF" statement
- open a "sent" excel file from outlook
- Excel pivot tables using Access as the data source
- Find/Replace on leading quotation mark
- Re-Installing Excell 2000 on new computer
- returning more than one result...
- Information on sheet 1 to make changes in all sheets of workbook
- Vlookup to sort on letters, not numbers
- Formatting time in cells
- Problem with file name during save
- Ranking problem
- Hiding Worksheets
- Color Code Tabs In '98 Excel??
- creating a function referencing multiple worksheets
- Automating Email (CC:)
- IF STATEMENT REFERENCING A BLANK CELL
- overlay two time series in a chart with different data amound
- Need help with adjusting width of VBA-created toolbars
- Make a Macro Run One Command at a Time
- Number Format using dashes
- files size expands for no apparent reason when saving.
- Report Manager for Excel 2003
- Help!!
- Printing - Fit Columns & Rows to page
- Conditional Formatting - Hiding Rows
- Finding Text in a String
- fomatting cell to decimal place
- 'Find' already wanting to look for something
- Passing SQL Parameters for Pivot Reports
- Re: How to increase open list
- Re: How to increase open list
- Re: How to increase open list
- restoring an Excel File
- Export to HTML
- Changing a cell color automatically based on a date
- Assign a value to a cell
- Sumif on values in multiple columns
- average and stdev
- Compounded Annual Growth Rate (CAGR)
- deleting cetain rows that match a criteria
- printing 2 pages on 1 (2up)
- Error message with AutoFilter
- opening a workbook on a cetain page
- IF statement with combo boxes
- Margins Error
- Help Me
- Send as an attachment
- Importing CSV FIles
- Macros Disabled
- Color of active drop-down arrow to the field name in the header row
- Out of memory error
- Changing Column names
- Inserting Space After Subtotal Function
- Chart select!
- Linked files and file protection.
- conversions
- Subtracting Columns
- lookup function not returning correct value
- Amortizing Term
- 2 XL versions on one pc?
- More info. for Amortizing Terms
- 16th digit turns to zero
- opening a txt file in exce and losing decimal places.
- Excel to Money transfer of data
- Showing another worksheet from a form
- Help! fonts < 8pt not printing (XL->Ppt)
- Excel and flickering screen
- ExcelFix (Download)
- missing commas when saving excel as CSV
- Unable to save excel file
- IF conditional formatting
- Full Calculation not doing its job?
- excel workbook very slow to open - please assist
- Copy Paste Problem using keyboard "cntrl C" and "cntrl V" it tries to paste image of spreadsheet
- Re: Outside Input
- Need to retrieve a deleted Excel File
- vlookup Dilemna
- How to query from two worksheets - Complex?
- Reflecting all Worksheet Names onto one Worksheet.
- excel problem
- Array Formula
- Variation to code required
- Excel malfunction
- Worksheet Names
- Need to Customize Existing Excel Files in New Format
- Help with Mailing Labels
- conditional formatting?
- Excel Won't Open
- option box cell link
- grouping in Excel Pivot table
- Missing links
- Pivot Table Show Data AS
- end(xlup)
- Excel - two way link bewteen lists
- accessing Excel sheet properties
- Protected Worksheets
- deleting pictures
- Different after emailing-Why?
- password vba
- two identical copies of the same file in Excel
- Getting "=A1" instead of "4"
- Headers and Footers
- Data validation
- Column Titles
- Sheet Protection
- excel sheet with vba coding
- #VALUE! Occuring in formula result
- Charting Data That can grow
- Moving around in an Excel Spreadsheet
- Headers and Footers
- vlookup problem
- vlookup problem
- XLQuery.xla cannot be found
- Excel Showing Code Instead of Data
- Exporting Documents
- Excel 2000 Chart question
- Help please!
- Re: Drop down list - help!
- Re: Drop down list - help!
- Strange problem when saving excel 97 to Windows 2003 server
- EXCEL slow
- Excel Formula Issue
- Excel Formula Issue
- how do i bring over text and number t
- Array formula - with OR function returns wrong result
- too many formats
- Automatic Save
- Statistical Applications Using Excel 2002
- Trying to achieve blank cells in formulas
- Combining multiple excel files
- Defaul start up sheet on a workbook
- New worksheet
- Microsoft Map
- Setting Default Font for Comments
- Publishing excel Speadsheet to web page
- Polynomial curve Fit - but not on graph
- From xls to ps
- Syntax Trouble with SUMPRODUCT
- alphabetical order
- Negative numbers
- excel calculations
- automatically select cell in another column
- Using Data filter function
- question for all you gurus...
- Excel 2000 HTML/XML format Question
- Hyperlink macro
- Excel Spreadsheet
- editing
- open text file, retain column-break settings
- Sequential Numbering Set-up for Multiple Sheets in a Workbook
- Newbie - Please Help
- Re: enter in lieu of or in addition to tab
- toolbar customizations disappear
- comparing data in different sheets
- replace with tabs
- Change a seconds value into mm:ss
- Comment print format
- Excl-97 Conversion
- Problem with base address
- Excel Filtering
- DOCUMENT CONVERSION
- commision function
- Calculation problem
- save text "|" delimited
- Disable save button
- Stock Options Prices
- Opening E-mail with excel attachment
- entering numbers with 0 in front of them
- date formatting a cell
- calculation problem
- Inserting an Excel file into WORD
- Re: How do I link two data validations together?
- Inserting an Excel File into WORD
- Linking formulas between worksheets - but not the specific cell values
- Extract Random Variables from Excel
- return last value>0
- Keep peace with your soul.
- How do I link two data validations together?
- xls file format is not valid
- Ahhh
- importing
- Creating a Unique Table
- repeating custom headers on multiple pages
- Downloading Yahoo spreadsheet
- Re: How to "activate" links
- How To Copy MS Word mailing labels into Excel
- RE: How to "activate" links
- How Can I POST a string to a server?
- Repeat columns across worksheets
- Selecting top cell after auto filter procedure
- mail filtered sheet
- move/copy sheet function too small
- Please help
- Selecting top cell after auto filter procedure
- from Excel to MS works ...
- Re: enter in lieu of or in addition to tab
- Re: excel file changes when emailed..
- Calendar default date
- using excel to update data in access
- calculations
- Count occurance of a string across numerous worksheets
- duplicates
- default file locations
- Excel row height units??????
- Formula Protection
- Passwords?/?
- external links problem
- New web query
- Make several charts same size?
- Excel and Access
- Excel - Day of year to date format
- Recognising Text in VBasic
- Linking Values in Worksheets
- Sum, Sum if or if???????
- Automatic naming of ranges
- Screen Resolution
- Default cursor
- Summing qualifying data
- another ques...color /font
- Protecting Sheet- Speel check?
- Cannot share makros with other users - Error Message with personl.xls
- Fiscal Periods
- random variables
- Help! Excel Charts losing formats
- path in title bar
- Changing the default Header & Footer
- formulas
- Saving Files Problem
- summing mulitple lookup values, catchy
- Entering Dates in Excel
- If Stmt; VBA Code; Reference to Cell Value
- Pie Chart
- Displaying Formulas
- Convert minutes to hours and minutes
- percentage
- HIGHLIGHT ROW
- Re: Converting total minutes to hours with minutes
- Trying to create a drop down box
- Excel 2000 File Size Explosion
- Sorting
- First nonblank cell in a row
- Re: Conditional Sum
- Re: Conditional Sum
- Help Needed with password protection
- Single quote problem!
- maximun rows
- Preserve Row Formatting During a Sort
- automatic open of 100's of files-HELP!!!!
- HELP!
- Windows in taskbar
- Filtering Dates in Advance Filter
- long question...
- Scrolling problem
- Reviewing tool bar opens automatical
- women
- Excel DDE Issue
- Vlookup and IF
- excel 2000
- Multiple worksheets print incorrectly in Windows XP
- Excel Problem
- Lost Data
- StAbw in 3D-bars-diagram
- Time Division
- Problem linking to defined names
- MS Access to MS excel
- Pictures (logos) On Buttons + coloured buttons
- Re: formulas
- Matching ranges and formatting problems
- Comparing Lists in Excel
- Creating Watermarks in Excel 2000
- free real estate models to play with
- Excel freezes on exit
- column width changes
- VBA Error
- Excel - calculating NPV of varying cash outflows
- Timezone modifications
- Formula for adjacent row sums?
- Creating Command button on Excel Sheet
- Consolidating Sheets into 1 new one.
- Formula for adjacent row sums?
- Heart Beats since Birth Formula?
- Downloading data into Excel
- data from Excel to Word
- Re: Filtering Dates in Advance Filter
- comments formatting
- Something new
- Compacted and Compressed Data Files in Excell
- Input Message Question
- Can't open multiple spreadsheets simultaneously
- IF Statement calculation
- EXCEL 2000 slow to open workbooks - please help
- Footnote
- Transfering data between sheets
- Deleting rows meeting criteria
- Can't get code to work when exiting cell
- Paste Function box
- Weed out duplicate entries
- Refreshing Data from .txt file causes change outside data range
- Finding invalid links in the worksheet
- Replace active cell
- More on Excel row height units?????
- Vlookup
- columns are numbered????
- Before Print for All Selected sheets.
- Time Formula
- Auto fill with worksheet references
- Including Hyperlinks in Document Exported from Excel to PDF
- How to de-select all items in Pivot tables
- Getting the names of the tab sheets
- Name of a Sheet in a Macro linked to a cell.
- Excel 2002 WMIMPLEX Error
- Word to Excel
- Excel Passwords
- Adding documentation to VBA functions.
- running macros in excel
- Name of the sheet where the formula result is
- Lost stop recording toolbar
- Code to Automatically Enable Macro
- Customized Buttons/Toolbars?
- data validation
- Freeze Panes programmatically, How?
- summing mulitple lookup values revisited, catchy
- VLOOKUP reference
- Re: another summing multiple thing, sorry
- Can web page run an addin?
- Excel/Auto Filter in Procted Sheet
- How to write back a SQL Server table from Excel
- summing more values, catchier
- Need to customize default templates
- Need to customize default templates
- data tables
- Date Format / Pivot Table Grouping
- Sorting with merged Cells
- Print area
208
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.