I want to use a function to determine how many bonus tickets I should give out at the end of each month. One (1) ticket for every three (3) apples sold and...

Hi all. Forthe past 6 months, I've been working on a single workbook for a large project I'm doing. About 3 or so months ago I noticed an error when I opened...

I want to use a function to determine how many bonus tickets I should give out at the end of each month. One (1) ticket for every three (3) apples sold. For...

Hi, Depending on the values in column U, I want column V to have a value. I am using an IF formula for this. There is one problem. Some cells in Column U (eg...

I am using VBA to produce a quote worksheet with product descriptions in column C and the product price in Column F. I want to sum from Cell F6 to the last...

I would like to set up a spreadsheet to record staff leave. My point of departure is a calendar in a spreadsheet for 2008 for each employee. Should the...

hi, first of all i don't know if it's possible to do this with excel.... i have a liste wich have 4 colums column 1 article number and name (AAA-305 - cli-...

Thanks to everyone earlier who responded to my Time and Date Entry question. I'm trying to get these two strings of code to work together in the Worksheet...

I have read most of the postings for combo box set up, but I think my issue is a bit different. I am trying to put together a contact list based on specific...

Hi, I'd ,like to calculate the average of Machine 1 through 2 and Machine 5 through 11. So the range is not in one piece. Further error values have to be...

Hi I have a combo box with different months in. The user will select a month then select a button to determine what report to run. I have 5 buttons for each...

Hi, I tried to check the option of Data Validation but it was going disabled/grayed out after enabling the macros.Still I cannot find a solution for the...

I'm trying to add the amounts in a column where two other columns match the set criteria, however, it is comparing the first cell only to the text specified....

Hi Is it possible to create a formula based on the colour of a cell? I'm trying to get automatically calculating cells on a holiday/sickness database. Cells...

How do I automatically sum a variable number of rows between two delimiters? I get a monthly spreadsheet from an accounting program and add formulas to it to...

I have 2 columns of numbers - in A and B and then in column C the formula A-B. When I insert rows in either column A or B it then changes the formula in C to...

On Sheet1 I have a long list of names in column A along with the associated supervisor in column B. Column C is for the group number. On Sheet2, I have...

Hello!, I will try to be brief. A series of Excel spreadsheets were created inadvertently by a secretary using the save as feature. Each has its own name....

Comment boxes continue to get smaller from time to time and some of the text dose not appear. I can increase the size of the box so all text is showing.but...

I have a list of dollar values listed in column A. I have assign a category in column B to each of them. I want to add them by category. So for an...