General

Titles
I have a list of people in my department in column 'A'. In column 'B' I have their job titles. I want to be able to list specific job titles on different sheets. For example : John Smith Line Tech John Doe Line Tech Jane Doe Computer Analyst Amy Smith Computer Te... 31 Jan 2006 09:44

Pivot Table Sort
I have created a Pivot table grouping dates by month. The result is similar to; Jan 06 Feb 06 Mar Jun 05 Jul 05 Aug 05 Sep 05 Oct 05 Nov 05 Dec 05 How do I force it to sort so that the Jan 06 and the Feb 06 appear at the bottom of the list? Thanks Paul. -- filky -------------------------------... 30 Jan 2006 19:37

Pivot table refresh
I have a column for dates and the data is the amounts for each date in the pivot table. WHen I select refresh data after I made changes to the worksheet the dates donot refresh. Actually, the drop down to include the dates is updated but it does not change in the table itself. Please advise. -- Estandardt... 31 Jan 2006 08:42

mdb -> xls
hello, does anybody know how can i convert access mdb into excel xls file (mdb table into xls sheet) is it possible at all? i have almost 100 mdbs to convert best regards ps. i hope i wrote on proper newsgroup (if not, please write what group is best to write abou this problem) ... 30 Jan 2006 12:49

How do I compress images?
I've finished my spreadsheet. It's 7.5 megabytes in size because of picture files contained within it. I tried to email it, and though it doesn't exceed the 10 megabyte size limit apparently set by my ISP, when I try to email it, I get an error saying it exceeds that allowed 10MB size. Interesting. Anyway... 30 Jan 2006 05:24

Correlation-Coefficient
The following macro is to find the Linear Correlation-Coefficient of a selected range. I'd like to use a Selection "Rng" instead of a fixed range "C2:C11" Can it be done? Sub RSQ() Dim Rng As Variant Rng = Selection Range("G10") = "= RSQ(C2:C11,ROW(C2:C11))": _ Range("G1... 31 Jan 2006 03:21

How do I calculate cost of raw materials to final product?
I am trying to set up a template or find one already in existence to enter the size cake I need to bake in one area, and it will tell me how many eggs, oil, etc. that I need, and calculate the final price of the cake. The same with cookies, brownies, etc. for my bakery. ... 28 Jan 2006 14:28

weekly chore list for 2 kids
I am looking for a fun & functional way to make a weekly chore list for my children. With this, I would like to have rewards & benifits, for completeing these weekly chores, while earning an allowence. Also, I want to have a section for undesirable behaviors, such as tattletaling, repeating requests & attitud... 28 Jan 2006 18:44

double bar graph
I need help creating a bar graph. I have actual and budget data that I want to post along side each other for each month. I've been unable to locate this option. Please help, Thanks!! Jason ... 27 Jan 2006 20:18

time sheet
Hi, We are trying to use excel to track our hourly employee's time, we want them to access it and use it to enter their time. Does anyone know a function that would work so when they click on the box it will display the correct time? Thanks in advance, ... 27 Jan 2006 18:14