How do I create a fixed value used in a number of different calcualtions? For example I want to count the occurances of an item and multiply times a fixed...

Last part of my problem. How do I get 3 cells to replace 3 cells based on if I1=yes or no. I have information in cells c1,d1,e1 and I need to replace these...

Hi Can anyone please help? How do I do the following: I would like to extract information based on the following criteria. We open excel up and the first...

i have 41 csv files that i need to import into 41 sheets in Excel. the name of the csv files and the sheet names are the same minus the extension (.csv). The...

When I copy a worksheet to a new book excel removes part of the hyperlink directory tree from each hyperlink rendering them useless (the change is identicle...

hello i have to do a coursework for school. i have a sample of around 700 students all with have been put in to catogories of gender what year they are in and...

Is there anyway to copy an entire sheet to an existing sheet and overlay whatever was there? I know I can copy a sheet and create a new sheet, but then I have...

Hello I haven't used excel for over ten years and have been asked to amend a database of names and addresses for somebody and then sort them so he can do mail...

I'm getting this error when i run a Excel macro which connects to oracle and reads data from a table Runtime error '1004' General ODBC error this marco used...

I am using Office 2003 and am trying to do an expense sheet for a new business .I am doing a sheet for each month and need to put numbers in first column for...

I have a simple register for my envelope accounting. On the first sheet, I have the actual bank register, while on the remaining sheets, I keep track of...

I have the column A full with 252 entries. The formula I apply between cells A2 and A1 is: ln(A2/A1) and I get a result. I want to copy this formula but in a...

How do i get excel to replace words from data imported from the net. Here is the problem. I am using excel to fetch data from a flight timetable, however,...

Somehow I got the word Group on my title bar in excel, but I do not know how I did it or how to get rid of it.

is there a way to hide rows that have a certain character in that row. example B1 1 - - 4 5 The rows with a "-" gets hidden and if the cell gets data other...

I have only 2 worksheets in column A is the item # which sometimes has a letter associated with it as in 815NB in column B is the desctiption. This formula...

I have a workbook with 10 worksheets all which I use a fomrula that references a page called data. How can I change a cell reference linked to another page on...

Is there some way that when I enter an employees number in to a cell it will return the name? Thanks for your help - Dave

I have a very simple checkbook register. I would like to be able to display the ending balance in a specific cell at the top of the sheet. How can I do...

Hi all Is it possible to run a macro by entering data in a cell, and pressing Enter? Many thanks George