General

Lookup Function
I am having massive amounts of trouble with the =Lookup function. Here is the formula that I'm using =LOOKUP(A1,B1:B20,C1:C20) The formula should find A1 within B1:B20, and then reference the the cell just below it. So, A1=JJ and B13=JJ and C13=13. C20=20, and the Lookup function keeps giving me 20! All ... 2 Jul 2008 19:07

Hiding Tabs
Below is the code I've been using to hide or show a row based if "yes" or "no" is selected in a validation box. This has been working. Now I would like to also hide a Tab if "no" is selected. How can I had a tab in addition to a row? Thanks! Private Sub Worksheet_Change(ByVal Target As Excel.Range) ... 7 Jul 2008 16:38

Excel Formula's / Programming
I have created a mileage log in Excel 2003. I have also added a dropdown box where the user can select whether the mileage is used on a "personal" or "business" basis. i.e. Odometer Reading Select Purpose Start Finish Mileage Person... 2 Jul 2008 22:11

Can i stop people from deleting my excel file
Hi, I have an excle file that should not be deleted by anyone.Is there a way i can protect it.If yes please advice immediately Regards, Sheriff ... 2 Jul 2008 20:09

generating consecutive sheets with macros
hi again, i hope someone have the time and patience to listen to my problem and help resolve it. in our business we give up to 30 quotations per day of which on average 6 gets accepted. as soon as the quote is accepted, a series of consecutive documents (all related to the original quote and its contents) need... 2 Jul 2008 18:05

counting two different values
I have a worksheet where I track who processed documents among other things. Normally they enter their ititials on the worksheet and I can count how many of each ititial is in that column. If two people work on one document, they may enter their initials JD/PD or PD/JD for example. I want to count how many t... 2 Jul 2008 18:05

Merge two lists to get one with unique records
I haven't been able to figure this one out but a co-worker needs to have a unique list generated by two lists. We are using Excel 2003. 1) she has two lists. for example: First List Second List Combined List Harry Brown * Harry Brown Harry Brown * Ben ... 2 Jul 2008 17:03

Compare two columns
I am wanting to compare column A with B - and if they match then put a yes in column c. The formula I am using isn't working - Please help! =IF(ISNA(MATCH(A2,B$2:B$22)),"yes","") For example: A B 1.00 1.00 2.00 6.00 3.00 2.00 4.00 4.00 5.00 3.00 6.00 1.00 8.00 10.00 10.00 9.00 9.00... 3 Jul 2008 17:40

Recording Macro to auto-fill
On "Sheet 1" I have created a drop down menu which looks up the values on Sheet 2. I presently have 4 columns which relate to the column before them and I need to create a macro I am assuming to change the last 3 columns to N/A if the 1st column is N/A. Please Help!!! ... 2 Jul 2008 19:07

Macro to convert some columns to rows
Hi, I would like to build a macro to convert a table from rows to columns. The initial spreadsheet is set up so that each row represent one piece of information for the same ID. For each ID there are 5 rows A B C ID1 Name Smith ID1 Address ... 3 Jul 2008 10:27