Hi, Col A has dates in order Col B has amounts Cell D1 is the beginning date Cell E1 is the end date I want to sum Col B where the dates in ColA are...

I have a PowerPoint presentation with hyperlinks to Excel workbooks and Word documents. The Word documents work fine, but the Excel workbooks do not open. I...

I continue to have problems when attempting to do a numbers descending sort, from a position where the data is in rows. No trouble with other sorts of this...

I have worked out how to remove a hyperlink from a single cell, but how do you remove them from complete columns, as I have 80,000 to...

-- Thank you

I've created a spreadsheet to keep track of some work. Throughout each month new entries are added as needed by inserting rows and columns. I also use the Fill...

Hi, I have a big excel workbook . Therefore, when I save or open it , it takes about 5 minutes. Please show me how I can make my workbook smaller in size so...

Is it possible to have row A numbered from 1 to 100, and if one of the numbers is removed the count will automatically change? i.e. 1 2 3 4 etc.

i would like to create calendar drop down list in Excel. Is it possible to import it or link a sell to a calendar?

Guys, i've been trying to install solver adds-in but I've had no luck

I was given the link but the site doesn't seem to be working. Thanks Marc

The data is a list of people, the projects they are working on, the completion date, who they work for, their skill set, etc. My manager wants this data...

Hi, I have two spreadsheets, A and B, that have the same format. I would like to: After I insert new rows in sheetA, It will be automatic insert new rows in...

I want to know why we really need micro and how it is helpfull

I have worksheet which contains an SQL query (which runs fine) I've written a looping macro to go through a range of cells and for each one copy a template...

What function can I use/make to figure the difference in percentage between 2 monetary amounts?

Hi, I left one requirement out for my original request. I'm storing dates in cells in a column that represent future deadline dates. If today's date...

How can I pre format all Excel comments to Tahoma, font size 12, in BOLD, in all workbooks and worksheets as my default.

I was e-mailed a worksheet which contains some (to me) unusual features. It covers cells A1 to M25. The rest of the worksheet is blank - by which I mean...