I have a couple Microsoft Excel Files (2002, SP3) that when I hit save I get the message "The file 'sample' may have been changed by another user since you...

okay all i am trying to do is create a combo box which holds about 5 people's initials but can also accept someone's initials even if they aren't in the...

I need the following add in so that I can create a sickness/holiday record, however my Office is unregistered so I only have a copied disc. When I put the disc...

Hello my problem is that i have a group of cells that contain 1 2 and 3 letter codes and i need to count them. I want to just use the countif function but...

Can you write functions that will be available for whatever worksheet you happen to open. We have a date format from our AS/400 system and it gives us a...

I have a list of product ID's, problem is, the list has duplicates in it. I would like to have the list reduced so that each product number is listed only...

I would like to be able to search a range of numbers to identify those amounts that total a given amount. There could even be multiple combinations that would...

I have created a worksheet in Excel. It is very basic. I have added drop down lines and things such as that. I am looking to get more in depth. What I want...

I need the data in my combo to be taken from the column headings in my spreadsheet, ie from a row. However i don't seem to be able to do this as it appears...

Ladies and Gentlemen: Why does this formula not work properly? =WORKDAY(A7,5+(MOD(A7,6)(10.5/24))) A7 cell contains a dd/mm/yy hh:mm format Basically if...

I use excel to generate a report with multiple worksheets. What I need to do is have all the worksheet have the same header without having to "setup" each...

Got a problem with opening existing files. They open without error but no cells are visable. Only the grey background. A new workbook will open fine. They...

Okay i am going to try to best explain what i want to do, and ANY help that anyone might have will be AWESOME... Okay I my main worksheet serves as a form for...

While i m login through user login and try to open any old excel file its shawn that file not found and file not open, while i m open a new excel document its...

Hello Gurus and newsgroup users. Your kind assistance please. For some time now I have been using Chip Pearsons code to return a list of file names within a...

Trying again: I created a Pivot Table in an Excel file sent to me by a co-worker. She sends a updated file each month with the same layout, and I use the...

does anyone know how to set up excel in the way tat it will remember wat u hv keyed n will appear next time u type in th key word.. e.g type once singapore.....

I am trying to put a text background on a worksheet. How do I do this?

I'm comparing 2 values by saying =c1=c2 and it gives me a result of 1 or 0 instead of true or false. How did this happen? tia, Dave

Hello, I have 5 workbooks, each with one sheet, that contain purchasing information. The 5 workbooks are not in the same format since each type of purchase...