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...

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

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...

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

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...

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...

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

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

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

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.

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...

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...

-- Thank you

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...

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 a PowerPoint presentation with hyperlinks to Excel workbooks and Word documents. The Word documents work fine, but the Excel workbooks do not open. I...

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...

How can I swich .xls to .doc or.txt??

Using Excel 97 on WINNT (but not for much longer she grinned hopefully!) Evening All, Can anybody help me with the correct character for my problem,...

How do I use the data in a combo-box as a link. I have to create an excel production for a college project and it requires me to create a pricing sheet for a...