Hi, I have a database with over 14400 lines of info that I need to delete the apostrophe before the value, to make it a value, how do I do this? -- Message...

AYE! my head... i'm sure it is simple, but i cannot get the SUM cells to show the currency amount. instead, the cells keep showing ####### after i enter the...

I have 10+ employees, I would like to have a roster to assign each employee to work equal weekends over a 12 months and produce a printout.

Let me try to explain what I'm trying to do... Lets says cell C3 will be "value A" if A1=84, "value B" if A1=72 "value c" if A1=60 or "value d" if A1=48....

We have an online storefront. Our products are all in an excel spreadsheet, arranged by part number. I have about 30,000 images of products. I only want to...

How to you get one cell in a workbook to equal another cell in a completely different workbook?

I just overwrote a very important list. I had to many files open at one time

The file dowloads as a .cab file. When I try and open it, it's not in a recognized format. How can I download the correct format.

I have a spreadsheet with a web data import query that is set to automatically refresh every 30 minutes. Whenever I open the spreadsheet, I get a dialog box...

Can you graph both a line graph and a bar graph on the same graph? Chris

In my shared excel file, users will be adding information to the first free row at the bottom of a list. I want to be able to freeze the top 5-6 "header" rows...

=SUMIF(msdatabase,Container,CurrTotalQTY) My answer is not including the first row in the database range that matches this criteria. It seems this is...

Something easily manipulated to make charts of activities. Tracking something for a campaign. Thanks, Liz

how do i combine two cells in two rows into one cell without losing data for example A1 information here needs A2 to be combined with information here

How do I write a macro to SaveAs? I want it to save the file as the same filename it already has, but to put it in a different folder. Any help?

Hi All, I have some header rows in a worksheet that are preventing a formula from working. The formula is: =SUMPRODUCT(--(MONTH('Income...

How can I insert measurements in feet and inches and still be able to use "sum" and "sort" options? I can insert them so that I know what they mean, but...

I have an application that reads data from spreadsheets based upon named ranges. I have a customer that has ported the application over to French Windows and...

I need a mortgage amortization schedule that also allows me to put in my escrow, (i.e. taxes, insurance) for yearly tracking. I would like it to allow me to...

Here's the situation: I have a worksheet that will have an "X" in either cell F3 or G3 or H3. What I would like to do (via a macro), is to examine F3, G3 and...