Hi, I have a table as per the appended below table. Now I want to forecast what I am going to be doing on sales rate for the 10th of May or for a later date...

Older versions of Excel used to have a nice mortgage calculator. It was obviously a macro that allowed one to enter data like the principal, interest rate,...

MIN and MAX return the value. I would like to return the cell reference containing that value. For example MAX(B2:CH555) returns 7580. I would like it to...

How can I prevent the workbook that stores my macros from opening each time I open a workbook? When I open a saved workbook I have to click the windows icon...

I need to format a series of numbers that are of different length’s to have leading zero’s to be 7 digits. I need these to be able to be merged with 2...

I need to format a series of numbers that are of different length’s to have leading zero’s to be 7 digits. I need these to be able to be merged with 2...

I would like a formula that returns the three highest categories within a list. I think an example would be best: A B 1 Animal ...

Here is a lookup formula I made for the user to enter a unique four digit # into a spreadsheet (D2) and have correlating data returned (don't worry, I made a...

Hi Guys I have a spreadsheet with 8 columns of data and multiple rows For each row I want to sum the 7 highest values in the range of 8 values. Cna anyone...

I recently re-installed the software and drivers for an HP F2280 printer, Since then my spreadsheets wont print out, either I get a completely blank page, or...

Please advised on how to calculate: I have a forecast = 39,975 I have a shift qty = 7,535 shift production requirement = 5.3 (39975/7535) What formula will...

15604 15604 15604 15604 15604 16484 16484 16484 16484 16484

Hello Is there a way for updates to be made to Pivots and Graphs (charts) when a workbook is shared? Currently I have to "unshare" the workbook and refresh...

Hi to all... I am currently using Excel 2003. I am trying to use vlookup in VBA. First I have a workbook with 8 spreadsheets. I have a Master Parts List...

I have merged cells which have condiational formatting applies, the wrap text is checked and the text will not wrap. I have tried a few of the macros which...

I recently re-installed the software and drivers for an HP F2280 printer, Since then my spreadsheets wont print out, either I get a completely blank page, or...

If I create a new workbook on my desktop and insert a hyperlink that points to "C:\test.txt". If I save the workbook and re-open it, the link still works...

Excel2003 ... Range H7:DC7 contains DATES (m/dd), TEXT & EMPTY Cells. I wish Formula to return number of Dates Todays Date (exclude other TEXT & EMPTY...

I have 3 data columns. Column A has 100 data cells, Column C has 25 data cells, Column D has 25 data columns (related to column C). I would like to compare...

I have a spreadsheet which need to be shared, so a number of people can updated at the same time, the only problem is , there is a macro (userform) within...