hello, i have a number of rows (around 2k) with data in columns. due to work needed, i need that each sheet contains no more than 50 rows. solutions: - i...

I created a macro to save a file, but I want to be able to archive it in a folder and change the name each time. As I have it noe it replaces the existing...

My page is formatted to give a 1" margin on the side. I would like the footer to indent 1" also. Where does one set the margin for...

Hi i have a league set up and want to auto sort it as i add the scores, it is in A2:F9, and i want to sort B3:F9, is there a macro that will do this for me...

How do you have your spreadsheet automatically update the total amount when changing values... ...example amount ordered price total 2 ...

My formula is =LEN(A1) and copied down. Is there a variation of this formula to count just the letters in each cell without counting the spaces between words...

Hope someone can help me he let's say I have table like the following with different situations of 'Target' and 'Result' and I want to calculate deviation...

Hi, I am trying to find a formula that allows me to know how many days an employee took as a vactaion on each month a summary sheet for each employee In order...

I need help with a formula. My excel sheet is looking at Quality on production. In Cell D is Quality Person (there are 50) and Cell E is the product they...

How can I freeze a row and a column at the same time using Excel 97? Thanks.

I have a very simple formula. I am subtracting two values and the result should be a large number. The only value returned is zero. I have checked the cell...

I have inherited a worksheet/application made in Excel 97. The person who created this has done some interesting trick to the worksheet so that none of the...

Hi, I have a worksheet that contains (to make it simple) the folowing info: Customer date shop cost sam ...

Hi, I have a nice book set up with web querys and it's doing a fantastic job for me, except for one little problem: The data does not always get imported to...

I have my data in, say row A - specifically A1:A50 - and want my calculation to look from the bottom of A50 to the top of the row (A1) and return the first...

Im new at this so here goes it............... This is what I need assistance with-- I need to create a spreadsheet that does the following : A. I need to...

I have a workbook with 12 sheets inside of it, each of these sheets is a series of names and age groups how can I extract the information on a particular group...

If i input a Date of birth as follows: 01/05/1946 how can i work out in a different cell the following: # current age # age at next birthday Help much...

Basically I have the following data: £2500 COLLECTED 01/03/2006 £3500 NOT COLLECTED 01/02/2006 £4500 COLLECTED 01/03/2006 £3000 ...

Hello- I have the program software MYOB. This generates raports and what not. I can save it as a PDF if this will help my issue. I have excel for a mac an...