TRYING TO COMPUTE THIS PRODUCTIVITY CHANGE OF A MACHINE CYCLE DOPPING FROM 17SEC TO 15 SEC . HOW DO YOU CALCULATE THE PERCENT GAIN OF 2 SECONDS.

:confused: We have a help desk ticket system server down these days. So I'll create a temporary simple data entry form in Excel sheet for the temporary...

(I've raised this in a couple of other communities - sorry to duplicate but I don't understand the procedure to cross-post) We keep getting this error when...

Hi all, I have a column of cells that I want to VLookup the answer for. It's for a snooker tournament. It could be for a golf tournament too! I have a...

I would like to keep A1 (vs R1C1 format) Cell H4 has the equation =column() The next two cells in H have the...

-- Wag more, bark less

A DOCUMENT WITH THE NAME \"BOOK1.XLS\" IS ALREADY OPENED. YOU CANNOT OPEN TWO DOCUMENTS WITH THE SAME NAME, EVEN IF THE DOCUMENT ARE IN DIFFERENT FOLDERS. TO...

Hi, I have tried to solve this problem using a mixture of text functions such as RIGHT, LEN, LEFT, FIND etc. However, am still stuck. Would appreciate...

When I try to change the formating on certain cells, one at a time or many, in a multi work book spread sheet I get a warning diolog box that says "Too many...

Working in excel a document has multiple pages how to number each page so it is printed at the bottom right of each page

I need assistance. Everyone workbook I open in Excel 2000 keeps giving me the message "A document with the '___.xls' is already open. You cannot have two...

FOR EXCEL, IS THERE A WAY TO HAVE A DROP DOWN CALENDAR THAT WILL ALLOW YOU TO CLICK A BUTTON FOR A DATE ENTRY?

I have the unfortunate task of converting a SQL Server database into a stand-alone Excel file that will store all the data, as well as act as a "front-end' for...

Basically what's happening is I have a shared drive that all the users have access to, and as far as I know have all the same permissions. What happens is, if...

I have tried to creat a farm template for my goat farm and cows but have been unsucessfull of creating on that looks profesional enuf for others to...

Seven teams have their productivity statistics logged daily. The person who entered the data only entered the date once for the first team, then skipped...

Hi all, I am putting together a spreadsheet for a weight watching club. There are 6 members, and a weight entry will be recorded each friday from 08/01/10 -...

In the following the "Macro1" does not work while "Macro1_1" does. I know I got a method to make Range("VarName") update while being a parameter in a...

Hi, I have a few questions in excel VB. 1) what is the syntax to add a new sheet into the current workbook? preferrably with a name that I specify? 2) how...

I'm trying to create a s/sheet to set up some bank payments and would like to set up a quick calculator which I can import to a Word document. Suppose I have...