I have an excel spreadsheet / template that was used by my ex CFO. I have the password, but I cannot get into the protection button as it is grayed out. The...

Just add the other criteria to the formula =SUMPRODUCT(--NOT(ISERR(SEARCH("*gun*",L1:L5)))*1) to count gun in...

got an error message "cannot shift non blank cells" what is causing this problem?

I am trying to create a pivot table that summarizes different overhead categories and then reports each categories' ratio compared to revenue (i.e. overhead...

Hi all I have a long column of cells that have the same data validation lists applied to them. At the top of the list is an auto filter. However when I go to...

How do I print just a list of the formulas that I used in a document? I know how to make them show on the screen and print them, but remember that years ago I...

I am trying to save an Excel spreadsheet as a .csv (comma delimited) file. The problem is that whenever you open the .csv file, you find that on some of the...

Looking to export a Bill of Material (BOM) to excel and keep the tasks hierarchy indexed i.e. xxxxx-xxxxx-011 instl xxxxx-xxxxx-041 assy xxxxx-xxxxx-101...

I am attempting to take a basic number, say 2000, and convert the number into an hour and minute format (i.e. 33:33) only. Everytime I use the custom format...

Hi, I am very new to this forum. I have two queries: 1. I have got data in various columns in a work sheet. Each column contains data from a table(outside...

In VBA under the ThisWorkbook I was recently instructed that I could write the following so that when a file was opened macros would automatically run: Public...

Hi, I am very new to this forum. I have two queries: 1. I have got data in various columns in a work sheet. Each column contains data from a table(outside...

When I d-click (open) and excel document 2 windows automatically open and are labled Title.xls:1 and Title.xls:2. When I close one window both close. When I...

Does anyone know how to do the above? Many thanks Anita

Hello, I would like to know if a function, such as describe below, exists in Excel. I would like to recuperate in another cell the address of cell (e.g. B23)...

I have developed forms in Excel 2002 to capture data at schools level and save to an Excel workbook database using TMPLWIZ.EXE wizard. We then use pivot tables...

I designed several charts and graphs for a monthly executive report. There are several pivot tables and graphs based on a single worksheet of imported data....

Thanks in advance for any help you guys can provide. I'm currently trying to send out information using the Excel - Mail To - Mail Recipient(as attachment) in...

I have a spreadsheet where the rows in Column A are descriptions and Columns B thru H are Mon thru Fri. As you arrow down entering dollar amounts by day for...

Cell A1 has a text string (sentence). I want to check the long string in cell A1 to see if it contains the any one of the different single strings in cells...