View Full Version : Microsoft Excel Misc
- Print scrollable user form.
- Autofit Row Height of Merged Cells
- Using the IF function
- Sum if contains dependent
- auto deleting defined rows
- Transfer Info From Worksheets
- If statement help
- Slow opening directory structure in Excel 2002
- What driver to use to filter a datbase (.txt) on Notepad?
- Blank file is 316k. Why
- A cell contains "1,2,3"; and I want to count those sep. by comma
- Personal Macro Workboos
- Looping until empty column
- Excel 5
- Excel 5 data points
- Password Protection
- De-duplicating
- Bell Curve
- I wish to enter pounds shillings and pence in sterling
- How do I make gridlines permanent?
- #DIV/0
- Pivot Table Report formatting - can't select Data Source Order
- Copy Range of Cells in Same Row
- MSQuery won't show columns
- SUMIF with Mutiple Ranges & Criteria
- Where are my partially missing grid lines?
- where are my missing gridlines
- How to have formulas and formats auto copy to new inserted rows
- #Value
- Export from Oracle into Excel, "Open" is not an option in XP
- HIDE-IF???
- If 1 cell changes, update another cell
- split cells
- Can I use an animated graphic in Excel 2002?
- Help with INDIRECT()
- ASCII to Numeric Conversion
- Pivot Table Sorting
- Strange Personal Macro Workbook Behavior
- I need a Macro
- How to link trendline equation in graph to cell?
- Trace Precedents and Dependents Arrows are Invisible
- schedule checker
- importing data from access
- Creating a macros to copy and paste cells
- how to remove hard returns, which show as little boxes
- how do i create a running balance on checkbook register
- Shared Workbook?
- if then formulas
- Move equations from line to line automatically
- subtotals copying
- Workbook for entering POs and matching and paying invoices
- Copying Text from Access to Excel - Data Lost
- Formula for calculating price
- Getting NTFS file attributes
- sum of characters
- How do I create an alert of expiration date in Excel?
- Input message on data validation field
- Transposing addresses
- THIS IS A GREAT SITE! THANK YOU!!!!
- Changing File Icon
- Excel through Sharepoint 2003 problem
- Need help with equation
- Counting values and comparing them to a single cell
- how do I insert a pop up in a cell?
- searches slow on some computers fast on others?
- VB Assigning Values to a Series of Strings
- macro
- sort columns within a merged cell header
- opening workbooks on startup
- How do I insert a prompt into an Excel macro?
- Excel Option Conflicts
- Can you automatically insert next sequential number in an excel fo
- importing list with commas from WORD, to individual .xls cells?
- searching in an array
- Display Text in the Data Area of a Pivot Table
- GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE
- [Fwd: Run macro on exit worksheet/workbook]
- Calculate discounts within a pricelist
- Negative numbers
- How do I ask Excel to count how many items are in BOLD TYPE?
- how to type a text vertically in a excell cell
- Delete Blank Lines
- sheet with expiration dates
- Combining 2 pivot tables
- Same Question with one more addition of a dash to count
- Need Vlookup to work with formula in reference cell
- Password encryption
- Compiling data from a particular location in similar workboooks
- Help linking workbooks
- how to put data in the column A to the next row of the column B
- Sorting by Date (With a Twist)
- ADDRESS function
- cell input on certian dates!!
- Cells User Select Locked after upgrade to Excel 2002
- Arrow Keys in Excel
- Do dropdown lists have an autocomplete function?
- OT: Recipes
- Macro/Formula Help?
- Backup Spreadsheet while open
- Renaming Defined Name
- New To Pivot Table
- mirrored array/matrix
- Encryption Types
- date problem in excel
- Excel updating from XML file - file path specific?
- integrity problems while copying
- Cell Reference help required
- how to insert page numbers
- Inserting extra info into a cell
- Use a text box to calculate and show results in a user form
- Validation list
- Tab down instead of right in protected cells
- Auto updates - Clock
- Excel Option Conflicts
- Pasting data without the worksheet automatically delimiting it?
- Frozen Pane Lines
- How to assign a score, dependant on a sum falling within a range?
- Filtering out text with conditional formatting
- Calculating intertest
- Book.Xlt v Book.xls ????
- hyperlinks in a spreadsheet keep breaking - any thoughts ?
- Excel Charting problem..
- How to ..
- How do I copy a date from excel to a outlook calender?
- Autofilter on protected work book?
- How to get cell references
- fonction SI + max dans la meme cellule
- use IF to return a truly blank cell
- COMPARE DATA AND LIST SMALLEST AND LARGEST ENTRY BY UNIT
- Monitoring Data
- Look Up help please
- set up a continuing roster?
- Question regarding scrolling
- correcting wind direction data
- counting from left to right and stopping when blank
- how do i re-size circles in venn diagram?
- gridlines print over text
- IF statements
- Can't Clear Print Area
- Formula to find first, second, third etc. value (range)
- Importing data from Excel to Outlook
- ODBC and ccolumns
- Cell searching and Replacing
- Show cells have been read - linked
- How do i identify missing numbers in a sequential list
- form to enter Silent Auction data?
- Saving Excel 2003 file in .txt format
- Changing the font size of a drop-down box content
- month & year format in two digits
- Formula Help "Let me know if I do not make sence".
- MS Office VBA Automation Specialist
- Excel currency conversion
- Excel link to data in other worksheet only refreshes one column
- Comment flashes (blinks)
- Cell is too small?
- CSV File - Leading Zeros
- SAVE AS ONLINE EXCEL
- "A valid number is required"
- Which loop to use
- Copy/Paste a protected cell
- words
- Preventing other users saving another version of protected workboo
- Digital Signatures
- Excel writes "May 10" when I input "5-10". How to stop this?
- Need to khow how to personnalise desktop icons with my own pics
- Get External Data Macro
- Turn off Reviewing options at the application level
- Hyperlink from MSProject to Excel?
- How do you get a full useful webpage in Excel?
- pivot tables?
- Re: pivot tables?
- Using named variables
- formula for countif between 2 dates
- Maintaining cell references when inserting cells elsewhere
- Problem with linked Excel table in a word Document
- Excel 2003 doesn't filter correctly
- Why do I have to enter the cell (F2) for cell to calculate?
- Can you use alias' for 'groups' in pivot tables ?
- Maintaining Row Number
- How can I place a condition on a list?
- How do I get MAX, MAX -1, MAX -2
- Start up
- copy and paste very slow
- I have text in an Excel Cell that isn't showing all of it?
- Interesting Counting Question...HELP
- Resizing row height to dynamically fit height of text box
- Seperate Cell Information (lastname, firstname)
- how do I add information from many worksheets to one main workshee
- How do I disable border double-click navigation in Excel?
- VB Corrupting Pivot Tables
- Can A Spreadsheet Get Any Wider?
- Re: Can A Spreadsheet Get Any Wider?
- How to skip cells with text strings.
- Re: Can A Spreadsheet Get Any Wider?
- Office Assistant Message
- Month Formula
- Help: I need a macro to add words every 3 lines
- Auto Fill & Replace
- Using worksheet names in formulas
- For Each Loop with Pivot Table
- How to get Excel to stop formatting time cells incorrectly
- Renaming Defined Name
- Microsoft Access database
- My Excel menu bar has dissapeared
- IF Formula
- Help:macro to auto sort data to different worksheets...
- Pasting Into new sheet
- compare worksheets data
- Line Automation
- XML maps in a XLS file - not refreshing
- black background with white spots in the texture
- Active Cell displayed in another cell?
- Convert VLOOKUP to absolute cell reference
- How to change date when printing several days attendance
- Worksheet form design
- Using scrolling textbox on wks for keeping notes
- Need Help with a Formula
- birthdays - determining when due
- Converting to an efficient set of tables
- I want the tabs to run down the side of the screen
- automatic entering Balance at every entry in my bank account
- how can i find a specific date of a database
- update a link to a CSV
- How do I...
- My Problem Is This..........
- Multi user
- multi user
- Excel keeps wrapping cells with text incl. alt/enter
- Cell contents with custom time format rounded after double-click
- Pivot Table Subtotals/Variance Analysis
- Automatic Toolbars
- how do i create web pages from excel file?
- fixing problem with my tab
- Task Pane - Excel 2003
- How to hyperlink to a graphic?
- List box to Text Box
- Zeros and csv files
- How do I merge 3 lines of text to show in one row?
- jpg Image Altered when emailed to recipient.
- Assign commands to function keys
- Importing data from palm excel to desktop workbook
- clicker that advances one number per click in a cell
- Boders Colors
- building website
- Sort text Values in Numeric Order
- Problem calculating Days/Hours etc between 2 dates
- selecting a formula to?
- excel changes
- filter errors depending on number of incidents
- "Print Report" in Exell 2003
- Document not saved
- Is Excel reliable
- Import NMEA data to excel?
- Sorting numbers with brackets
- How to restore right click functionality for copy and paste?
- Changing Row Numbers
- Send a document image to Excel
- how do I get this done
- Stop Insert Row modifying formula data
- Enable a new dimention: sub-level of split cells
- Enable concatenation of a range
- formula help
- Improvements for text finding functions
- A function that returns the name of the current cell
- dragging a formula
- Text Only Default Behavior?
- Multiple lookup
- emailing pdf
- How can i put a negative sign on a range of selected cells?
- Fill Handle Across Columns
- need to convert paper document back to excel.
- Moving from cell to cell
- How do I enable autofilter on a protected shared workbook?
- Using Find in a macro
- Lost all my menu bars and tool bars
- Pivot table keeps dupping to another linked pivot table
- I get a 0 value when a formula is copied to another cell
- New column based on row cell format
- seperating dates & values
- PIVOT TABLE
- Can't open files from outside Excel
- formula for a column
- "custom Views", column widths not changing
- Running a macro for all visible worksheets in a workbook
- Error 1706. No valid source could be found for the product Microso
- Using today formula for a template
- Strange autofilter problem
- toggle button text color
- install excel addins but looking for wrong drive
- countif function hassle
- File in C drive is always trying to access Drive A
- List boxes, drop down
- Using formula values
- Entries disappear after inputting data
- Excel Slow after upgrade
- biography outline
- changing formulas to values so that they will be recognized by Find and Replace
- odd formula help
- Cant see highlighting unless I go into print preview
- Copy Blocks Of Data
- Paste Link Function
- Not all pasted text appears in cells
- how do I set my tab to stop at column N and rtn to A
- Rounding Numbers
- What is the best program for production reporting
- How can I change the color of the drop down arrow on a filter?
- delete data, keep formulas
- Deleting Rows using Macros
- File size -
- Re: How do you use DTpicker in a Userfrom
- Printing Multiple Worksheets
- Undo
- copying matched data, sort of
- Macro Total Sum
- No Password Dialog
- unprotecting a worksheet
- Formula Mass Copy???
- Can I modify the NCAA bracket with tracker template for a 3 state.
- moving right instead of down after editing a cell
- Formula Help Please
- Negative Values Only
- Printing Labels
- Calculate % variance on previous quarters. Quarter %, etc. pivot
- Pivot table pulling wrong value
- How do I say…
- Can someone help with a formula to calculate dates?
- Count comma separated numbers, numbers in a range with dash, not t
- the owner of posting should be able to delete the posting
- creating a macro for a "Save As" box
- How to sent for cell: font size=7,text format in VBA
- FILL IN BLANK CELLS
- Linking customer number format to a cell
- Should be Simple
- Merging cells with the same values
- Copy tabs(sheets) from workbook without link to original source
- What will cause column headings to change from letter to number?
- How do you calculate persentages and formulas
- Object not availble onthis machine.
- double a value & ROUND to next highest thousand
- How to set up my EXCEL so it takes me to most frequently used directory?
- Check box help please!
- How can I ensure #records in a selected set always shows in Excel
- Can I print one page landscape and the next page portrait on same.
- Writing a Marco
- ddd format to 'text' field
- Pasting Subtotal Results
- How do I permute the cells of a column
- i want to print using both sides of A4 sheet
- Adding multiple workbooks together
- How do I organize worksheets under subheadings?
- Delete contents of unlocked cells in another worksheet
- How do I add the number of variables?
- Replace null string with blank cell
- Create a tabular control
- Linking cells
- Help - Is it possible Formula
- To learn about VBA
- Ran out of columns???
- Using a pivot to calculate an average w/o 0's
- how do i cross frozen titles without unfreezing
- Formulas
- How do I retrieve data deleted from a worksheet?
- help with filters needed please
- Cell linked to a range of cell values in different sheet
- How do I copy/paste subtotals without all the extra data?
- How do i create an interactive flowchart
- Sharing Macros
- Cursor keys moving page???
- Attaching of Multiple Links
- how can I extend number of columns in excel
- XML Mapping Issues
- number formatting
- Formula help
- Formula too long
- Using external data with differing formats in a spreadsheet
- help with this
- AddIn not working right
- Showing zero balances
- sum between workshhets
- Excel 2003 Pivot tables - how to "show pages"
- Calendar/Dates Help
- Function Pitfalls in Celll Formatting
- Increment numbers in a column
- Excel worksheet display ####
- Pivot Table, can't group
- Can I rate a cell 1-5 and colour code it?
- Pivot Table Page Field Area Broken
- shortcut to a function?
- IF statements
- Shading Locked Cells
- show zero if the velue is in -
- SUMIF with two criteria
- Time displaying wrongly
- Excel will not change cell border colours
- Exporting .xls sheet
- Indian Number Format - Enabling the calculation
- Dropdown menu auto recognition?
- Pivot Table Report Parameters to be named and saved like 'View' na
- save .csv file to .sdf file
- loop over columns
- Need help with this problem
- object variable or with block variable not set
- Copy & Paste
- Filtering within Pivot Tables
- Excel 2003 locks up after startup
- Error in Addition and Subtraction
- excel closes when linking worksheets and using rollerball
- combo box
- Encrypting Sensitive Data in Excel
- Pivot Table Help
- How do I encrypt Social Security Numbers in Excel worksheet?
- VBA code to locate cell address of AutoFilter dropdown box
- What is the VBA code to delete a sheet without warning message?
- Count rows with specific date
- Checking FileName
- In Excel, how do I work in inches, not centimetres?
- Copy Sheet and move to end
- Excel cannot be saved to flash disk
- Date Formula Help
- vlookup, what am I doing wrong?
- spreadsheet gridlines as graph paper
- Columns
- formula to calculate a benefit amount
- Help, Please
- zero value when copying cells between worksheets
- Zip codes are not formatting
- inserting rows
- Excel 2000 and Excel 2003
- Checking if sheet is visible
- find and replace path name in Excel cells containing hyperlink
- Removing lines and/or borders
- Cursor position
- What does the "$" symbol do to a cell value in a formula.
- What does the "$" symbol do to a cell value in a formula.
- Using Replace to Format Negative Numbers
- I have an employee who is having problems accessing her documents
- IF Stmt. to calculate cumulative commissions
- How do i add " to the beginning of all cells
- ... Count Function ... with any character ...
- Formula Needed for Transit Time
- share a workbook but protect the formulas
- How to Join/concatenate a date field with a time field in Excel?
- Excel OLE objects crashing in other Office applications
- Column Drag Down
- Creating a race submition form
- add txf format to excel formats
- combine two files
- Can I link a name in excell to contact information from outlook?
- Why has my cell text been replaced by # characters?
- Divide One Amount for Duplicates
- Paste Subtotals Only
- Cell/text formatting
- Settings
- Very basic question - how long can a list be?
- Another combine two files question....
- Menu Bar
- Need better understanding of TRIM so I can get rid of trailing spa
- How can I do this?
- lose formatting when emailing worksheet
- In excel, how to put a linebreak in text in a cell
- Excel 2003 slow to respond
- Excel 2003 slow to respond
- Printing Multiple sheets on ONE?
- help with header row format
- Where is my List Toolbar?
- Spreadsheet where categories at side don't move out of view?
- inserting a formula
- Email Macro with Outlook Express
- A little more help
- Toobar question - how 2 get other user to see same toolbar
- splitting fields
- Creating toolbars thru VBA
- Macro - Find a value and then move down
- HTML Format of Comments Indicator
- clicking .XLS file opens Excel 2003 but doesn't find the file
- FORMULA USING MASTER QTY
- Unable to empty clipboard error
- working with data between worksheets
- How can i copy a group of cells in a row to a column?
- Conditional Formatting And Countif
- Active Filtering
- Important information on 2 sheets, combine?
- How to refer to current column in a formula?
- How Can I Stop A Help Task Pane From Opening
- How to delete file
- actual time and date
- 16 digit numbers
- Conditional Formatting & Dates?
- how to open 1-2-3 files with excel
- Unique Number
- Unique Number
- Conditional Formatting and Subtotals
- Conditional formatting
- Delete row 'if'
- Copy Name and email address from web sites to excel sheet
- Printing Borders Problem
- use of F3 & F9 keys
- inserting rows at common word in a sheet
- count no of worksheet
- Calculating Selected Cells
- Invalid Qualifier Problem
- more than 3 conditions in conditional formatting - possible?
- Split Cell into the cell
- Formula to find the working days difference between to dates?
- HTML email
- How to get started with VBA and macros?
- SUMIF vs COUNTIF
- Values for Graph
- really need help plz
- Need Converter for Quatro Pro (.WB3) File
- Exporting fields from access to excel
- automating an array
- Multiple matches using LOOKUP
- Median function
- what is maximum row length in excel
- IF Stmt. for cumulative commissions.
- Re: Can you FTP a file/data directly into Excel
- Conditional Formatting Question - Different Cell Colors??
- Accessing named ranges in Excel from VBA
- Temp files in Excel
- can i use excel to generate web links
- Dollar text
- run macro on return
- Using a drop down list -- Autojump to first letter
- why does excel create multiple copies (as many as 18) of a file?
- Date to Words
- Divergent units in formulas
- Area Chart need to move y axes data on the other side
- Drop Box
- Text values to numeric values
- Prevent new pivot table items from being selected
- How to use mutiple spreadsheets in a pivot table?
- Is there NOT a "make negative" function? and if not WHY???????
- navigation between worksheets
- Excel - Autom. Filter "Empty / Non Empty cells" should come first
- New book from sheet
- Help me
- UserForm
- Sorting by Fill Colour
- how do i find duplicated files?
- This is crazy!!!
- sum total hours and minutes
- Print errors with Word documents in Excel spreadsheets
- MS Excel 2000 Cell Capacity and Data Display
- How do I merge similar data across different excel worksheets?
- How do I change headers for all worksheets in a workbook?
- Select Range of Cells
- Display form from an VB application in Excel
- Hiding Code
- Using value from 2 tables to fill a cell
- template for quotations in excel
- If CONTAINS
- User Form in VB = TextBox
- How do I Calculate Percentages for each number in a column?
- AutoSave
- Find a value in a workbook and return the worksheet name
- how do I change cell background color only when cursor is over it
- SQL Server Link from Excel
- can a cell remind you of an upcoming bill date payment
- Excel & birthdays
- having a set $ amount be deducted from any given total
- formula
- Trouble accessing a couple of established Excel 97 files
- find last cell in column - without VBA
- Look Up and Display set data
- Countif Multiple Criteria
- hyperlink
- Insert a number of rows based on a value in a cell on active row
- Excel Template
- Converting Quatro Pro to Excel
- hyperlink
- can't Link from web page to specific location in Excel
- Nested vlookup
- Can I limit a cell to 2 characters?
- can I create a new resume?
- Copy Problem
- Double Counting in Pivot Tables
- Mailing labels with Excel
- vlookup with validation table
- Formulas in a cell
- how to combine several columns into a single column
- Automatic calculation reverting to manual depending upon who opens
- Entering a 16 digit number
- Using Audit Tools with Worksheet Protection
- How do I get the data/xml/export option
- circular error w/o cell reference
- automate hyperlink
- Vlookup - name of file to get info from is in Column A
- Favourites button - File Open dialog box
- Sumproduct function
- Function Rounding
- Macro insert lines
- automating an array?
- split a column
- Calculating across worksheets
- Calculate y-values in chart?
- Chart items moving around
- Adding Percentages
- Additional file with no extension created during File Save As proc
- reminder system for various tasks in excel
- sum of many cells
- how do i display 10,000,000.00 as 1,00,00,000.00
- display 10,000,000.00 as 1,00,00,000.00
- pasting values
- Line chart for every 5th cell in a row
- Macro to copy cells
- inserting rows
- hide worksheet
- Subscript out of range ... sometimes! (Same code unpredictable re
- alternate UI for Define Names ??
- is it possible to print file properties in excel?
- How do I unlock FILE access?
- How to CANCEL file SAVE PROMPT when MACRO is running?
- Formula retrieves wrong data
- Using version control in Excel 2003
- Re: How to CANCEL file SAVE PROMPT when MACRO is running?
- Hyperlink added to an activex control button
- Automatic Sum by Category (SumIf extension)
- Qurey Excel database?
- Help for a newbie trying to add hours and minutes :)
- insert path into excel footer office 2000
- seprating words from numbers
- vlookup limitation
- filter
- Header and Footer
- workbook_change
- Copying data from another cell, I think there are macros
- how to insert a permanent + sign??
- I should be able to print Excel an entire workbook doublesided
- Workspace Question - Thanks In advance!
- Office XP: Excel only opens in one window.
- macro for invoice totals
- Pivot Table Calculated Item
- Headings
- cursor moves too fast while shading text in columns
- Help, my columns now have numbers instead of letters.
- Selecetive replication of forumlas
- How do I average a column without including zeros
- Blank cells in line charts
- error message: Too many different cell formats.
- Can i recover my excel file after saving with new data?
- "save as" Tip - help
- formulae problems:HELP
- Spreadsheet Sorts When Saved
- Inifinity value? URGENT!
- When opening Excel file box does not open at biginning of list
- matrixed table out of pivot
- Calculate max value in specific range
- List folders to file
- Countif
- Barcode Formulas
- Possibly conditional format
- Can someone please help me
- zero in front of a number
- Printing
- Calling an Add-In
- help!
- vlookup
- Goto in IF statment
- Cell Formating
- automatically drop data to next line
- Adding numbers...
- Live data in Excel
- html
- Import scanned numbers into excel
- Pivot table
- Linked Data within workbook
- A1+B(C1)
- How workbooks link to other workbooks
- problems using functions in excel 97
- ISBN Check Digits
- Can I format an entire row based on the value of a single cell?
- sumif remove high/low values
- How protect with password the access of a spreadsheet ?
- Assigning text values to numeric fields
- Excel Formula - Compute Number of Years Worked
- How do I turn the Macro Stop Recording Toolbar on and off?
- How do you calculate payroll with tips?
- Sorting by colors
- Auto Adjusting Text Box
- Report from data
- Picture is not viewable
- Excel Duplicating Workbooks
- How can i calculate only once?
- subtracting a constant number to all cells in the same column
- I have lost my HELP file.
- How do I change a cell range with a reference cell?
- How I can print full text bigger than column, in repeat column
- excel opens slow
- Alphabetize Pivot Table
- Re: I can not move or scroll to the top rows (7 to 1)
- Where do I start
- How do you keep Excel currency formatting during a mail merge?
- Can I Count dates without repeating?
- math
- How do I remove the auto border from my printed pages in Excel
- Summing Alternate Rows
- hiding forms button
- adding 3 entries per month
- Can't copy an Excel worksheet
- Sum with two conditions
- changing word files to excel files
- need help with Special font
- Spreadsheets are overwriting each other
- Excel File Types
- Need help w/ formula
- Excel Chart Template Location
- how do I turn rows into columns
- Auto Filter Macro
- Inserting line breaks into merged text cells.
- import data to specific columns
- count function in pivot table
- How do you tab in a cell?
- Linking changing data
- Superscript Button and Subscript Button
- Finding Formatted Cells
- Can this be done............??
- countif function with multiple criteria
- match to colums vlookup
- Information Systems Manager
- creating mailing labesl
- combined two countif functions
- Importing an address file (that was pasted into a Word doc) into E
- Re: Information Systems Manager
- Layout in Excel
- Counting multiple variables returns #VALUE
- Convert Formulas to Values and Preserve Formatting
- Suggestion on this one?
- Run a macro to copy selective items
- cell will not center
- Freezing panes, phantom line
- Edit Drop down box
- Is there a way to sort text by frequency within Excel?
- Name file automatically
- How to create a routine
- Splitting Data in a cell, left or right of a separator.
- copying rows where a result cell has a certain value or higher
- addon to equation
- Conditional formatting blank cells
- Formula Refreshing
- Trying to open file, may have renamed it
- aNOTHer troublesome equation
- Pie Chart display
- "how can i format all the comments in a worksheet together?"
- Application to turn a table layout webpage back into a spreadsheet?
- Is there a formula, function or macro that accounts for shading of a cell or row?
- Inserting header @ page break
- Preventing deletion.
- Percentage doesn't add up
- Excel backend for IIS
250
vBulletin v3.0.5, Copyright ©2000-2010, Jelsoft Enterprises Ltd.