I want to know if you can have the entry cell autocomplete when it has a drop down bx. Is this possible? Thanks, Vato --- Message posted from...

I am experiencing something strange. I often have to VLOOKUP on worksheets containing around 10 000 rows. VLOOKUP work well but after that, when I try to do a...

Is it possible to have a cell, let's say row 1 column Q to reflect the last cell of column R. Example: Column R row 5 on day 1 is 35, then on day 2 row 6 is...

I have a three files that i export to regularly, the columns and titles are always exactly the same but the actual data in them changes each time I export. ...

Is it possible to filter a list based on a cell value? What I want to do is for the user to type in a criteria in cell F1 and G1 (Dept and Acct No's) and...

Everytime I try and load an xls file I get the message: "Class not registered. Looking for object with CLSID:{AC9F90-E877-11CE-9F68- 00AA00574A4F}" Excel will...

I am trying to label my bank info that I import into Excel. I have a column with the charge amount and a column with the recipient. I think a lookup table...

Hi Fred, Try this Private Sub Worksheet_Change(ByVal Target As Range) Dim cNextRow As Long On Error GoTo ws_exit: Application.EnableEvents = False If Not...

I have created a spreadsheet file using Sphygmic software. My accountant has asked that I send this file in excel format so my tax return can be filed...

I am trying to open a spreadsheet someone sent to me, I did not create it. When I open an Excel spreadsheet in Office 2003, at the bottom left side it says...

In all my spreadsheets, my arrow keys don't tab over to the next cell - it's like I'm pressing page up or page down, instead of over... Any ideas?

I have created a template that has combo boxes and radio buttons on most rows. When I try and delete the bottom row, the row deletes, but the combo and radio...

I want to download some data from the web which is in a simple table format (7 columns x 50 rows). I use MS Web Query to do this. Is there anyway that I can...

Hi, I need the new table to fill in automatically from the another table. A B C 1 FRUIT COLOR AMOUNT 2 apple green 100 3 apple green ...

I'm currently sitting with a predicament, because I received a rounding procedure which excel doesn't cater for. The reports require a rounding procedure that...

Once again, I have data that I have exported from Excel. The data is answers to a questionnaire with 27 questions. The answers have number values and...

Hi, Does anyone know what the maximum file size for a excell 2000 workbook is? I'm currently upto 38mb, just need to know how much further I can go. Lots of...

Let me first built a senario. A B C 1 mathew 65 .......... 2 Moses 94 ...

Hello, I have created a spreadsheet for a number of users to access. I would like the spreadsheet to open on a particular worksheet every time no matter where...

any one can help me how to make the cell automatically take from the time of the computer... because i am using the timesheet tha can download from office...